OracleConnection without getUnderlyingConnection()

[mhalasa]

is there a way to get get OracleConnection from oracle jndi datasource (in jboss represented as WrapperDataSource) in other way than this?

temp = dataSource.getConnection();
result = (OracleConnection)((WrappedConnection)temp).getUnderlyingConnection();

all I could find about this is:
http://forums.oracle.com/forums/thread.jspa?threadID=279238&tstart=45&messageID=894337#894337

but I don't see a way to use it in JBoss.

any hint will be appreciated, searching forum wasn't of any help since i probably don't know the right key word :(

thanks,
/m

[mhalasa]

the problem is that if I close UnderlyingConnection, WrappedConnection above it is not closed and it remains flagged as open in JBoss ManagedConnectionPool

[influence160]

I have the same problem

and if i close the the wrapped and the underlying connections i have an 'connection closed' exception

and if i close only the wrapped connection the program is blocked

is there any solution to use the oracle connection without having this problems ?