| From: | Doug Fields <dfields-postgres(at)pexicom(dot)com> |
|---|---|
| To: | <Dave(at)micro-automation(dot)net> |
| Cc: | "'Justin Clift'" <justin(at)postgresql(dot)org>, <tsmets(at)brutele(dot)be>, "'pgsql jdbc'" <pgsql-jdbc(at)postgresql(dot)org>, <hyellina(at)iprimus(dot)com(dot)au> |
| Subject: | Re: Pooled Connections (was Connections with Tomcat |
| Date: | 2002-03-06 15:27:09 |
| Message-ID: | 5.1.0.14.2.20020306102301.035cf8c8@mail.pexicom.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
At 07:30 AM 3/6/2002, Dave Cramer wrote:
>Pooled connections aren't rocket science. There are quite a few freely
>available, poolman for one.
For what it's worth, I never got Poolman 2.0.4 to work with the JDBC 7.2
drivers; occasionally and for no reason it would give me spurious errors on
perfectly good SQL. I posted about it a week or two ago on this list. I
received no replies, and furthermore got no replies from the author(s) and
found little information about it on the net.
I now use Protomatter (protomatter.sourceforge.net) and have had very good
success with it. It's a more simple implementation, hence, probably faster
and/or more bug free, and the author has been very talkative and has
implemented some enhancements/repairs that I have suggested/provided.
Also to back up what Dave said - you never know when and/or even if the GC
is going to collect your connections, so always close them in a finally
block. The beauty of GC is that it's non-deterministic and allows you to be
sloppy. The horror of GC is that it's non-deterministic and allows you to
be sloppy.
Cheers,
Doug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tsmets | 2002-03-06 15:50:45 | Re: Pooled Connections (was Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3) |
| Previous Message | tsmets | 2002-03-06 12:43:42 | Re: Connections with Tomcat 3.2.4 and PostgreSQL 7.1.3 |