Two Laptop Bag*
The moose likes JDBC and the fly likes Calling Stored procedures 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 "Calling Stored procedures" Watch "Calling Stored procedures" New topic
Author

Calling Stored procedures

Raja Raja
Greenhorn

Joined: May 17, 2003
Posts: 8
I am trying to call a oracle 9i stored procedure from a stateless session bean. I want to send a array to stored procedure. i use the class ArrayDescriptor found in classes12.zip to send the array. The array descriptor needs Connection object as one of the parameter. Since i am using Weblogic app server, when i get a connection from the Connection pool thru TX data Source , i get an weblogic.jdbc.jts.Connection object. Since this Connection object is incompatible with ArrayDescriptor, i get a class cast connection. On introspecting the ArrayDescriptor i found the Connection object is internally casted to OracleConnection class and Oracle Connection extends java.sql.Connection. pl. note ArrayDescriptor and Oracle Connection are both found in claases12.zip supplied by Oracle.
Can anybody suggest a asolution to overcome this problem.
Raja Raja
Greenhorn

Joined: May 17, 2003
Posts: 8
Issue most urgent. Can anybody address it.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Calling Stored procedures
 
Similar Threads
any replacement for ArrayDescriptor
java.sql.SQLException: invalid name pattern
Passing Arrays to Oracle stored procedures
Calling a stored procedure with an ARRAY
Any Replacement of ArrayDescriptor?