From: | Jojo Paderes <jojo(dot)paderes(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Detailed Stored Proc Exception Message at JDBC Layer |
Date: | 2005-11-05 13:16:32 |
Message-ID: | 65f9ddfb0511050516h214782ffq7f1e9b478208db9d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi Kris,
Adding the "?loglevel=1" to the connection url works well. The "W"
information is sufficient to help the Java developers debug/trace the
problem on the database functions. Thanks for pointing out this
solution! :-)
regards,
jojo
On 11/5/05, Kris Jurka <books(at)ejurka(dot)com> wrote:
>
> We recently added some more detail to the default exception message, but
> unfortunately that does not cover the specific case you're interested in.
> We've got a lot of fields to choose from and don't want to overwhelm a
> user:
>
> http://www.postgresql.org/docs/8.0/static/protocol-error-fields.html
>
> To get the 'W' or "Where" information you need to increase the driver's
> loglevel via a URL parameter. Try adding "?loglevel=1" to your connection
> string. If your application is pg specific and you're using a recent
> driver version you may test if a thrown SQLException is in fact a
> PSQLException and then see if it has an available ServerErrorMessage
> object available which will have all of the fields mentioned above. For
> debugging functions you may also need the 'p' and 'q' fields (internal
> query/position) which require going up to a loglevel of 2. Unfortunately
> this spits out a whole bunch of other junk as the driver runs.
>
> It seems we should consider adding W, p, and q messages to the default
> error message or add a new URL parameter like verboseExceptions=true.
> Thoughts?
>
> Kris Jurka
>
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GUNDUZ | 2005-11-05 14:45:38 | Stable JDBC drivers for 8.1 |
Previous Message | Kris Jurka | 2005-11-05 12:52:49 | Re: Detailed Stored Proc Exception Message at JDBC Layer |