Connection pooling question - Mailing list pgsql-jdbc

From Didrik Pinte
Subject Connection pooling question
Date
Msg-id 5.1.0.14.0.20030205154954.024333d0@192.168.0.11
Whole thread Raw
Responses Re: Connection pooling question  (Dave Cramer <Dave@micro-automation.net>)
List pgsql-jdbc
Hi,

I'm using the Connection Pooling implementation of Postgres JDBC driver.
Wich object should I use if I'm using the jakarta DBCP tools for Tomcat ?

Should I use org.postgresql.jdbc2.optional.PoolingDataSource or
org.postgresql.jdbc2.optional.ConnectionPool ?

I've read the comments at the beginning of ConnectionPool.java :

  * PostgreSQL implementation of ConnectionPoolDataSource.  The app server or
  * middleware vendor should provide a DataSource implementation that takes
advantage
  * of this ConnectionPoolDataSource.  If not, you can use the PostgreSQL
implementation
  * known as PoolingDataSource, but that should only be used if your server
or middleware
  * vendor does not provide their own. Why? The server may want to reuse
the same
  * Connection across all EJBs requesting a Connection within the same
Transaction, or
  * provide other similar advanced features.

Is jakarta DBCP a middleware providing the DataSource implementation for
Tomcat ?

Is is possible that the problems of "connection reset by peer" that I had
was related to the use of PoolingDataSource with DBCP ?

Thank you for any help

Didrik Pinte
Adhoc Solutions



**** DISCLAIMER ****
This e-mail and any attachments thereto may contain information
which is confidential and/or protected by intellectual property
rights and are intended for the sole use of the recipient(s) named above.
Any use of the information contained herein (including, but not limited to,
total or partial reproduction, communication or distribution in any form)
by persons other than the designated recipient(s) is prohibited.
If you have received this e-mail in error, please notify the sender
and delete the material from any computer.
Thank you for your cooperation.



pgsql-jdbc by date:

Previous
From: "Amit Kelkar"
Date:
Subject: how to unsubscribe
Next
From: "Scott Taylor"
Date:
Subject: Test