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