I am also having problems with Oracle spatial view and Geoserver 1.5.0. =
I am sure I have used views sometimes earlier, but I have no success in =
In order to make things as simple as possible I have created a view as a =
copy from a table that works as FeatureType (SELECT all fields without =
any WHEREs). USER_SDO_GEOM_METADATA is similar, despite TABLE_NAME, of =
course. The view works fine from SQL+. I can make FeatureType out of =
the view with administration utility and everything seems to be OK, =
including DescribeFeatureType, but all WFS queries are failing.
I have here whole lot of text captured from Geoserver console. If there =
is somebody interested in it I can send it in another mail.
L=E4hett=E4j=E4: geoserver-users-bounces@... puolesta: =
Tom (JDi Solutions)
L=E4hetetty: ti 22.5.2007 23:07
Vastaanottaja: Andrea Aime
Aihe: Re: [Geoserver-users] Problems including Views from Oracle Spatial
The view is user_sdo_geom_metadata. When you insert a record into it =
you must be logged in as the user who owns the view you're adding and =
one of the fields (diminfo) in the user_sdo_geom_meta_data view requires =
an Oracle object constructor so it's usually easier to copy one from a =
table that's already registered (usually the one you're basing the view =
on) for example:=20
INSERT INTO user_sdo_geom_metadata
(table_name, column_name, diminfo, srid)
SELECT 'my_view', 'my_spatial_column', diminfo, 4326
WHERE table_name =3D 'my_base_table';
Hope that makes sense!
On 5/22/07, Andrea Aime <aaime@...> wrote:=20
Tim Englich ha scritto:
> I try to integrate a View from Oracle Spatial as an FeatureType to =
> 1.5.0 using the Webfrondend.
> This failed.
> When I configure the FeatureType manually by creating an Folder with =
> and schema.xml everything works fine.
> Has anyone an Idea how I can tell the Webfrontend to do this?
Well, usually you have to register view against some metadata table...
can't remember the exact name, there should be some=20
USER_GEOMETRY_COLUMNS updatable view in MSYS_SDO (trying to remember,
haven't checked so names may be quite a bit off the real ones).
Anyways, did you see any error in the Geoserver log when your attempt
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take=20
control of your XML. No limits. Just data. Click to get it now.
Geoserver-users mailing list=20