October 1st, 2002, 01:53 AM
JDBC Connections to PostgreSQL
Is there a table to monitor JDBC connections to the PostgreSQL database ?
We have users accessing this database using JDBC drivers from application servers, but how do you monitor them ??
Thanks for your valuable input.
Last edited by ggnanaraj; October 1st, 2002 at 01:58 AM.
October 1st, 2002, 07:36 PM
Hey, what are you using as your Java application server?
October 2nd, 2002, 10:38 PM
Thanks for the reply.
We are using JBoss.
October 2nd, 2002, 11:46 PM
I don't know if there is some specific way to monitor JDBC connections, but PostgreSQL's internal system tables allow you to monitor connections in general. If you are using only JDBC to connect, then PostgreSQL connection statistics will also be JDBC connection statistics. You just need to figure out how to understand the system tables, and you will be able to monitor your connections.