During compilation of the patch I referenced the jars distributed with
geoserver, as well as the jar gt2-oracle-spatial-2.2-RC3.jar during
compilation. I assume that this is version 2.2.x from GeoTools + latest
version of oracle-spatial plugin.
Michael.
-----Mensaje original-----
De: Chris Holmes [mailto:cholmes@anonymised.com]
Enviado el: lunes, 26 de junio de 2006 15:52
Para: Paul, Michael
CC: geoserver-users@lists.sourceforge.net
Asunto: Re: [Geoserver-users] inserting features with WFS-T into OracleSp
atial data store fails because of incorrect SRID
Awesome, thanks!
What version of GeoTools is this against? 2.2.x?
Paul, Michael wrote:
Hi folks,
with the hints posted previously to this list, I have generated a
small patch that is working OK for my purposes. To explain, whenever a
geometry has set an SRID of 0 (which does not exist in Oracle), now
the code is assigning the NULL value for the SRID. Hence, the fix to
me works fine as the SRID column contains NULL within
user_sdo_geom_metadata view in our environment. I assume that most
other people will also find a null value there, as most tools which
load data into Oracle Spatial do not assign any SRID and leave this column
NULL.
A real bug fix should obtain the correct SRID value from the
user_sdo_geom_metadata view and reproject the geometry to be
inserted/updated if necessary.Please find attached a patched .jar file which I am currently using
for geoserver + Oracle Spatial, as well as the changed source file
(the changed line is 130).
Diff:
130c130
< NUMBER SDO_SRID = srid == SDO.SRID_NULL ? null :
---NUMBER SDO_SRID = (srid == SDO.SRID_NULL || srid == 0) ? null :
Regards,
Michael.
!DSPAM:1003,449fc7f033341362196140!
----------------------------------------------------------------------
--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=1216
42!DSPAM:1003,449fc7f033341362196140!
----------------------------------------------------------------------
--_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users!DSPAM:1003,449fc7f033341362196140!
--
Chris Holmes
The Open Planning Project
http://topp.openplans.org