[Geoserver-devel] [jira] Created: (GEOS-639) Bad SRIDs when inserting Oracle spatial with WFS-T

Bad SRIDs when inserting Oracle spatial with WFS-T
--------------------------------------------------

         Key: GEOS-639
         URL: http://jira.codehaus.org/browse/GEOS-639
     Project: GeoServer
        Type: Bug

  Components: Oracle
    Versions: 1.3.1
    Reporter: Chris Holmes
Assigned to: Chris Holmes
     Fix For: 1.3.2
Attachments: GeometryConverter.java

From: Gerhard Sommer

Hello,

I am currently evaluating, if GeoServer (1.3.1) WFS-T can be used to edit data in Oracle Spatial (10g) feature types.

My feature type is in EPSG:31286 coordinate system, but GeoServer seems to always insert features with Oracle SRID 0 into the Oracle Spatial layer.
SRID = 0 is not defined in the USER_SDO_GEOM_METADATA table. Therefore, if I try to create a spatial index, this is not possible as the SRID values differ (I have 31286 in USER_SDO_GEOM_METADATA, corresponding to the EPSG code of my data). On the other hand, if I already have a spatial index on my data and try to insert geometry using GeoServer, I also get an the error message, that SRID of the geometry does not match the SRID of USER_SDO_GEOM_METADATA.

What can I do to solve this problem? Or is this a bug in the current GeoServer version?

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira