Thread: How can I close an org.postgresql.jdbc3.Jdbc3ConnectionPool ?

Hi - I would like to be able to explicity and truly close all connections in
an org.postgresql.jdbc3.Jdbc3ConnectionPool but can find no way to do this.

The pool's clients do the appropriate close() on a connection when it is no
longer needed, which as i understand just puts that connection back into the
pool of available connections.

When the entire application itself is complete, can I explicity close the
pool and thus really really close the connections to the database?

As it stands now, my application simply terminates which although i assume
closes the connections implicitly, currently generates the following log
entries:

WARNING:  ROLLBACK:  no transaction in progress
LOG:  pq_recvbuf : unexpected EOF on client connection

Thanks for any advice -

_________________________________________________________________
Check out the coupons and bargains on MSN Offers!
http://shopping.msn.com/softcontent/softcontent.aspx?scmId=1418

On Sat, 31 Jan 2004, Alex Thecate wrote:

> Hi - I would like to be able to explicity and truly close all connections in
> an org.postgresql.jdbc3.Jdbc3ConnectionPool but can find no way to do this.
>
> The pool's clients do the appropriate close() on a connection when it is no
> longer needed, which as i understand just puts that connection back into the
> pool of available connections.
>
> When the entire application itself is complete, can I explicity close the
> pool and thus really really close the connections to the database?
>

Jdbc3ConnectionPool is not actually a pool despite its name.  It is just a
means of creating connections which can be pooled by external code.  So
once it creates a connection it does not track it.  You are probably
looking for Jdbc3PoolingDataSource which has the desired close method.

Kris Jurka