[Springframework-developer] Re: [Springframework-user] Spring question goody-bag: postgres7.4, database backed validation, passing of form objects

[Mike M. <mik...@ma...>]

On Monday, December 15, 2003, at 09:09  pm, tri...@tr... wrote:

> Quoting Mike Moran <mik...@ma...>:
>
>> 1 - Postgres 7.4 now claims to support status codes and the like on
>> SQLException. Can Spring use these out-of-the-box or would a specific
>> mapping hierarchy have to be written?
>
> Mike,
>
> I recently installed this version, so next step is obviously for me to 
> connect
> and force an error to get a look at the error codes.  Have you seen a 
> list of
> what error codes they are using?
[ ... ]

I couldn't find any addressable javadoc for 7.4 online, but if you 
downloaded the 7.4 source tar.gz then it is in:
src/interfaces/jdbc/org/postgresql/util/PSQLState.java
src/interfaces/jdbc/org/postgresql/util/PSQLException.java

I think the latest JDBC driver supports old databases as well as the 
7.4 version so you'd have to allow for no SQLState in JDBC calls to 
them. Also, I've not checked whether the 1.3.1 compatible jdbc driver 
supports state, but from the jdbc.postgresql.org page it looks like it 
is works with 7.4, so it should.

-- 
Mike