Sorry, I don't think I made myself clear. I don't want to query the DB
every few seconds to get its current status. I want to keep an open an
open connection and have immediate access to all information like I have
when I set the debug level high and see everything going on inside the
DB right on my machine.
I guess think of it as a dashboard that constantly displays the db
status. Something like 'top' rather than 'ps -ef|grep .....'.
As far as I understand, JDBC is just a mechanism to connect to a db,
execute queries, etc., not get this kind of info.
Shahbaz C.
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Bruce Momjian
Sent: Thursday, February 13, 2003 7:18 PM
To: Shahbaz Chaudhary
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] java access to the backend (non jdbc)?
Well, we have jdbc at jdbc.postgresql.org.
------------------------------------------------------------------------
---
Shahbaz Chaudhary wrote:
> Hi All,
> I was wondering if there is a libq or libqxx type library written in
> java. Even if it is done through jni. I would like to do some
> experiments, perhaps make a utility that reads server information such
> as currently executing query, current locks, amount of disk/ram taken
up
> by pgsql. Basically some very useful information for admins. I've
> forgotten most of C, C++ (from college days), but would love to try my
> hand at such a utility...I'm sure there are others who would like to
use
> java to access such a backend. Any pointers?
>
> Shahbaz C.
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania
19073
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
