Thread: jdbc 7.2b1 question...

Hi all,

The JDBC API does provide methods to extract data from the SQLException, such as the SQLSTATE and special vendor codes.
These usually contains more specific info which allows programmers to make more intelligent choices and recover from
errors.

However, the current JDBC code (7.1.3) for postgres seems to be is sorely lacking in the ability to percolate specific
errors. Most java sql commands only throw one exception: SQLException.  By itself, this doesn't tell us much. 

Is there some type of this support in the 7.2 version of the JDBC driver?

Thanks,

--
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere

Laurette,

This is actually a limitation of the postgresql server itself.  The
server currently has no concept of error codes, it only has strings.
Therefore there is little the jdbc driver can do until this
functionality is incorporated into the backend server.  This is
currently on the todo list for the server.

thanks,
--Barry

Laurette Cisneros wrote:

> Hi all,
>
> The JDBC API does provide methods to extract data from the SQLException, such as the SQLSTATE and special vendor
codes. These usually contains more specific info which allows programmers to make more intelligent choices and recover
fromerrors. 
>
> However, the current JDBC code (7.1.3) for postgres seems to be is sorely lacking in the ability to percolate
specificerrors.  Most java sql commands only throw one exception: SQLException.  By itself, this doesn't tell us much. 
>
> Is there some type of this support in the 7.2 version of the JDBC driver?
>
> Thanks,
>
>