Oracle Data Source ClassCastException when getting XA Connec
kalichar Mar 7, 2004 8:55 PMI have the following configuration defined in oracle-ds.xml and the file is correclty deployed.
<local-tx-datasource> <jndi-name>jdbc/SimpleDataSource</jndi-name> <driver-class>oracle.jdbc.xa.client.OracleXADataSource</driver-class> <connection-url>jdbc:connection:thin:@localhost:1521:oracle</connection-url> <user-name>scott</user-name> <password>tiger</password> <valid-connection-checker-class-name> org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> </local-tx-datasource>
I have the new oracle driver library installed in the correct place.
When I try to obtain a connection, I get the following ClassCastException:
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: oracle.jdbc.xa.client.OracleXADataSource; - nested throwable: (java.lang.ClassCastException)) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:213) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:496) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:425) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:318) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
This occurs when I do the following:
InitialContext context = new InitialContext(); DataSource ds = (DataSource) context.lookup ( "java:jdbc/SimpleDataSource"); Connection conn = ds.getConnection();
I am clueless as to why there is a class cast exception here. The code is being run within the JBoss VM. Please assist . Thanks in advance.