Hi,
I've been trying to use the DAO Framework recently to facilitate in
calling a large number of Stored Procedures in and Oracle database (I'd
have liked to use SqlMaps too but most of these procedures seem to
return ref cursor parameters which IBatis cannot handle).
One of these procedures takes an array structure as a parameter
(proprietary I know) which is normally done with a call like this:
oracle.sql.ArrayDescriptor desc =
oracle.sql.ArrayDescriptor.createDescriptor(getSchemaPrefix(schema) +
"TY_STR_VARRAY", connection);
But under IBatis it'll fail because the connection is actually an IBatis
proxy com.ibatis.common.jdbc.SimpleDataSource.SimplePooledConnection
where thr wrapper SimplePooledConnection is private. Is there a way to
access the underlying oracle/jdbc connection to complete the
ArrayDescriptor call or some other way around the problem?
Thanks,
- Richard