Oracle Connection settings-Urgent

[A Kumar]

Hai,

I have a problem while trying to connect to Oracle DB.

<datasources>

<local-tx-datasource>

<jndi-name>hofman</jndi-name>

<connection-url>jdbc:oracle:thin:@Myappserver:1521:host_string</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>abcd</user-name>
<password>abcd</password>

</local-tx-datasource>

</datasources>

The spring framework exception is

        org.springframework.jdbc.datasource.CannotGetJdbcConnectionException: Da

taSource org.jboss.resource.adapter.jdbc.WrapperDataSource@890510; nested except

ion is:

        org.jboss.util.NestedSQLException: Failed to register driver for: oracle

.jdbc.driver.OracleDriver; - nested throwable: (java.lang.ClassNotFoundException

oracle.jdbc.driver.OracleDriver); - nested throwable: (org.jboss.resource.JBos
sResourceException: Failed to register driver for: oracle.jdbc.driver.OracleDriv
er; - nested throwable: (java.lang.ClassNotFoundException: oracle.jdbc.driver.Or
acleDriver))

Thanks all,
Agatha.

[Graham O' Regan]

ClassNotFoundException - you need to put the Oracle drivers into ${JBOSS_HOME}/server/<serverinstance>/lib and then restart.

HTH

Graham O'Regan
<a href="http://www.ellisonbrookes.com">Ellison Brookes</a>

[Graham O' Regan]

my bad ;)

http://www.ellisonbrookes.com

[Frank Merenda]

You need to add the oracle driver jar/zip to your app server's classpath. You can do this by adding the classes12.zip or classes12.jar or whatever version of the oracle drivers you are using to your app server's classpath

i.e. JBOSS-3.2.5/lib/classes12.zip

or (better)

jboss-3.2.5/server/default/lib/classes12.zip

where the string "default" is the jboss server you are using.

If you're not using jboss you will have to find out where to put the jar/zip file.

Good luck, I hope this helps,
-Frank

[Frank Merenda]

What Graham said! :)

-Frank

[A Kumar]

Thanks one & all

As u said i had not kept the classes12.zip in server
/lib...Now iam getting the connection...I had 2 make it happen 2day itself...

Thanks once again,
bye,
Agatha.