number of connection in DataSource

[finecur]

Hi,

I am using PostgreSQL and tomcat connection pool. I found a lot of
lost connections in my applications. To debug this problem, I would
like to know how many connections I have established in my application
and how many are available in the pool. How can I get this
information? I am using the DataSource API.

To get a connection, I use myDataSource.getConnection();

To close a connection, I use myConnection.close();

Thank you very much.

fm

 

[Arne Vajhøj]

I am using PostgreSQL and tomcat connection pool. I found a lot of
lost connections in my applications. To debug this problem, I would
like to know how many connections I have established in my application
and how many are available in the pool. How can I get this
information? I am using the DataSource API.

To get a connection, I use myDataSource.getConnection();

To close a connection, I use myConnection.close();

Getting information out of the pool will require you
to sniff around inside the connection pools internal
structures.

I would attack it from the other side: are all connections
opened, assigned to a local variable and closed in a finally
block ?

Arne