Hallo @all,
does anybody know something new about the "inserting features with WFS-T into Oracle"-Problem?
I tried to INSERT a POINT in an Oracle DB with the geoserver-1.5.1 and it fails (PostGIS works fine).
Am I doing something wrong or is there still a Bug/Error with the SRID/EPSG - Code?
I'm using Oracle 10g RC2 (with EPSG-Support), what I've done:
=> Created table
=> Filled the USER_SDO_GEOM_METADATA with SRID =4326
=> Created an Spatial Index with PARAMETERS ('SDO_INDX_DIMS=2 LAYER_GTYPE=POINT')
=> PrimaryKey on a NUMBER Column
In geoserver:
=> Created Datastore
=> Created FeatureType with SRS:4326
=> Request:
<wfs:Transaction service="WFS" version="1.0.0"
xmlns:wfs="http://www.opengis.net/wfs"
xmlns:topp="http://www.openplans.org/topp"
xmlns:gml="http://www.opengis.net/gml"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd http://www.openplans.org/topp http://localhost:8080/geoserver/wfs/DescribeFeatureType?typename=topp:TEST_POINT">
<wfs:Insert>
<topp:TEST_POINT>
<topp:GEOM>
<gml:Point srsName="http://www.opengis.net/gml/srs/epsg.xml#4326">
<gml:coordinates decimal="." cs="," ts=" ">6.66,50.50</gml:coordinates>
</gml:Point>
</topp:GEOM>
<topp:NAME>Insert_from_Geoserver</topp:NAME>
</topp:TEST_POINT>
</wfs:Insert>
</wfs:Transaction>
--------------------------
Error Message:
--------------------------
in english
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
in german:
org.geotools.data.DataSourceException: SQL Exception writing geometry columnORA-29875: Routine ODCIINDEXINSERT nicht erfolgreich ausgeführt
ORA-13365: Ebenen-SRID stimmt nicht mit Geometrie-SRID überein
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_10I", Zeile 623
ORA-06512: in "MDSYS.SDO_INDEX_METHOD_10I", Zeile 227
--------------------------
Regards,
Greq
--
---------------------------------------
WhereGroup GmbH & Co. KG
Siemensstraße 8
53121 Bonn
-------------------------------
Fon: +49 (0)228 / 90 90 38 - 25
Fax: +49 (0)228 / 90 90 38 - 11
-------------------------------
Dipl. Ing. (FH) Gregor Fikoczek
mailto:gregor.fikoczek@anonymised.com
mailto:info@anonymised.com
http://www.wheregroup.com
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRA 6788
---------------------------------------