5:14 a.m.
Hello,
I am trying to access Oracle data source in Jboss from a struts based web application. For
doing this I have done the following:
i am using Oracle 10g Express edition.
(1) Copied the thin oracle driver (ojdbc14.jar) in server\default\lib directory of
JBOSS_HOME.
(2) Copied the oracle-ds.xml file from docs\examples\jca directory of JBOSS_HOME to
server\default\deploy of JBOSS_HOME.
which is :
<local-tx-datasource>
<jndi-name>oracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521:XE</connection-url>
<user-name>uname</user-name>
pwd
<type-mapping>OracleXE</type-mapping>
</local-tx-datasource>
(3) Next I have changed the default standardjaws.xml. I have changed the data source
name and its type-mapping to OracleXE.
i added type mapping for Oracle XE simply copeing the content of whole oracle 8 type
mapping and just changed its name to OracleXE
java:/oracleDS
<type-mapping>OracleXE</type-mapping>
false
<default-entity>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<row-locking>false</row-locking>
<read-ahead>false</read-ahead>
</default-entity>
(4) I have changed standardjbosscmp-jdbc.xml file also.
(5) I have put an entry in login-config.xml file also.
But when i deploy my application
these are the excpetions i get in my server log :---
Caused by: java.lang.ClassNotFoundException: No ClassLoaders found for:
oracle.jdbc.driver.OracleDriver
Could not create deployment:
ile:/usr/local/jboss-4.0.5.GA/server/default/deploy/oracle-ds.xml
please help me out.. i am unable to figure out the problem.
some more desciptive server log dump :
14:05:45,430 INFO [WrapperDataSourceService] Bound ConnectionManager
'jboss.jca:service=DataSourceBinding,name=oracleDS' to JNDI name
'java:oracleDS'
14:05:45,512 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new
connection: null
org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for:
oracle.jdbc.driver.OracleDriver; - nested throwable: (java.lang.ClassNotFoundException: No
ClassLoaders found for: oracle.jdbc.driver.OracleDriver))
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:565)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:250)
rg.jboss.resource.JBossResourceException: Failed to register driver for:
oracle.jdbc.driver.OracleDriver; - nested throwable: (java.lang.ClassNotFoundException: No
ClassLoaders found for: oracle.jdbc.driver.OracleDriver)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:287)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:170)
... 122 more
Caused by: java.lang.ClassNotFoundException: No ClassLoaders found for:
oracle.jdbc.driver.OracleDriver
at org.jboss.mx.loading.LoadMgr3.beginLoadTask(LoadMgr3.java:306)
44 ERROR [GeneralPurposeDatabasePersistencePlugin] Cannot create timer table
org.jboss.deployment.DeploymentException: Error while checking if table aleady exists
TIMERS; - nested throwable: (org.jboss.util.NestedSQLException: Could not create
connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to
register driver for: oracle.jdbc.driver.OracleDriver; - nested throwable:
(java.lang.ClassNotFoundException: No ClassLoaders found for:
oracle.jdbc.driver.OracleDriver)); - nested throwable:
(org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for:
oracle.jdbc.driver.OracleDriver; - nested throwable: (java.lang.ClassNotFoundException: No
ClassLoaders found for: oracle.jdbc.driver.OracleDriver))))
at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.tableExists(SQLUtil.java:1040)
at
org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.createTableIfNotExists(GeneralPurposeDatabasePersistencePlugin.java:112)
at
org.jboss.ejb.txtimer.DatabasePersistencePolicy.startService(DatabasePersistencePolicy.java:95)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4046419#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...