[Geoserver-users] WFS-T in Oracle Spatial

Aitor_Calero_Garcia · February 13, 2007, 5:49pm

your problem is that the SRIDs have to be the same in the tables of
your Oracle Database and in the user_sdo_geom_metadata.

They are the same already!!!

I am sure of that. This is my error:

org.geotools.data.DataSourceException: SQL Exception writing geometry columnORA-29875: fallo al ejecutar la rutina ODCIINDEXINSERT
ORA-13365: el SRID de nivel no coincide con el SRID de geometría
ORA-06512: en "MDSYS.SDO_INDEX_METHOD_9I", línea 319
ORA-06512: en línea 1

It seems that geoserver cannot translate correctly
<gml:MultiLineString srsName="epsg:23030">
to Oracle SRID 82337, its counterpart in my database

I will try to create a new layer without SRID in Oracle to test if it works.

Fernando_Zuriaga · February 13, 2007, 6:06pm

I have the same problem with oracle SIDs. When you insert new layers from
geoserver form, you must set the EPSG to 23030. I add to the file
espg.properties (inside of epsg.jar) new espg with ID=82337 (copy of
EPSG:23030) in the lib directory of the server. In my case it works fine....

Regards...

-----Mensaje original-----
De: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net] En nombre de Aitor
Calero Garcia
Enviado el: martes, 13 de febrero de 2007 18:49
Para: José Enrique Soriano Sevilla; geoserver-users@lists.sourceforge.net
Asunto: Re: [Geoserver-users] WFS-T in Oracle Spatial

your problem is that the SRIDs have to be the same in the tables of
your Oracle Database and in the user_sdo_geom_metadata.

They are the same already!!!

I am sure of that. This is my error:

org.geotools.data.DataSourceException: SQL Exception writing geometry
columnORA-29875: fallo al ejecutar la rutina ODCIINDEXINSERT
ORA-13365: el SRID de nivel no coincide con el SRID de geometría
ORA-06512: en "MDSYS.SDO_INDEX_METHOD_9I", línea 319
ORA-06512: en línea 1

It seems that geoserver cannot translate correctly <gml:MultiLineString
srsName="epsg:23030"> to Oracle SRID 82337, its counterpart in my database

I will try to create a new layer without SRID in Oracle to test if it works.

-------------------------------------------------------------------------
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

Hans-Ulrich_Otto · February 15, 2007, 9:36am

Dear all,

Just another idea: Oracle supports as of version 10gR2 also the EPSG codes directly. I.e. you can use 4326 instead of 8307.

Best regards,

Uli.

-----Original Message-----
From: geoserver-users-bounces@lists.sourceforge.net [mailto:geoserver-users-bounces@lists.sourceforge.net] On Behalf Of Fernando Zuriaga
Sent: Dienstag, 13. Februar 2007 19:07
To: 'Aitor Calero Garcia'; 'José Enrique Soriano Sevilla'; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] WFS-T in Oracle Spatial

I have the same problem with oracle SIDs. When you insert new layers from geoserver form, you must set the EPSG to 23030. I add to the file espg.properties (inside of epsg.jar) new espg with ID=82337 (copy of
EPSG:23030) in the lib directory of the server. In my case it works fine....

Regards...

-----Mensaje original-----
De: geoserver-users-bounces@lists.sourceforge.net
[mailto:geoserver-users-bounces@lists.sourceforge.net] En nombre de Aitor Calero Garcia Enviado el: martes, 13 de febrero de 2007 18:49
Para: José Enrique Soriano Sevilla; geoserver-users@lists.sourceforge.net
Asunto: Re: [Geoserver-users] WFS-T in Oracle Spatial

your problem is that the SRIDs have to be the same in the tables of
your Oracle Database and in the user_sdo_geom_metadata.

They are the same already!!!

I am sure of that. This is my error:

org.geotools.data.DataSourceException: SQL Exception writing geometry
columnORA-29875: fallo al ejecutar la rutina ODCIINDEXINSERT
ORA-13365: el SRID de nivel no coincide con el SRID de geometría
ORA-06512: en "MDSYS.SDO_INDEX_METHOD_9I", línea 319
ORA-06512: en línea 1

It seems that geoserver cannot translate correctly <gml:MultiLineString srsName="epsg:23030"> to Oracle SRID 82337, its counterpart in my database

I will try to create a new layer without SRID in Oracle to test if it works.

-------------------------------------------------------------------------
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