0 Replies Latest reply on Oct 26, 2010 1:14 PM by runner1

    JGeometry.store and multiple connections

    runner1

      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. Here is what they suggested.

       

      public static void clearDBDescriptors()
      {
      geomDesc = null;
      pointDesc = null;
      elemInfoDesc = null;
      ordinatesDesc = null;
      }

       

      Does any newer version of oracle spatial could have clearDBDescriptors() defined?

       

      Any advice please.

       

      Thanks.