Re: SQLSTATE with pg74.1jdbc3.jar

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: Moreno Mauri <moreno(dot)mauri(at)italtel(dot)it>
Cc: "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: SQLSTATE with pg74.1jdbc3.jar
Date: 2004-01-15 18:02:53
Message-ID: 20040115180253.A25975@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


On 15/01/2004 15:48 Moreno Mauri wrote:
> > 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.

versions of PG earlier than 7.4 don't supply error codes to the client (in
our case the JDBC driver). Using an earlier version of the driver does not
change this. You will need to use the latest driver _and_ update your
server to 7.4 to get access to the error codes.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Melanie Bergeron 2004-01-15 18:36:46 Re: problem to connect to database
Previous Message Csaba Nagy 2004-01-15 16:57:05 Re: problem to connect to database