How to reuse ArrayDescriptor?

Question

I tried the code below:

public class Abc { private ArrayDescriptor arrayDesc; void init() { connection = //create connection arrayDesc = ArrayDescriptor.createDescriptor("DBTYPE",connection); } void m1() { conn1 = //create connection ARRAY array_to_pass1 = new ARRAY( arrayDesc , conn1, idsArray1 ); } void m2() { conn2 = //create connection ARRAY array_to_pass2 = new ARRAY( arrayDesc , conn2, idsArray2 ); } } 

This code reports the error below:

table.java.sql.SQLException: Missing handle at oracle.sql.DatumWithConnection.assertNotNull (DatumWithConnection.java:103)

How can this be solved?

Answer 1

ArrayDescriptor is deprecated. Assuming your connection objects are of type OracleConnection , try using createOracleArray - something like this:

 public class Abc { void init() { connection = //create connection } void m1() { conn1 = //create connection array array_to_pass1 = conn1.createOracleArray(arrayDesc, idsArray1); } void m2() { conn2 = //create connection array array_to_pass2 = conn2.createOracleArray(arrayDesc, idsArray2); } } 

Note. Using this method, arrays will be of type java.sql.Array , not oracle.sql.ARRAY .

Answer 2

new ARRAY must be called using an ArrayDescriptor that uses the same connection. What you are trying to do will not work. Note that each connection has a descriptor cache, so the descriptor will only be created once per connection.