Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Trouble connecting to Oracle from Tomcat using JNDI
Hi,
I am using Tomcat5 and Oracle 9i and having trouble trying to connect
to my database using JNDI.
The Context tag in server.xml looks like this.
<Context path="" docBase="ROOT" debug="1">
<Resource name="jdbc/costanza" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/costanza"> <parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter>
<name>username</name>
<value>scott</value>
</parameter> <parameter>
<name>password</name>
<value>tiger</value>
</parameter> <parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter> <parameter>
<name>url</name>
<value>jdbc:oracle:thin_at_127.0.0.1:1521:costanza</value>
</parameter> </ResourceParams> </Context>
and the relevant portion in web.xml looks like this <resource-ref>
<description>Accounts Database</description> <res-ref-name>jdbc/costanza</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth>
The SID of my database is costanza and I am able to connect to it using DriverManager. But when I use JNDI, I get the following error.
org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause: No suitable driver
It appears as if it's not reading the driverClassName and url tags. I get the same error when I remove the whole Context section from server.xml.
I am struggling to solve this problem. Can anyone please help?
Thanks in advance.
-Kiran
Received on Sun Feb 08 2004 - 17:23:48 CST
![]() |
![]() |