Re: The new driver and PostgreSQL7.1.3

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: <chantal(dot)ackermann(at)web(dot)de>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: The new driver and PostgreSQL7.1.3
Date: 2001-12-20 18:45:24
Message-ID: NEBBLAAHGLEEPCGOBHDGMEKEEBAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

> I still want
> to be sure
> that the name of the jar does not mean that it can't be used
> together with
> the 7.1.3 version of the database.

My understanding based on earlier posts from "the people who should know" is
that the 7.2 driver is compatible with 7.1.3. I've been using it in this way
on a development system with no problems for a while, but of course, I don't
exercise every function.

> I get the Exception:
> java.sql.SQLException: ERROR: Unable to identify an operator '='
> for types 'int4' and 'text'
> You will have to retype this query using an explicit cast

If you can send the prepared statement text, table create statement, and the
line you get the error on to the list, it would help solve this.

One simple thing you might check first- The last time I got this error, I
had mis-counted my columns, and so I was off by one & really was trying to
stuff a string into an integer field.

-Nick

--------------------------------------------------------------------------
Nick Fankhauser nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Hunter Hillegas 2001-12-20 19:38:28 FW: JDBC Driver Munging My Text?
Previous Message Dave Cramer 2001-12-20 18:33:07 Re: The new driver and PostgreSQL7.1.3