David,
A much more robust pooling mechanism is dbcp from apache
http://jakarta.apache.org/commons/dbcp/
Dave
On 25-Jan-06, at 8:18 PM, David Hustace wrote:
>
> On Jan 25, 2006, at 6:30 PM, Oliver Jowett wrote:
>
>> It does not change the state of the datasource and just delegates
>> to DriverManager to do the real work, so it should be threadsafe.
>
> Ah. I just saw that. in BasicDataSource.java. Thanks for your
> help. I guess I need improve my connection caching to try and
> remove stale connections or switch to another implementation.
> Anyone have production experience with SmartPool and a PostgreSQL
> driver? http://smartpool.sourceforge.net/ It looks pretty good so
> far. I guess I should search the list before asking this question.
> (duck)
>
> -David
>
>
> David Hustace
> The OpenNMS Group, Inc.
> Main : +1 919 545 2553 Fax: +1 503-961-7746
> Direct: +1 919 827 1201 Skype: dhustace
> Key Fingerprint: 8EC1 F319 2C1D 3197 AAB9 580F FACD 1D19 175E D903
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>