I'm running JDBC 8.3-603 drivers against PG server 8.3.3. I'm using
JDBC3.0 API with connection pooling. Here my pool init code:
pool = new Jdbc3PoolingDataSource();
Connections are opened and closed via conn=pool.getConnection() /
I've noted that once a connection get opened since needed, it's never
really closed, application and database stay connected up to restart.
Since I'm writing a java server application, my application will
eventually stay up for a long time and spike of traffics can open a lot
of connectoins to PG that will never be released, even in low traffic time.
Is there any auto-idle-close mechanism, either client or server level?
Thanks in advance,
pgsql-jdbc by date
|Next:||From: Grant Quimby||Date: 2008-08-06 00:56:38|
|Subject: Weird pause when running statements|
|Previous:||From: Steve Foster||Date: 2008-08-05 08:46:05|
|Subject: Re: macaddr data type and prepared statements|