Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Trouble connecting to Oracle from Tomcat using JNDI

Trouble connecting to Oracle from Tomcat using JNDI

From: Kiran <klingutla_at_hotmail.com>
Date: 8 Feb 2004 15:23:48 -0800
Message-ID: <3de9bf0c.0402081523.5c690962@posting.google.com>


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>

</resource-ref>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US