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

Calling Stored procedures

Raja Raja

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 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 supplied by Oracle.
Can anybody suggest a asolution to overcome this problem.
Raja Raja

Joined: May 17, 2003
Posts: 8
Issue most urgent. Can anybody address it.
I agree. Here's the link:
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?