Re: jdbc pooling question - Mailing list pgsql-jdbc

From Paul Thomas
Subject Re: jdbc pooling question
Date
Msg-id 20040111233303.A15827@bacon
Whole thread Raw
In response to Re: jdbc pooling question  (Kris Jurka <books@ejurka.com>)
Responses Re: jdbc pooling question
List pgsql-jdbc
On 11/01/2004 22:14 Kris Jurka wrote:
> [snip]
> Closing the connection will return the connection to the pool regardless
> of the status of other related objects.  The fact that closing the
> statement and the connection doesn't completely close the ResultSet is a
> bug, but not a terribly serious one.  Adding a check for every single
> method to check some kind of isClosed flag is tedious and wasteful.

Plus there are a number of robust open-source connection pool
implementations available. I use Apache dbcp (via Tomcat) and it all works
very nicely and can also clean up resource leaks left by non-programmers
who don't know how to correctly use a finally block :)

OT, I can't really see the point of re-inventing the wheel by providing
our own connection pooling. Does anyone else have any views on this?

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Multi-dimensional array support
Next
From: Kris Jurka
Date:
Subject: Re: PreparedStatement parameters and mutable objects