Re: error: operator does not exist: bigint = character varying

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Edoardo Panfili <edoardo(at)aspix(dot)it>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: error: operator does not exist: bigint = character varying
Date: 2007-06-27 23:28:05
Message-ID: 4682F285.10601@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2007-06-27 23:29:43 Re: error: operator does not exist: bigint = character varying
Previous Message Edoardo Panfili 2007-06-27 21:12:41 error: operator does not exist: bigint = character varying