Pooled connections idle timeout - Mailing list pgsql-jdbc

From Daniele Depetrini
Subject Pooled connections idle timeout
Date
Msg-id 48988A12.4070201@criticalpath.net
Whole thread Raw
Responses Re: Pooled connections idle timeout  (Daniele Depetrini <daniele.depetrini@criticalpath.net>)
List pgsql-jdbc
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.

pgsql-jdbc by date:

Previous
From: Gustav Trede
Date:
Subject: Re: macaddr data type and prepared statements
Next
From: Grant Quimby
Date:
Subject: Weird pause when running statements