Oracle native connection

[joselopesdacruz]

Hello,

Is there any issue between Oracle ArrayDescriptor use of ojdbc6.jar and jboss datasources?

As far as I could get, the class ArrayDescriptor from ojdbc6.jar needs a native connection. If I try to use a "normal" connection got from the jboss datasource, the result will be the following error:

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

Any workaround or any way to get a native connection from the jboss datasource?

thanks,

José Cruz

[nickarls]

https://community.jboss.org/wiki/SetUpAOracleDatasource (How to retrieve...)

[joselopesdacruz]

Hello,

I found the solution!

The MANIFEST.MF of the jar when I want uso native connection must have 2 module references:

1) com.oracle.db (or any other name you want), which contains the ojdbc6.jar

2) org.jboss.ironjacamar.jdbcadapters (the module which contains the wrapper connection of jboss 7)

Dependencies: com.oracle.db, org.jboss.ironjacamar.jdbcadapters

thanks,

José Cruz