Hi List,

When I try to insert a point into my OracleSpatial table I get an exception in my DeegreeViewer.
 
My WFS Insert request
------------------------
<?xml version="1.0" encoding="UTF-8"?>
<Transaction xmlns:gml="http://www.opengis.net/gml">
<Insert>
<Rect fid="ID3">
<Rect.ID>3</Rect.ID>
<Rect.Name>GEOM_3</Rect.Name>
<Rect.Geom>
<gml:Point srsName="EPSG:4326">
   <gml:coordinates cs="," decimal="." ts=" ">6.79,50.66</gml:coordinates>
</gml:Point>
</Rect.Geom>
</Rect>
</Insert>
</Transaction>
 
Tomcat Log
---------------
Debug message: SELECT * FROM RECTANGLES WHERE ID= 3
SELECT * FROM RECTANGLES WHERE ID= 3
Debug message: INSERT INTO RECTANGLES (ID,GEOM,NAME) VALUES(3,MDSYS.SDO_GEOMETRY ( 2001, null, MDSYS.SDO_POINT_TYPE (6.79,50.66,null), null, null),'GEOM_3')
l7 Message: ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-13365: layer SRID does not match geometry SRID
ORA-06512: at "MDSYS.SDO_IDX", line 161
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 332
---------------------------
From the tomcat log I understand that the query
INSERT INTO RECTANGLES (ID,GEOM,NAME) VALUES(3,MDSYS.SDO_GEOMETRY ( 2001, null, MDSYS.SDO_POINT_TYPE (6.79,50.66,null), null, null),'GEOM_3')
is fired, which is obviously going to fail since it doesn't specify SRID.
If I manually run the same query putting SRID as 8307
INSERT INTO RECTANGLES (ID,GEOM,NAME) VALUES(3,MDSYS.SDO_GEOMETRY ( 2001, 8307, MDSYS.SDO_POINT_TYPE (6.79,50.66,null), null, null),'GEOM_3')
the record gets inserted.
 
Where should I specify my SRID in my 'WFS Insert Request'.
 
My DatastoreConfiguration has specified the SRID and EPSG specified.
.
.
.
<MasterTable name="Rectangles" targetName="Rect">
   <IdField number="true" auto="false">ID</IdField>
    <GeoFieldIdentifier>Geom</GeoFieldIdentifier>
</MasterTable>
<CRS>EPSG:4326</CRS>
<InternalCRS>8307</InternalCRS>
</FeatureType>
</DatastoreConfiguration>
 
I hope there is no problem with the Datastoreconfiguration since my select queries are working.
 
So where should I specify SRID in my wfs insert request.
 
Kindly


Relax. Yahoo! Mail virus scanning helps detect nasty viruses!