Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] Logging Queries

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Eric Frazier <ef(at)kwinternet(dot)com>
Cc: Peter Mount <peter(at)retep(dot)org(dot)uk>, PostgreSQL <pgsql-general(at)postgresql(dot)org>, Postgre JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] Logging Queries
Date: 2001-04-02 13:12:22
Message-ID: 986217142.3ac87ab6aa539@webmail.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
Quoting Eric Frazier <ef(at)kwinternet(dot)com>:

> Hi,
> 
> Peter, is that new? I have used SetLogStream with your 7.1 beta 5 driver
> and
> 7.03 Postgress but didn't see any output from queries that I didn't put
> there? 

No, it's been in there for a few years now.

> Or could it have to do with my server config that I didn't see anything?
> I
> mean no query info, I did see info on the driver and on the connection
> URLS etc.

No, it's a client side option. setLogStream() sets the stream that 
DriverManager uses, then in the JDBC driver it calls DriverManager to write to 
that log.

Peter

> 
> Thanks,
> 
> Eric 
> 
> 
> At 10:20 AM 3/29/01 +0100, Peter Mount wrote:
> >At 12:01 27/03/01 -0800, Hunter Hillegas wrote:
> >>I'm having a problem with queries sent in from a Java program.
> >>
> >>Is there any way to have the server log the queries that are coming in
> so I
> >>can see what's actually getting processed?
> >
> > From the server:
> >Can't remember which, but -d1 or -d2 when you start the postmaster 
> >sometimes works (higher values show too much detail like the query
> plans etc).
> >
> > From within the driver: use DriverManager.setLogStream()
> >
> >PeterM
> >
> >
> >---------------------------(end of
> broadcast)---------------------------
> >TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
> >
> 
> 
> Frazier Consulting
> http://www.kwinternet.com/eric
> (250) 655 - 9513
> 
> 
> 
> 



-- 
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

In response to

pgsql-jdbc by date

Next:From: Peter T MountDate: 2001-04-02 13:29:09
Subject: Re: RE: Compiling
Previous:From: jlemckeDate: 2001-04-01 06:15:07
Subject: CLASSPATH (not)

pgsql-general by date

Next:From: Peter T MountDate: 2001-04-02 13:22:28
Subject: Re: ExecSQL NullPtrEx...conn timeout?
Previous:From: KuroiNekoDate: 2001-04-02 13:09:33
Subject: Re: Log file to sql database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group