Pooled connections in Tomcat

From: Thomas Wirth <thomaswirth(at)comcast(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Pooled connections in Tomcat
Date: 2002-12-29 05:42:41
Message-ID: 1041140561.1132.61.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
I am trying to setup a DataSource for Postgre (7.2.2-1) in Tomcat
(4.1.12). Running on RedHat Linux 8, SDK is 1.4.1. I am using the
pg73jdbc2ee.jar jdbc-driver, which should have the support for
javax.sql.... See the Resource definition from server.xml below. I am
struggling with what value to use for the driverClassName. So far I have
tried
org.postgresql.Driver
org.postgresql.jdbc2.optional.PoolingDataSource
org.postgresql.jdbc2.optional.PooledConnectionImpl
org.postgresql.jdbc2.optional.ConnectionPool
All produce the same SQlException: Cannot load JDBC driver class 'null'

Can someone who has this running give me a hint please. I can connect to
Postgre by establishing a connection via the DriverManager, so
connection url, database config,.. are OK.

Thank you,
Thomas

<Resource
name="jdbc/pgdb"
auth="Container"
type="javax.sql.DataSource"/>

<ResourceParams name="jdbc/pgdb">
<parameter><name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter>
<parameter><name>username</name><value>user</value></parameter> <parameter><name>password</name><value>passwd</value></parameter>
<parameter><name>driverClassName</name>
<value>org.postgresql.jdbc2.optional.PoolingDataSource</value></parameter>
<parameter><name>url</name>
<value>jdbc:postgresql:db</value></parameter>
<parameter><name>maxActive</name><value>8</value></parameter>
<parameter><name>maxIdle</name><value>4</value></parameter>
</ResourceParams>

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Simon Mitchell 2002-12-29 08:04:37 Re: Pooled connections in Tomcat
Previous Message Dave Cramer 2002-12-26 19:47:23 Re: Accessing BIT(n) type from Java