Jboss 4.0.1 does not work with oracle.jdbc.pool.OracleDataSo

[vgoudar]

Hi
I am able to create database source with oracle driver class oracle.jdbc.driver.OracleDriver. But some how it does not work with driver class oracle.jdbc.pool.OracleDataSource. I get the following exception. Does any one knows how to make it work?


org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: oracle.jdbc.pool.OracleDataSource; - nested throwable: (java.lang.ClassCastException: oracle.jdbc.pool.OracleDataSource)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: oracle.jdbc.pool.OracleDataSource; - nested throwable: (java.lang.ClassCastException: oracle.jdbc.pool.OracleDataSource)))
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)

[ricardoarguello]

Because an oracle.jdbc.pool.OracleDataSource is not a java.sql.Driver!

You don't have to use an OracleDataSource to have a connection pool. JBoss provides one for you when you define a DataSource. You could change the max and min size of this pool too. Read the JCA docs.

[swapnasingh]

org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Fail ed to register driver for: oracle.jdbc.driver.OracleDriver; - nested throwable: (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver)); - nested t hrowable: (org.jboss.resource.JBossResourceException: Could not create connectio n; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to reg ister driver for: oracle.jdbc.driver.OracleDriver; - nested throwable: (java.lan g.ClassNotFoundException: oracle.jdbc.driver.OracleDriver)))

how to solve this error

[weston.price]

1) Read this first:

http://www.jboss.com/index.html?module=bb&op=viewtopic&t=59031

2) Start a new thread and try again