org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6 cannot be cast to oracle.jdbc.OracleConnection

[gcbmsce]

Hi,

I am getting the below exception in my application when it is trying to pass the connection object to a stored procedure from java code.

  java.lang.ClassCastException: org.jboss.jca.adapters.jdbc.jdk6.WrappedConnectionJDK6 cannot be cast to oracle.jdbc.OracleConnection

        at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:160)

        at oracle.sql.ArrayDescriptor.createDescriptor(ArrayDescriptor.java:128)

Environment details:

  I am using JDK 6, JBOSS EAP 6.1, Oracle 11g, OJDBC 11.2.0.2.0 jar

To resolve this issue, i tried to unwrap the connection to OracleConnection with the below changes . Then i am getting the new below exception:

procStmt.registerOutParameter(3, OracleTypes.CURSOR);

           OracleConnection connection = dsconnection.unwrap(OracleConnection.class);

              ArrayDescriptor arrayDescriptor = ArrayDescriptor.createDescriptor("REQ_TYPE_ARRAY", connection);

Exception:

Failed to Execute java.sql.SQLException: Not a wrapper for: oracle.jdbc.OracleConnection

Any help would be appriciated.

Thanks in Advance!!!.

[gcbmsce]

Can anyone help to resolve the above issue. Please share your ideas regarding that above issue.

[valacm1c]

Get the underlying connection from the WrappedConnection and then use it for the ArrayDescriptor

...

WrappedConnection wrappedConnection = connection.unwrap(WrappedConnection.class);

try {

Connection underlyingConnection = wrappedConnection.getUnderlyingConnection();

this.connection = underlyingConnection;

} catch (SQLException e) {

...

[gcbmsce]

@Valacm1c....First of all, Thanks a lot for replying.

I will check it on Monday and let you know.

Thanks again!!!