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