Re: Logging from multiple connections - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Logging from multiple connections
Date
Msg-id 438526BC.7080406@opencloud.com
Whole thread Raw
In response to Re: Logging from multiple connections  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Oliver Jowett wrote:
> Kevin Grittner wrote:
>
>> Wading through loglevel=2 output today, it occurred to me that it would
>> be nice if the jdbc log file included a prefix with something to
>> identify the connection.  Sometimes you can only get an error to occur
>> on a busy system with multiple active connections, and the jdbc log
>> currently mixes everything together, which can make it hard to follow.
>
>
> Yes, this is on my todo list..
>
> The simplest way to do it seems to be to just have a static driver-wide
> counter to assign IDs to connections.

I just committed something like this to CVS HEAD -- loglevel is now
handled per connection (previously it was effectively driver-wide,
despite being specified as part of the connection URL), and logging
output now has both a connection ID and timestamp on each line.

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Why is bool == java.sql.Types.BIT ??
Next
From: Oliver Jowett
Date:
Subject: Re: Can PostgreSQL do data type automated casting in