This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: getting underlying oracle connection from Poolable connection
 
Similar Threads
any replacement for ArrayDescriptor
ClassCastException on Oracle ArrayDescriptor
Apache Commons DBCP connection object problem
Any Replacement of ArrayDescriptor?
Any replacement for ArrayDescriptor?