[Geoserver-users] Add an Oracle view as a featuretype

GeoServer GeoServer User
1

Hello

I just created a view named TSV_TA_GIS_G5 in Oracle which contain 6 fields:
One containing the Geometry called GEOMETRY and others containing binary
data.

I tried to load the view in Geoserver and i have obtained the following
message:
No geometry column row for srid in table: TSV_TA_GIS_G5, geometry column
GEOMETRY, be sure column is defined in USER_SDO_GEOM_METADATA

I think my problem is that this view has not been declared in
USER_SDO_GEOM_METADATA or the spatial index is missing. Can someone explain
me how to create correctly this view to make it interacting with Geoserver?

Many thanks

Sylvain

--
View this message in context: http://www.nabble.com/Add-an-Oracle-view-as-a-featuretype-tp17236126p17236126.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

2

springrider ha scritto:

Hello

I just created a view named TSV_TA_GIS_G5 in Oracle which contain 6 fields:
One containing the Geometry called GEOMETRY and others containing binary
data.

I tried to load the view in Geoserver and i have obtained the following
message:
No geometry column row for srid in table: TSV_TA_GIS_G5, geometry column
GEOMETRY, be sure column is defined in USER_SDO_GEOM_METADATA

I think my problem is that this view has not been declared in
USER_SDO_GEOM_METADATA or the spatial index is missing. Can someone explain
me how to create correctly this view to make it interacting with Geoserver?

Instructions at the bottom of this page will hopefully work:
http://geoserver.org/display/GEOSDOC/Oracle+DataStore

Cheers
Andrea

3

Thanks

It works beautifully

Sylvain

aaime wrote:

springrider ha scritto:

Hello

I just created a view named TSV_TA_GIS_G5 in Oracle which contain 6
fields:
One containing the Geometry called GEOMETRY and others containing binary
data.

I tried to load the view in Geoserver and i have obtained the following
message:
No geometry column row for srid in table: TSV_TA_GIS_G5, geometry column
GEOMETRY, be sure column is defined in USER_SDO_GEOM_METADATA

I think my problem is that this view has not been declared in
USER_SDO_GEOM_METADATA or the spatial index is missing. Can someone
explain
me how to create correctly this view to make it interacting with
Geoserver?

Instructions at the bottom of this page will hopefully work:
http://geoserver.org/display/GEOSDOC/Oracle+DataStore

Cheers
Andrea

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://www.nabble.com/Add-an-Oracle-view-as-a-featuretype-tp17236126p17274020.html
Sent from the GeoServer - User mailing list archive at Nabble.com.