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

I am Using Spring MVC, Oracle 10g with Jboss As 7.0.2

My problem is when I am trying to insert the value for CLOB Data type using CLOB.createTemporary function, the exception i am getting is

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

I had also used ojdbc6.jar but no solution came.

Also, I tried to search in various forum, in which i got the following link

https://forums.oracle.com/forums/thread.jspa?threadID=279238

As per discussion, they are saying that we have to wrap the connection, so i used also but problem not resolved.

So, i request you to please give some idea for solving this problem or some detail explanation about the above give exception

Please post the entire exception stacktrace.

In earlier versions of JBoss AS I would suspect that you packaged some JBoss AS JARs in your app. Not sure if that is still the case with AS 7. But it might be helpful to know what type of app you have (WAR, EAR?) and if you listed the contents of the app (for example, if it is a WAR file, run 'jar -tf xxx.war').

Also, please tell us exactly where you placed the Oracle JDBC Driver JAR file.

I am using war file for deployment purpose which is placed in <JBOSS_HOME>/standalone/deployments folder

and Oracle Driver jar file is placed <JBOSS_HOME>modules/com/databasedriver/main

and i have configured standalone.xml file in <JBOSS_HOME>/standalone/configuration folder as below

<datasources>
                <datasource jndi-name="jdbc/mgeretail" pool-name="retail_pool" enabled="true" jta="true" use-java-context="false" spy="true" use-ccm="true">
                    <connection-url>
                        jdbc:oracle:thin:sample/sample@localhost:1521:ORCL
                    </connection-url>
                    <driver>
                        Oracle
                    </driver>
                    <pool>
                        <prefill>
                            true
                        </prefill>
                        <use-strict-min>
                            false
                        </use-strict-min>
                        <flush-strategy>
                            FailingConnectionOnly
                        </flush-strategy>
                    </pool>
                    <security>
                        <user-name>
                            
                        </user-name>
                        <password>
                            
                        </password>
                    </security>
                </datasource>
                <drivers>
                    <driver name="Oracle" module="com.databasedriver">
                        <driver-class>
                            oracle.jdbc.OracleDriver
                        </driver-class>
                    </driver>
                </drivers>
            </datasources>

So kindly tell me what exactly problem is? and how to resolve

I'm having the same problem that Sekar has described.

Does anyone found a solution to fix the problem?

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

- JBoss 7.0.0
- Oracle 11g
- JDK 6

If you anyone knows the solution, please share it.

Thanks in advance.

-Rajkumar

This post might help:

https://community.jboss.org/wiki/SetUpAOracleDatasource

Hi James,

While I'm trying to get the connection, I'm getting same typecast exception.

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

Any solution to address the problem is appreciated.

Thanks,
Rajkumar