Jboss-Ibatis-Spring-Oracle Class Cast Exception

[rizwanp]

Hi All,

Currently I deployed my application as a webapplication on jboss.

I am using the Spring-Ibatis DAO layer for communicating with the Oracle database.

If I used the database connection without creating datasource with the help of SqlMapConfig file it gives me proper values and my applicaiton works.

But, If i used the dataSource creation approach i am facing the problem of class cast exception. Providing the stack trace for more reference.

Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:

--- The error occurred while applying a parameter map.

--- Check The accountParams

--- Check the parameter mapping for 'names' property.

--- Cause: java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6 cannot be cast to oracle.jdbc.driver.OracleConnection.

Please let me know how to resolve this issue for retrieving the connection of Oracle type for above problem?

[tejasvi_t]

Hi Rizwan or anyone else,

Could you please share how you solved the above error.

Regards,

Teju