Re: Feature Request: PSQLException verbosity option - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Feature Request: PSQLException verbosity option
Date
Msg-id Pine.BSO.4.64.0805192305400.29480@leary.csoft.net
Whole thread Raw
In response to Feature Request: PSQLException verbosity option  (Daniel Migowski <dmigowski@ikoffice.de>)
Responses Re: Feature Request: PSQLException verbosity option
List pgsql-jdbc

On Fri, 25 Apr 2008, Daniel Migowski wrote:

> For my application it would be great to be able to increase the
> verbosity of the SQLExceptions. I found out that PSQL-Exceptions that
> are based on server errors call ServerErrorMessage.toString(), which
> itself is configured with a verbosity parameter which equals the
> loglevel of the PostgreSQL JDBC Driver. By setting the loglevel to 1
> (INFO), the driver prints info to the DriverManager.getLogWriter() in
> other occassions, too, which is not exactly what I need. Currently I
> solve this dilemma by using the driver option "loglevel=1", and setting
> DriverManager's logwriter to a NullPrintStream.
>
> Would it be possible to add an exceptionloglevel option to the driver?
> This option would make the driver silent, but the exeptions, which get
> commonly printed to logfiles, more verbose.

Maybe we should just increase the default verbosity.  The original idea
was that we didn't want to overwhelm the stacktrace with secondary
information.  Perhaps we should just dump everything we can as it's
obviously useful in these cases.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: SET client_encoding = 'UTF8'
Next
From: Kris Jurka
Date:
Subject: Re: Two BLOBs (OID) in table?