getting underlying oracle connection from Poolable connection

[Ajju Chawla]

Hi,

Iam want to pass an Array to a oracle procedure for which Iam using ArrayDescriptor.

ArrayDescriptor descriptor =
ArrayDescriptor.createDescriptor( "NUM_ARRAY", conn );
System.out.println("224");
ARRAY array_to_pass =
new ARRAY( descriptor, conn, lRelVersions );

Now the problem is that it is giving me ClassCastException when I pass the Poolabale Connection in the ArrayDescriptor.createDescriptor(), as it requires Oracle Connection.

Can anybody tell me how do I get the underlying Oracle connection from Poolable connection.
I tried the getDelegate() method but its not working.

Iam using commons-dbcp-1.2.1.jar, commons-pool-1.2.jar and classes12.jar

Thanks
-Aj

[Abhisheka Agarwal]

Hi Ajju,
Did you got the solution for this? I am facing the same problem

Regards
Abhishek