JBoss Community

JGeometry.store and multiple connections

created by xiao fong in JCA - View the full discussion

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

Start a new discussion in JCA at Community