[HACKERS] logging sql from JDBC

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[HACKERS] logging sql from JDBC

David Parker
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
 

 
Reply | Threaded
Open this post in threaded view
|

Re: [HACKERS] logging sql from JDBC

Simon Riggs
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
 


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [hidden email])
Reply | Threaded
Open this post in threaded view
|

Re: [HACKERS] logging sql from JDBC

David Parker
In reply to this post by David Parker
Thanks!

>-----Original Message-----
>From: Simon Riggs [mailto:[hidden email]]
>Sent: Friday, May 27, 2005 11:45 AM
>To: David Parker
>Cc: [hidden email]
>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
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster