Hi,
=20
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 =
it now.
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.
=20
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.
=20
Regards,
=20
-Jukka Rahkonen-
=20
________________________________
L=E4hett=E4j=E4: geoserver-users-bounces@... puolesta: =
Tom (JDi Solutions)
L=E4hetetty: ti 22.5.2007 23:07
Vastaanottaja: Andrea Aime
Kopio: geoserver-users@...
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
FROM user_sdo_geom_metadata=20
WHERE table_name =3D 'my_base_table';
Hope that makes sense!
On 5/22/07, Andrea Aime <aaime@...> wrote:=20
Tim Englich ha scritto:
> Hello,
>
> I try to integrate a View from Oracle Spatial as an FeatureType to =
Geoserver
> 1.5.0 using the Webfrondend.
> This failed.
> When I configure the FeatureType manually by creating an Folder with =
info.xml
> and schema.xml everything works fine.
> Has anyone an Idea how I can tell the Webfrontend to do this?
=09
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
failed?
=09
Cheers
Andrea
=09
=
-------------------------------------------------------------------------=
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.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list=20
Geoserver-users@...
https://lists.sourceforge.net/lists/listinfo/geoserver-users=20
=09
|