tomcat/postgres problem - Mailing list pgsql-jdbc

From Jason Dinger
Subject tomcat/postgres problem
Date
Msg-id 00b801c2fecf$e7413190$2b40ec18@jasonekj7yrm2i
Whole thread Raw
Responses Re: tomcat/postgres problem
List pgsql-jdbc
I'm trying to load the postgresql driver into tomcat using the server.xml file and web.xml file, but I keep getting the following error:
 
javax.naming.NamingException: DbcpDataSourceFactory: driverClassName is required
 
Here's part of my server.xml file:
 
    <Resource name="jdbc/MyDB" scope="Shareable" type="javax.sql.DataSource"/>
    <ResourceParams name="jdbc/MyDB">
      <parameter>
        <name>validationQuery</name>
        <value></value>
      </parameter>
      <parameter>
        <name>user</name>
        <value>Jason</value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>4</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:postgresql:mydb</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value> </value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>org.postgresql.Driver</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>2</value>
      </parameter>
    </ResourceParams>
 
And here's part of my web.xml file
 
<resource-ref>
  <description>
    Postgresql driver
  </description>
  <res-ref-name>
    jdbc/MyDB
  </res-ref-name>
  <res-type>
    javax.sql.DataSource
  </res-type>
  <res-auth>
    Container
  </res-auth>
</resource-ref>
 
 
I know I can load the driver with Class.forName().  That works too.  But how do I get the driver loaded via the server.xml and web.xml files?  Any suggestions?
 
 
- Jake

pgsql-jdbc by date:

Previous
From: "kangch"
Date:
Subject: DriverManager.setLoginTimeout question
Next
From: Theo Cleminson
Date:
Subject: ant