Re: Hibernate and Postgres 8.3/8.4

Aw jeez, ya nailed it. There was indeed a setString where there should be setShort. Dunno where my head was.

Thanks.

----- Original Message ----
From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Michael Bell <mikebell90(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Sent: Saturday, August 22, 2009 12:23:11 AM
Subject: Re: [JDBC] Hibernate and Postgres 8.3/8.4

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