[Geoserver-users] WFS-T and oracle

Hans-Ulrich_Otto · August 31, 2006, 9:50am

Hello Jukka,

We experienced the same problem with KKJ and Oracle and found a workaround:
Please try SRID 294914, even though the definition claims KKJ is the same as ED50, which is not true.
We use it for KKJ, and e.g. reprojection into WGS84 works fine, using Oracle transformation.

Cheers,

Uli.

-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net [mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of Rahkonen Jukka
Sent: Donnerstag, 31. August 2006 11:46
To: geoserver-users@lists.sourceforge.net; geoserver-devel@anonymised.come.net
Subject: Re: [Geoserver-users] WFS-T and oracle

Hello Daniel,

Thank you for the information about how it is possible to insert data to Oracle 9i spatial through Geoserver WFS-T. I will insert "null" as my Oracle SRID, in my case it does not matter too much because Oracle has wrong parameters for the Finnish-KKJ coordinate system so reprojection etc. gives wrong results anyway.

Oracle 9 may remain problematic because of the different SRID coding but let's hope that this problem could be solved with Oracle 10g supporting EPSG codes as simply as adding EPSG-SRID to the SQL that Geoserver is sending to Oracle. Is there anybody out there who could make a try with this?

Regards,

-Jukka Rahkonen-

-----Alkuperäinen viesti-----
Lähettäjä: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net]
Puolesta Daniel Goetz
Lähetetty: 31. elokuuta 2006 12:28
Vastaanottaja: geoserver-users@lists.sourceforge.net;
geoserver-devel@lists.sourceforge.net
Aihe: [Geoserver-users] WFS-T and oracle

Dear geoserver developers,

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 of the new inserted feature instance and so the
insert request fails.

The next thing I tried was to set the SRID for all the
existing feature instances to NULL. Likewise I set the SRID
in the USER_SDO_GEOM_METADATA to NULL. After that I created a
new spatial index (R-Tree). Then I tried to do a WFS-T insert
request again. And it works (now with a spatial index).

So the "only" problem seems to be that geoserver does not
look what SRID my feature type table is in or rather does not
fill in that SRID but inserts "NULL".

So I want to ask you (dear developers) if you could solve
this problem? Do you think I am right and inserting data via
WFS-T in oracle spatial doesn't work propberly because of the
wrong SRID insert geoserver does? Or perhaps you can tell me
which file of the geoserver source code is responsible for
the SRID selection?

Thank you so much for your help and your technical expertise.

regards

Daniel

--

Echte DSL-Flatrate dauerhaft für 0,- Euro*. Nur noch kurze Zeit!
"Feel free" mit GMX DSL: http://www.gmx.net/de/go/dsl

--------------------------------------------------------------
-----------
Using Tomcat but need to do more? Need to support web
services, security?
Get stuff done quickly with pre-integrated technology to make
your job easier Download IBM WebSphere Application Server
v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&
dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users