Re: Expressiveness of SQLException

[Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>]

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