Re: Expressiveness of SQLException

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Daniel Migowski <dmigowski(at)ikoffice(dot)de>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Expressiveness of SQLException
Date: 2008-04-24 09:48:01
Message-ID: 48105751.4080902@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Daniel Migowski wrote:

> When this function is called by JDBC, the only information stored in the
> exception is:
>
> ERROR: value too long for type character varying(255)
>
> Which makes debugging from server logfiles much harder. I expected to
> have some more exceptions encapsulated (retrievable with
> getNextException on PSQLException), but found nothing.

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/SQLException.html#getErrorCode()
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/SQLException.html#getSQLState()

--
Craig Ringer

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Chris Mattmiller 2008-04-24 11:28:45 Re: Login Roles
Previous Message Daniel Migowski 2008-04-24 07:21:07 Expressiveness of SQLException