Oracle feature writer may not handle null geometries properly
-------------------------------------------------------------

                 Key: GEOT-931
                 URL: http://jira.codehaus.org/browse/GEOT-931
             Project: GeoTools
          Issue Type: Improvement
          Components: data oraclespatial
    Affects Versions: 2.2.0
            Reporter: Andrea Aime
         Assigned To: Marc Risney
             Fix For: 2.2.1, 2.3


I'm testing an app that uses the gt2-oracle geometry converter to turn 
geometries into structs, and then sets the structs in a prepared statement, 
much like what the Oracle feature writer does.

Now, oracle breaks with the structs generated starting from null geometries 
(both 10g and 9i afaik), and the only solution I've found is to skip the 
geometry converter completely and simply do a:

statement.setNull(index, Types.STRUCT, "MDSYS.SDO_GEOMETRY");

I guess the same fix should be applied to OracleFeatureWriter, and the 
GeometryConverter would be better modified to throw out exceptoins when a null 
geometry is provided.

Btw, my null geometries were Points, not sure if it's relevant or not.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

-------------------------------------------------------------------------
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
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to