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.
posted 13 years ago
Issue most urgent. Can anybody address it.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads