[jboss-user] [JCA] - JGeometry.store and multiple connections

xiao fong [http://community.jboss.org/people/runner1] created the discussion "JGeometry.store and multiple connections" To view the discussion, visit: http://community.jboss.org/message/568490#568490 -------------------------------------------------------------- Hi, For some reason, I am getting the following error: Caused by: java.sql.SQLException: Cannot construct ARRAY instance, invalid connection at oracle.sql.ARRAY.<init>(ARRAY.java:141) at oracle.spatial.geometry.JGeometry.store(JGeometry.java:1289) at com.navteq.dc.hibernate.JGeometryType.nullSafeSet(JGeometryType.java:223) at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:146) at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1992) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2366) ... 99 more 09:28:49,131 ERROR [ContainerBase] Servlet.service() for servlet diciWebTools threw exception java.sql.SQLException: Cannot construct ARRAY instance, invalid connection at oracle.sql.ARRAY.<init>(ARRAY.java:141) at oracle.spatial.geometry.JGeometry.store(JGeometry.java:1289) Caused by: java.sql.SQLException: Cannot construct ARRAY instance, invalid connection at oracle.sql.ARRAY.<init>(ARRAY.java:141) at oracle.spatial.geometry.JGeometry.store(JGeometry.java:1289) at com.mycompany.dc.hibernate.JGeometryType.nullSafeSet(JGeometryType.java:223) at org.hibernate.type.CustomType.nullSafeSet(CustomType.java:146) at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1992) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2366) ... 99 more I have found some blogs online. I am not sure if there are other solutions. Here is what they suggested. public static void clearDBDescriptors() { geomDesc = null; pointDesc = null; elemInfoDesc = null; ordinatesDesc = null; } Any advice please. Thanks. -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/568490#568490] Start a new discussion in JCA at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]