Re: SQLSTATE with pg74.1jdbc3.jar

Paul Thomas ha scritto:

> On 15/01/2004 14:50 Moreno Mauri wrote:
> > Hi all,
> > I'm a newbie in JDBC code.
> >
> > I tried to execute a Statement.executeUpdate() method to insert a
row
> > already present in my Postgresql DB.
> >
> > With JDBC I receive a SQLException but I would like to have
> > more informations about the error (something like Duplicate Key
> > Exception).
> >
> > I read that SQLException class have the getSQLState() method, but
> > when I call it, the result is null (the getErrorCode() return always
0).
>
> What version of PostgreSQL are you running? To get the error codes
> requires a 7.4 server.

This was really a newbie error: I'm using postgresql 7.2 !

I changed the driver (now is pgjdbc2.jar) but the problem
didn't disappear.

Thanks
Moreno

p.s. for Dennis Romero: I can't answer your question :-(