Not able to get webapp context to work in Tomcat6

Tue, 15 Mar 2011 08:11:08 -0700 

Hi,

I have my webapps's context define in
$CATALINA_HOME/conf/Catalina/localhost.
The application is not reading the datasource, I get the following error in
catalina logs:

Unhandled SQL Exception:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: *Cannot
create JDBC driver of class '' for connect URL 'null'
*
The connect URL is defined in the xml file.

Is there any setting that I need to do specific to Tomcat 6 so that it reads
the xml file correctly?

My context file looks like this (osm_svr.xml)
-----------------------------------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<Context displayName="Order Summary Message Application" docBase="osm_svr"
path="/osm_svr">
  <Resource name="jdbc/db01" type="javax.sql.DataSource"/>
  <Resource name="jdbc/db95" type="javax.sql.DataSource"/>
  <Resource name="jdbc/db96" type="javax.sql.DataSource"/>
  <Resource name="jdbc/db93" type="javax.sql.DataSource"/>
  <Resource name="jdbc/db94" type="javax.sql.DataSource"/>
  <Resource name="jdbc/main" type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/db01">
    <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@spduwm01.hsn.net:1521:wmsdug01</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>movebatch</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>20</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>movebatch</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>8</value>
    </parameter>
    <parameter>
     <name>removeAbandoned</name>
     <value>true</value>
    </parameter>
    <parameter>
     <name>removeAbandonedTimeout</name>
     <value>60</value>
    </parameter>
  </ResourceParams>
*  <ResourceParams name="jdbc/main">
    <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@spduwm01.hsn.net:1521:wmsdug01</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>movebatch</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>20</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>movebatch</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>8</value>
    </parameter>
    <parameter>
     <name>removeAbandoned</name>
     <value>true</value>
    </parameter>
    <parameter>
     <name>removeAbandonedTimeout</name>
     <value>60</value>
    </parameter>
  </ResourceParams>*
  <ResourceParams name="jdbc/db95">
    <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@wmsha95.hsn.net:2305:wmsprd95</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>summer03</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>20</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>osmreport</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>8</value>
    </parameter>
    <parameter>
     <name>removeAbandoned</name>
     <value>true</value>
    </parameter>
    <parameter>
     <name>removeAbandonedTimeout</name>
     <value>60</value>
    </parameter>
  </ResourceParams>
  <ResourceParams name="jdbc/db96">
    <parameter>
      <name>url</name>
      <value>dbc:oracle:thin:@roap07.hsn.net:2308:wmsprd96</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>summer03</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>20</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>osmreport</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>8</value>
    </parameter>
    <parameter>
     <name>removeAbandoned</name>
     <value>true</value>
    </parameter>
    <parameter>
     <name>removeAbandonedTimeout</name>
     <value>60</value>
    </parameter>
  </ResourceParams>
  <ResourceParams name="jdbc/db93">
    <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@wmsha93.hsn.net:2054:wmsprd93</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>summer03</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>20</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>osmreport</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>8</value>
    </parameter>
    <parameter>
     <name>removeAbandoned</name>
     <value>true</value>
    </parameter>
    <parameter>
     <name>removeAbandonedTimeout</name>
     <value>60</value>
    </parameter>
  </ResourceParams>
  <ResourceParams name="jdbc/db94">
    <parameter>
      <name>url</name>
      <value>jdbc:oracle:thin:@wmsha94.hsn.net:2309:wmsprd94</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>summer03</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>20</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>oracle.jdbc.driver.OracleDriver</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>osmreport</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>8</value>
    </parameter>
    <parameter>
     <name>removeAbandoned</name>
     <value>true</value>
    </parameter>
    <parameter>
     <name>removeAbandonedTimeout</name>
     <value>60</value>
    </parameter>
  </ResourceParams>
</Context>
----------------------------------------------------------------------------------------------------------------------



Catalina logs when starting up tomcat
--------------------------------------------------------

Mar 15, 2011 9:57:01 AM org.apache.catalina.startup.HostConfig
deployDescriptor
INFO: Deploying configuration descriptor osm_svr.xml
Mar 15, 2011 9:57:01 AM org.apache.catalina.startup.HostConfig
deployDescriptor
WARNING: A docBase /opt/hsnweb/hsnapps/tomcat/webapps/osm_svr inside the
host appBase has been specified, and will be ignored

Reply via email to