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?
Best Regards,
Gerhard
--
Gerhard Sommer
Magistrat Wien (MA 14-ADV), Rathausstraße 1, 1082 Wien, Austria
E-Mail: som@anonymised.com
Tel: +43 (1) 4000 91326
Fax: +43 (1) 4000 99 91326
The Oracle Datastore hasn't had as much QA as PostGIS for example. There's likely a bug in the code. If you're able to get in to the Java I'm happy to point you where to look to fix the problem. I doubt it should be that hard to fix...
Chris
Sommer Gerhard wrote:
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?
Best Regards,
Gerhard
--
Gerhard Sommer
Magistrat Wien (MA 14-ADV), Rathausstraße 1, 1082 Wien, Austria
E-Mail: som@anonymised.com
Tel: +43 (1) 4000 91326
Fax: +43 (1) 4000 99 91326
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
!DSPAM:1003,4486ee74256461460912952!
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org