Re: Pooled connections idle timeout

Hi Again,

Any ideas?

Daniele.

Daniele Depetrini wrote:
> Hi All,
>
> 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();
>        pool.setDataSourceName("DB");
>        pool.setServerName(servername);
>        pool.setDatabaseName(db);
>        pool.setUser(user);
>        pool.setPassword(password);
>        pool.setPortNumber(port);
>        pool.setMaxConnections(maxConn);
>
> Connections are opened and closed via conn=pool.getConnection() /
> conn.close().
>
> 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,
>
> Daniele.
>