Re: SQLSTATE with pg74.1jdbc3.jar - Mailing list pgsql-jdbc

From Moreno Mauri
Subject Re: SQLSTATE with pg74.1jdbc3.jar
Date
Msg-id 4006B647.407805FD@italtel.it
Whole thread Raw
Responses Re: SQLSTATE with pg74.1jdbc3.jar
List pgsql-jdbc
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 :-(




pgsql-jdbc by date:

Previous
From: "Dennis Romero L."
Date:
Subject: Re: SQLState with pg74.1jdbc3.jar
Next
From: Melanie Bergeron
Date:
Subject: problem to connect to database