Jboss managed connection and ClassCastException

[thenrick]

I have a cactus test that I run with JBoss managed connection to Oracle DB and I get a ClassCastException. When I don't use JBoss managed connection the insert works fine. The insert is putting in a CLOB. I am using oracle 9.2.0.3 jdbc driver. I have JBoss 3.2.5. I would prefer to be consistent and use JBoss managed connections.
Thanks in Advance,
Tom Henricksen

[ricardoarguello]

You need to cast the Connection to org.jboss.resource.adapter.jdbc.WrappedConnection fist.

Then invoke the getUnderlyingConnection() method to obtain the original OracleConnection.

If you don't want to import org.jboss.* classes into your project, you could use the Reflection API to invoke the "getUnderlyingConnection" method.

Ricardo

[ricardoarguello]

You could find an example for obtaining the original Connection using the Reflection API here (Spring Framework's CVS):

http://cvs.sourceforge.net/viewcvs.py/springframework/spring/src/org/springframework/jdbc/support/nativejdbc/JBossNativeJdbcExtractor.java?rev=1.12&view=auto

Ricardo