Hi
We are facing strange problem with Webspher Application Server Data Source.
=======================
Environment :-
=======================
Websphere Application Server (6.1)
Linux
Liferay Portal (5.2)
Oracle 9i
Hibernate 3.0
==========================
We have datasource deployed in Application server referring
ODBC14.jar
In
Hibernate Configuration for Datasource :-
<property name="connection.datasource">jdbc/appDB</property>
<property name="jndi.class">com.ibm.websphere.naming.WsnInitialContextFactory</property>
<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>
<property name="connection.autocommit">false</property>
===================
We are getting following excpetion :-
Caused by:
java.sql.SQLException: DSRA8101E: DataSource class cannot be used as one-phase: ClassCastException: oracle.jdbc.pool.OracleConnectionPoolDataSource incompatible with javax.sql.ConnectionPoolDataSource
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1375)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:462)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:418)
at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
at org.hibernate.jdbc.ConnectionManager.openConnection
We tried following workaround
====> Came to know classes12.jar is there in WEB-INF/lib
Which has ORACLEDriver which can cause Classloading conflict with Shared/apps/lib ODBC14.jar
sO removed classes12.jar from Webapplication Lib and redployed application and restarted.
But got same error again.
Any Idea folks ?
