JNDI: Tomcat + Oracle

[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>jdbcracle:thin192.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

 

[Igor N. Kolomiyets]

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