Postgres Pro
Downloads
Home   >   mailing lists

Re: error: operator does not exist: bigint = character varying - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: error: operator does not exist: bigint = character varying
Date
Msg-id 4682F285.10601@opencloud.com
Whole thread Raw
In response to error: operator does not exist: bigint = character varying  (Edoardo Panfili <edoardo@aspix.it>)
List pgsql-jdbc
Tree view 
Edoardo Panfili wrote:

> org.postgresql.util.PSQLException: ERROR: operator does not exist:
> bigint = character varying

> ps.setString(1, rilievo.dato[Rilievo.ID]);

Use a setter that's appropriate to the type e.g. setLong(), not setString().

-O

pgsql-jdbc by date:

Previous
From: Edoardo Panfili
Date:
Subject: error: operator does not exist: bigint = character varying
Next
From: Oliver Jowett
Date:
Subject: Re: error: operator does not exist: bigint = character varying