Skip site navigation (1) Skip section navigation (2)

Re: Hibernate and Postgres 8.3/8.4

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Michael Bell <mikebell90(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Hibernate and Postgres 8.3/8.4
Date: 2009-08-22 07:23:11
Message-ID: 4A8F9CDF.6040601@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Michael Bell wrote:

> Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: smallint = character varying
>   Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
>   Position: 628

> The queries in question are all "correct" in that they use query.setXXX, where XXX is a "reasonable" thing like String, Integer, Long.....nothing fancy...

Well, from the exception, either Hibernate is doing setString() on a
parameter that is compared to a smallint, or it's doing setShort() on a
parameter that is compared to a varchar type.. so one of the two sides
is wrong.

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Michael BellDate: 2009-08-22 07:44:40
Subject: Re: Hibernate and Postgres 8.3/8.4
Previous:From: Michael BellDate: 2009-08-22 07:15:51
Subject: Hibernate and Postgres 8.3/8.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group