Meaningless Drivel is fun!*
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 Murach's Java Servlets and JSP this week in the Servlets 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?