From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Steven Schlansker <stevenschlansker(at)gmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Extracting more useful information from PSQLException |
Date: | 2013-02-01 00:55:11 |
Message-ID: | alpine.BSO.2.00.1301311951020.23428@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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.
https://github.com/pgjdbc/pgjdbc/commit/e9ac5f8d964202ab5d43e401d74dcd76cefd112e
Kris Jurka
From | Date | Subject | |
---|---|---|---|
Next Message | News Subsystem | 2013-02-01 13:18:46 | |
Previous Message | dmp | 2013-01-31 18:58:16 | Re: JDBC connection test with SSL on PG 9.2.1 server |