JNDI: Tomcat + Oracle

C

cccc

Hi,
I try this exercise: JNDI in Tomcat + Oracle bad this non work.

1/3)
I copy a file ojdbc14.jar in /common/lib Tomcat folder

2/3)
I write in server.xml Tomcat file:
.....
.....
<Resource name="jdbc/Test" type="javax.sql.DataSource" scope= "Shareable"
auth="Container"/>
<ResourceParams name="jdbc/Test">
<parameter>
<name>user</name>
<value>oe</value>
</parameter>
<parameter>
<name>password</name>
<value>adminoe</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:eek:racle:thin:mad:192.168.1.100:1521:MYDB</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>15</value>
</parameter>
<parameter><name>maxIdle</name>
<value>15</value>
</parameter>
</ResourceParams>
.....
.....

3/3)
I write in my java code:
.....
javax.naming.Context initContext = new javax.naming.InitialContext();
javax.naming.Context envContext =
(javax.naming.Context)initContext.lookup("java:/comp/env");
javax.sql.DataSource ds = (javax.sql.DataSource)
envContext.lookup("jdbc/Test");;
Connection conn = ds.getConnection();
.....

This is the message error:
java.sql.SQLException: No suitable driver


I need your help?

Thank you,
CC
 
I

Igor N. Kolomiyets

The Oracle driver is oracle.jdbc.OracleDriver, not a
oracle.jdbc.driver.OracleDriver.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,731
Messages
2,569,432
Members
44,832
Latest member
GlennSmall

Latest Threads

Top