[Geoserver-users] WFS-T and oracle

Hans-Ulrich_Otto · August 30, 2006, 8:54am

Hi again,

Some further notes on this, as I studied the Oracle spatial manual more in detail on EPSG. In section 6.4 it is mentioned that with 10gR2 Oracle switched to the EPSG model. The old Oracle SRID codes will certainly be supported for a long time but are legacy.
I did following query:
select * from sdo_coord_ref_sys where SRID = 8307 or SRID = 4326;
The output is:
SRID COORD_REF_SYS_NAME COORD_REF_SYS_KIND COORD_SYS_ID DATUM_ID GEOG_CRS_DATUM_ID SOURCE_GEOG_SRID PROJECTION_CONV_ID CMPD_HORIZ_SRID CMPD_VERT_SRID INFORMATION_SOURCE DATA_SOURCE IS_LEGACY LEGACY_CODE LEGACY_WKTEXT LEGACY_CS_BOUNDS IS_VALID SUPPORTS_SDO_GEOMETRY
------- ----------------------------- --------------------- --------------- ----------- -------------------- ------------------- --------------------- ------------------ ----------------- ------------------------------------------------- -------------- ------------ -------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- ----------- ------------------------
4326 WGS 84 GEOGRAPHIC2D 6422 6326 6326 (null) (null) (null) (null) EPSG. See 3D CRS for original information source. EPSG FALSE (null) (null) (null) TRUE TRUE
8307 Longitude / Latitude (WGS 84) GEOGRAPHIC2D 6405 10115 10115 (null) (null) (null) (null) Oracle (null) TRUE (null) GEOGCS [ "Longitude / Latitude (WGS 84)", DATUM ["WGS 84", SPHEROID ["WGS 84", 6378137, 298.257223563]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal Degree", 0.01745329251994330]] (null) TRUE TRUE

So both do exist, and 8307 is marked as LEGACY.
In my understanding this means the EPSG codes can be directly used as SRID code, when creating new geometry. I believe this would solve the problem mentioned below when using an Oracle 10gR2 (or higher), and the data store would insert the EPSG code directly as SRID.

Best regards,
Uli.

-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net [mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of Hans-Ulrich Otto
Sent: Dienstag, 29. August 2006 17:48
To: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] WFS-T and oracle

Hi,
Oracle supports EPSG in the latest version 10gRelease 2:
" New in 10g Release 2! Coordinate system support based on the European Petroleum Survey Group (EPSG) data model" (Citation from manual)

Please check the spatial manual for details, but e.g. there are stored procedures to convert EPSG into SRID: SDO_CS.MAP_EPSG_SRID_TO_ORACLE
Maybe this is helpful for future data stores,

Uli.

-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net [mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of Rahkonen Jukka
Sent: Dienstag, 29. August 2006 15:15
To: Daniel Goetz; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] WFS-T and oracle

Hi,

I suppose you do nothing wrong. I have also tried to insert something to Oracle spatial through Geoserver with no success. It's a pity that Oracle is using own SRID codes which do not correrpond to anything else in the world. Could it be possible to implement even a manual set up for Oracle featuretype so that the user could make Geoserver to use some EPSG-SRID for it's own purposes, but tell to use another Oracle-SRID when discussing with it?

Regards,

-Jukka Rahkonen-

________________________________

Lähettäjä: geoserver-users-bounces@lists.sourceforge.net puolesta: Daniel Goetz
Lähetetty: ti 29.8.2006 15:55
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: [Geoserver-users] WFS-T and oracle

Hi community,

I am using geoserver 1.4 (windows installer) and apache 2.0.58. Now I want to do a WFS-T insert request. The data of the WFS lie in a oracle spatial database.

Every time I do my insert request I get the following error message:

org.geotools.data.DataSourceException: SQL Exception writing geometry columnORA-29875: Routine ODCIINDEXINSERT is not executed successfully
ORA-13365: Layer-SRID does not correspond to the Geometry-SRID
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_9I", line 210
ORA-06512: in line 1

So I droped the spatial index for the relevant featuretype in my oracle spatial database and tried to insert the data again. Everything went fine the data were inserted. Only the entry for SRID in the SDO_SRID array in the GEOM column was 'wrong". The value geoserver fills in is 'NULL'. But it should be '82032' as it was defined in the ALL_SDO_GEOM_METADATA.

Hence I know why geoserver brings up the error message (when having a spatial index) saying: "ODCIINDEXINSERT is not executed successfully, Layer-SRID does not correspond to the Geometry-SRID" because the Layer-SRID is "82032" and geoserver tries to insert SRID-value "NULL" for the GEOMETRY-SRID.

Has anybody a solution for this problem? How can I tell geoserver to take the SRID out of the ALL_SDO_GEO_METADATA and put this value as the SDO_SRID value of the "new" entry? Is there allready a bugfix done? Or what else can I do? Is there anybody that has the same problems? Or what did I do wrong?

Thank you so much for any ideas and help and support. Thank you.

regards

Daniel

--

Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users