Thread: Pooled connections in Tomcat

Pooled connections in Tomcat

From
Thomas Wirth
Date:
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>



Re: Pooled connections in Tomcat

From
Simon Mitchell
Date:
Hi Thomas,
                      I am running postgesql on tomcat 4.1.18 with
jdk1.4.1 on win2000.
Maybe you need to use

<parameter><name>driverClassName</name><value>org.postgresql.Driver</value></parameter>

Here are some of the configs i am using.
server.xml
   <Resource name="jdbc/postgesql" scope="Shareable"
type="javax.sql.DataSource" auth="Container"/>
<ResourceParams name="jdbc/postgresql">

<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter>
            <parameter><name>maxActive</name><value>100</value></parameter>
            <parameter><name>maxWait</name><value>100</value></parameter>

<parameter><name>url</name><value>jdbc:postgresql://127.0.0.1:5432/mail</value></parameter>

<parameter><name>driverClassName</name><value>org.postgresql.Driver</value></parameter>
            <parameter><name>maxIdle</name><value>30000</value></parameter>

<parameter><name>username</name><value>username</value></parameter>

<parameter><name>password</name><value>password</value></parameter>
          </ResourceParams>

web.xml

  <description>postgresql</description>
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/postgresql</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>

servlet/jsp

Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/postgresql");
Connection conn = ds.getConnection();

Regards,
Simon



Thomas Wirth wrote:

>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>
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>