Connection pooling question

From: Didrik Pinte <dp(at)adhoc(dot)be>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Connection pooling question
Date: 2003-02-05 14:55:14
Message-ID: 5.1.0.14.0.20030205154954.024333d0@192.168.0.11
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Scott Taylor 2003-02-05 15:32:07 Test
Previous Message Amit Kelkar 2003-02-05 14:35:50 how to unsubscribe