*
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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
 
jQuery in Action, 2nd edition
 
subject: getting underlying oracle connection from Poolable connection