Thak you for your response..  I appreciate your time ..

This is my server.xml
-----------------------

  <Host name="localhost" debug="0" appBase="webapps"
       unpackWARs="true" autoDeploy="true"
       xmlValidation="false" xmlNamespaceAware="false">
         <Context path="sunil" docBase="sunil"
              debug="0" crossContext="true"  reloadable="true">
           <Resource name="jdbc/myoracle" auth="Container"
                 type="javax.sql.DataSource"/>
           <ResourceParams name="jdbc/myoracle">
              <parameter>
                 <name>factory</name>

<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
              </parameter>
              <parameter>
                 <name>driverClassName</name>
                 <value>oracle.jdbc.driver.OracleDriver</value>
              </parameter>
              <parameter>
                 <name>url</name>
                 <value>jdbc:oracle:thin:@192.168.2.101:1521:oralin</value>
              </parameter>
              <parameter>
                 <name>username</name>
                 <value>webuser</value>
              </parameter>
              <parameter>
                 <name>password</name>
                 <value>oralin</value>
              </parameter>
              <parameter>
                 <name>maxActive</name>
                 <value>20</value>
              </parameter>
              <parameter>
                 <name>maxIdle</name>
                 <value>10</value>
              </parameter>
              <parameter>
                 <name>maxWait</name>
                 <value>-1</value>
              </parameter>
           </ResourceParams>
         </Context>

My Web.xml is
--------------

<web-app>
    <servlet-mapping>
        <servlet-name>MyServlet</servlet-name>
        <url-pattern>/servlet/MyServlet</url-pattern>
    </servlet-mapping>
    <resource-ref>
        <description>Oracle Datasource example</description>
        <res-ref-name>jdbc/myoracle</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
</web-app>



> Supply more information.
> What does your server.xml and web.xml look like? (don't post the whole
> file, just relevant parts).
> Where is your driver jar located? (it should be common/lib)
>
> That class of error ("class '' for URL 'null') is fairly common, and
> normally it's mis-configuration.
>
>> -----Original Message-----
>> From: Mathew [mailto:[EMAIL PROTECTED]
>> Sent: Wednesday, March 03, 2004 9:42 AM
>> To: [EMAIL PROTECTED]
>> Subject: Need help - Data Source problem
>>
>>
>>
>> I am using TOMCAT 5.0.19 and Apache 1.3.x. I configured my
>> server.xml and web.xml to use data source. When ever I
>> excecute a servlet from browser I get the folloeing message.
>> For me it looks like my program is not able to
>> read tags in server.xml to get driver class info.   Any help is really
>> appreciated .
>>
>> org.apache.commons.dbcp.SQLNestedException: Cannot create
>> JDBC driver of class '' for connect URL 'null', cause: null
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to