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
When we include the jboss-common-jdbc-wrapper.jar (which contains org.jboss.resource.adapter.jdbc.WrappedConnection) we can't seem to get the connection right and we get an exception while executing a regular select statement through iBatis.