Getting java.lang.ClassCastException when casting prepareCal

[singhindresh]

Oracle generate java.lang.ClassCastException when casting prepareCall to OracleCallableStatement.

...
oracle.jdbc.OracleCallableStatement callable_statement;

callable_statement = (oracle.jdbc.OracleCallableStatement) connection.prepareCall(ProcedureCall_Statement);
....

I am getting exception at the above statement, I want to used this becasue i want to use Oracle Collection API setORAData to register input parameter for procedure call.

Any help is Welcome and thanks in advance.

Indy

[jonlee]

The connection object is a wrapper. You need to get the underlying connection. See org.jboss.test.jca.ejb.LocalWrapperCleanupTestSessionBean of the testsuite (with the source) for an example of getting the underlying connection.

Hope that helps. I haven't used an underlying connection in a fair while so hopefully it will still work.

[jonlee]

There might be J2EE transactional ramifications to this. YMMV.