java.sql.SQLException: Cannot construct ARRAY instance, invalid connection

Oracle Community | 271872 | 1 decade ago
  1. 0

    JGeometry doesn't work with multiple connections...

    Oracle Community | 1 decade ago | 271872
    java.sql.SQLException: Cannot construct ARRAY instance, invalid connection
  2. 0

    Problem with JGeometry.store method while using Thick driver.

    Oracle Community | 1 decade ago | 452043
    java.sql.SQLException: Cannot construct ARRAY instance, invalid connection
  3. 0

    Fail to convert to internal representation in Store procedure

    Stack Overflow | 2 years ago
    java.sql.SQLException: Fail to convert to internal representation: Blindingtpe
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java Oracle oracle.sql.ARRAY error

    Stack Overflow | 3 years ago
    java.sql.SQLException: Fail to convert to internal representation: javax.sql.rowset.serial.SerialBlob@d316ee
  6. 0

    Eclipse Community Forums: EclipseLink ยป PLSQLStoredProcedureCall Fail to convert to internal representation

    eclipse.org | 1 year ago
    java.sql.SQLException: Fail to convert to internal representation: Error Code: 17059 Call: DECLARE P_RECORDS_TARGET HR_DEPARTMENTS.DEPTTABTYPE; P_RECORDS_COMPAT HR_DEPARTMENT_TYPE := :1; FUNCTION EL_SQL2PL_1(aSqlItem HR_DEPARTMENT_ROW_TYPE) RETURN HR_DEPARTMENTS.DEPARTMENTRECTYPE IS aPlsqlItem HR_DEPARTMENTS.DEPARTMENTRECTYPE; BEGIN aPlsqlItem.DEPARTMENT_ID := aSqlItem.DEPARTMENT_ID; aPlsqlItem.DEPARTMENT_NAME := aSqlItem.DEPARTMENT_NAME; aPlsqlItem.LOCATION_ID := aSqlItem.LOCATION_ID; aPlsqlItem.MANAGER_ID := aSqlItem.MANAGER_ID; RETURN aPlsqlItem; END EL_SQL2PL_1; FUNCTION EL_SQL2PL_3(aSqlItem HR_DEPARTMENT_TYPE) RETURN HR_DEPARTMENTS.DEPTTABTYPE IS aPlsqlItem HR_DEPARTMENTS.DEPTTABTYPE; BEGIN IF aSqlItem.COUNT > 0 THEN FOR I IN 1..aSqlItem.COUNT LOOP aPlsqlItem(I) := EL_SQL2PL_1(aSqlItem(I)); END LOOP; END IF; RETURN aPlsqlItem; END EL_SQL2PL_3; BEGIN P_RECORDS_TARGET := EL_SQL2PL_3(P_RECORDS_COMPAT); HR_DEPARTMENTS.INSERTDEPARTMENTS(P_RECORDS=>P_RECORDS_TARGET); END; bind => [:1 => [ , ]] Query: DataReadQuery()

    2 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      Cannot construct ARRAY instance, invalid connection

      at oracle.sql.ARRAY.<init>()
    2. Oracle jdbc
      ARRAY.<init>
      1. oracle.sql.ARRAY.<init>(ARRAY.java:123)
      1 frame
    3. oracle.spatial.geometry
      JGeometry.store
      1. oracle.spatial.geometry.JGeometry.store(JGeometry.java:1289)
      1 frame