error: operator does not exist: bigint = character varying

From: Edoardo Panfili <edoardo(at)aspix(dot)it>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: error: operator does not exist: bigint = character varying
Date: 2007-06-27 21:12:41
Message-ID: 4682D2C9.1010406@aspix.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I am updating from 8.2.4 to 8.3dev
the jdbc driver is postgresql-8.3dev-600.jdbc3.jar

Now my application raises this exception (all was ok with 8.2):
org.postgresql.util.PSQLException: ERROR: operator does not exist:
bigint = character varying

this is my code fragment
----------------------------------------------------------------------
PreparedStatement ps = connessione.prepareStatement("SELECT
strato.idplot, strato.idstrato, strato.nome, strato.copertura,
strato.altezza, strato.note FROM plot WHERE idplot=?");
ResultSet risultatoStrati;
ps.setString(1, rilievo.dato[Rilievo.ID]);
risultatoStrati = istruzioneStrati.executeQuery();
----------------------------------------------------------------------
The error is in the last istruction, it seems that I am doing somehing
not clean with types.

the type of idplot is
"idplot integer NOT NULL DEFAULT nextval('sequenza_plot'::regclass)"

I did a try with
ps.setInt(1, Integer.parseInt(rilievo.dato[Rilievo.ID]));

but nothing is changed.

Whath I am doing wrong?

If I exec "SELECT
strato.idplot,strato.idstrato,strato.nome,strato.copertura,strato.altezza,strato.note
FROM strato WHERE idplot=567" from pgadmin all goes well.

thank you
Edoardo

--
Jabber: edoardopa(at)talk(dot)google(dot)com
tel: 075 9142766

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2007-06-27 23:28:05 Re: error: operator does not exist: bigint = character varying
Previous Message Kalle Hallivuori 2007-06-27 20:25:39 Stream Copy for 8.1 - 8.3dev