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

xiao fong do-not-reply at jboss.com
Tue Oct 26 12:26:31 EDT 2010


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&containerType=14&container=2098]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20101026/825661f9/attachment.html 


More information about the jboss-user mailing list