Access to the underlying connection

[Richard Osbaldeston <ri...@wordmap.com>]

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

Re: Access to the underlying connection

[Brandon Goodin <br...@gmail.com>]

hmmm.... did this repost?

Brandon

On 4/18/05, Richard Osbaldeston <ri...@wordmap.com> wrote:
> 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
>