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

From Oliver Jowett
Subject Re: Logging from multiple connections
Date
Msg-id 4384FB26.1020902@opencloud.com
Whole thread Raw
In response to Logging from multiple connections  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Logging from multiple connections  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
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 considered backend PID, but that could in theory be duplicated, and
you can always match up PID to connection ID from the initial connection
setup logging.

-O

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Room to optimize updates through ResultSet
Next
From: Thomas Kellerer
Date:
Subject: Re: Why is bool == java.sql.Types.BIT ??