Hello Everyone,
We are using Spring and iBatis in our application which is deployed on JBoss.
Our datasource is configured on JBoss which we lookup through JNDI.
In one of our funtions, we are required to make a call to a stored procedure which has an Oracle.ARRAY as IN parameter. Now in order to create a StructDescriptor/ArrayDescriptor, we need to pass the connection object to the createDescriptor.
However, when weI get the connection object from the datasource and pass it to the createDescriptor method
java.sql.Connection conn = setter.getPreparedStatement().getConnection();
StructDescriptor structDescriptor = StructDescriptor.createDescriptor("OBJECT_NAME", conn);
We get a
java.sql.SQLException: org.jboss.resource.adapter.jdbc.WrappedConnection
a) If we create a regular direct JDBC connection, it runs fine.
b) If we load the sql-map-config.xml at run time (it has a datasource object defined in it), it runs fine.
We would however like to use the already created datasource for all db purposes.
Any help would be appreciated.
Thanks and Regards,
Yoshita