logging sql from JDBC

Started by David Parkerover 20 years ago3 messages
#1David Parker
dparker@tazznetworks.com

It appears that SQL submited via the latest JDBC driver won't get logged
even if log_min_duration_statement is set appropriately. From what I've
found in the archives, this is because the driver uses an "extended"
version of the protocol.

Could somebody point me at the area of the source where this decision
gets made, and/or how difficult it would be to enable this logging?

Thanks!

- DAP
------------------------------------------------------------------------
----------
David Parker Tazz Networks (401) 709-5130

#2Simon Riggs
simon@2ndquadrant.com
In reply to: David Parker (#1)
Re: logging sql from JDBC

On Wed, 2005-05-25 at 12:03 -0400, David Parker wrote:

Could somebody point me at the area of the source where this decision
gets made, and/or how difficult it would be to enable this logging?

This has just been fixed for 8.1, patch recently submitted.

In the meantime, use p6spy

Best Regards, Simon Riggs

#3David Parker
dparker@tazznetworks.com
In reply to: Simon Riggs (#2)
Re: logging sql from JDBC

Thanks!

Show quoted text

-----Original Message-----
From: Simon Riggs [mailto:simon@2ndquadrant.com]
Sent: Friday, May 27, 2005 11:45 AM
To: David Parker
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] logging sql from JDBC

On Wed, 2005-05-25 at 12:03 -0400, David Parker wrote:

Could somebody point me at the area of the source where this

decision

gets made, and/or how difficult it would be to enable this logging?

This has just been fixed for 8.1, patch recently submitted.

In the meantime, use p6spy

Best Regards, Simon Riggs