#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    69
    Rep Power
    13

    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.

    Regards.
    Last edited by ggnanaraj; October 1st, 2002 at 01:58 AM.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    409
    Rep Power
    13

    Question


    Hey, what are you using as your Java application server?
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    69
    Rep Power
    13
    Hi

    Thanks for the reply.

    We are using JBoss.

    Regards.
  6. #4
  7. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Location
    Central Florida, USA
    Posts
    2,307
    Rep Power
    62
    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.
    The real n-tier system:

    FreeBSD -> PostgreSQL -> [any_language] -> Apache -> Mozilla/XUL

    Amazon wishlist -- rycamor (at) gmail.com

IMN logo majestic logo threadwatch logo seochat tools logo