Access JDBC driver vendor specific classes in JBoss EAP 6/7

Issue

• Need to access Oracle specific oracle.jdbc.driver.OracleConnection and oracle.jdbc.OracleCallableStatement
• Need to access oracle.sql.BLOB

• Encountered a ClassCastException when attempting to cast to the vendor specific connection object (e.g. oracle.jdbc.driver.OracleConnection):

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

• Encountered a ClassCastNotFoundException when migrating code running successfully in EAP 5 to EAP 6/7

  java.lang.ClassNotFoundException: org.jboss.resource.adapter.jdbc.WrappedConnection 
  

• Warnings are reported in the server.log when declaring an explicit dependency on the org.jboss.ironjacamar.jdbcadapters module

  ... WARN  [org.jboss.as.dependency.private] ... JBAS015867: Deployment "deployment.myapp.war" is using a private module ("org.jboss.ironjacamar.jdbcadapters:main") which may be changed or removed in future versions without notice.