wood burning stoves*
The moose likes JDBC and the fly likes getting underlying oracle connection from Poolable connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "getting underlying oracle connection from Poolable connection" Watch "getting underlying oracle connection from Poolable connection" New topic
Author

getting underlying oracle connection from Poolable connection

Ajju Chawla
Greenhorn

Joined: Oct 21, 2005
Posts: 21
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
Greenhorn

Joined: Jun 26, 2006
Posts: 2
Hi Ajju,
Did you got the solution for this? I am facing the same problem

Regards
Abhishek
 
Don't get me started about those stupid light bulbs.
 
subject: getting underlying oracle connection from Poolable connection