Re: Extracting more useful information from PSQLException

On Jan 31, 2013, at 4:55 PM, Kris Jurka <books(at)ejurka(dot)com> wrote:

>
>
> On Fri, 28 Dec 2012, Kris Jurka wrote:
>
>> On Fri, 28 Dec 2012, Steven Schlansker wrote:
>>
>>> Is it possible / would it be a good addition to expose structured SQL
>>> error information through JDBC? If such a thing does not exist, is this
>>> a feasible contribution? I expect it might require some hacking on the
>>> PostgreSQL server side to expose the error information in a structured
>>> manner. Or am I just dreaming too much, and this is not feasible?
>>>
>>
>> There is currently a patch in progress and under discussion for the server
>> changes to expose this information.
>
> This patch was committed to the server and I've exposed these field in the
> JDBC driver through the somewhat ugly...
>
> } catch (SQLException sqle) {
> ServerErrorMessage err =
> ((PSQLException)sqle).getServerErrorMessage();
> System.out.println(err.getTable());
> }
>
> The server infrastructure doesn't cover all the error cases I would have
> hoped, so you can't just through data at the database and always be able
> to produce an intelligent error response to a user, but it's a start.
>
> http://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=991f3e5ab3f8196d18d5b313c81a5f744f3baaea
>
> https://github.com/pgjdbc/pgjdbc/commit/e9ac5f8d964202ab5d43e401d74dcd76cefd112e
>

Fantastic! Thanks so much. I'll use this in the next revision of our database code :-)