tomcat/postgres problem

From: "Jason Dinger" <jake451(at)knology(dot)net>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: tomcat/postgres problem
Date: 2003-04-09 19:40:40
Message-ID: 00b801c2fecf$e7413190$2b40ec18@jasonekj7yrm2i
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Cris 2003-04-09 19:42:17 Index not used,
Previous Message Tom Lane 2003-04-09 19:28:28 Re: Index not used,