Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-15043

connection helper should unwrap transql connection handles

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.9.5
    • Fix Version/s: 6.0
    • Component/s: Runtime

      Description

      When creating the oracle schema, our driver is requesting a direct access to the physical connection, but we didn't improved the method for supporting transql connection handles.

      Caused by: org.nuxeo.ecm.core.storage.StorageException: Failed to get ancestors ids
              at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.getAncestorsIds(JDBCMapper.java:975)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:606)
              at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.doInvoke(JDBCMapperConnector.java:22)
              at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapperConnector.invoke(JDBCMapperConnector.java:56)
              at com.sun.proxy.$Proxy87.getAncestorsIds(Unknown Source)
              at org.nuxeo.ecm.core.storage.sql.SoftRefCachingMapper.getAncestorsIds(SoftRefCachingMapper.java:114)
              at org.nuxeo.ecm.core.storage.sql.SessionImpl.getHierarchyAndAncestors(SessionImpl.java:1350)
              at org.nuxeo.ecm.core.storage.sql.SessionImpl.getNodesByIds(SessionImpl.java:796)
              at org.nuxeo.ecm.core.storage.sql.SessionImpl.getNodesByIds(SessionImpl.java:924)
              at org.nuxeo.ecm.core.storage.sql.ra.ConnectionImpl.getNodesByIds(ConnectionImpl.java:205)
              at org.nuxeo.ecm.core.storage.sql.coremodel.SQLSession.getDocumentsById(SQLSession.java:675)
              ... 54 more
      Caused by: java.sql.SQLException
              at org.nuxeo.ecm.core.storage.sql.jdbc.dialect.DialectOracle.createArrayOf(DialectOracle.java:713)
              at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.setToPreparedStatementIdArray(JDBCRowMapper.java:815)
              at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper.getAncestorsIds(JDBCMapper.java:940)
              ... 67 more
      Caused by: java.lang.reflect.InvocationTargetException
              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
              at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
              at org.nuxeo.ecm.core.storage.sql.jdbc.dialect.DialectOracle.createArrayOf(DialectOracle.java:708)
              ... 69 more
      Caused by: java.lang.ClassCastException: org.tranql.connector.jdbc.ConnectionHandle cannot be cast to oracle.jdbc.OracleConnection
              at oracle.sql.TypeDescriptor.setPhysicalConnectionOf(TypeDescriptor.java:832)
              at oracle.sql.TypeDescriptor.<init>(TypeDescriptor.java:586)
              at oracle.sql.ArrayDescriptor.<init>(ArrayDescriptor.java:224)
              ... 74 more
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: