[ https://issues.jboss.org/browse/TEIID-2502?page=com.atlassian.jira.plugin... ] luca gioppo commented on TEIID-2502: ------------------------------------ The query is a select so it seems that the getObject method does not work as expected (why it issues a writeObject??). The actual value of the geometry column is a SDO_POINT_TYPE (I believe the DB is not under my complete control :-) I'm the virtualizator guy that has to do the magic on a black box :( ) it should be a struct. --- from Oracle site --- oracle.spatial.geometry.JGeometry All Implemented Interfaces: java.io.Serializable, java.lang.Cloneable public class JGeometry extends java.lang.Object implements java.lang.Cloneable, java.io.Serializable A Java class that maps Oracle Spatial's SQL type MDSYS.SDO_GEOMETRY. Supports only Oracle JDBC Driver version 8.1.7 or higher. Provides basic access functions to the geomeries stroed in Oracle Spatial database. Note that this class is not synchornized, meaning if one thread is reading this geometry and another is modifying it (such as changing its ordinates array), there may be in-consistencies. The main methods for reading/writing db geometries are: load(STRUCT) and store(). Here is a simple example showing how to use these two methods: /// reading a geometry from database ResultSet rs = statement.executeQuery("SELECT geometry FROM states where name='Florida'"); STRUCT st = (oracle.sql.STRUCT) rs.getObject(1); //convert STRUCT into geometry JGeometry j_geom = JGeometry.load(st); // ... manipulate the geometry or create a new JGeometry ... /// writing a geometry back to database PreparedStatement ps = connection.prepareStatement("UPDATE states set geometry=? where name='Florida'"); //convert JGeometry instance to DB STRUCT STRUCT obj = JGeometry.store(j_geom, connection); ps.setObject(1, obj); ps.execute(); --- end --- So maybe a struct could be better than object? Is something that can be tried on my part or a patch yuo need to address? I believe that using JTS could help (to get an open source licenced lib), but have not other hints. There is a bug on the hibernatespatial http://www.hibernatespatial.org/jira/browse/HIBSPA-21, but do not know if can be of any help. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira