Re: Hibernate and Postgres 8.3/8.4 - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Hibernate and Postgres 8.3/8.4
Date
Msg-id 4A8F9CDF.6040601@opencloud.com
Whole thread Raw
In response to Hibernate and Postgres 8.3/8.4  (Michael Bell <mikebell90@yahoo.com>)
Responses Re: Hibernate and Postgres 8.3/8.4  (Michael Bell <mikebell90@yahoo.com>)
Re: Hibernate and Postgres 8.3/8.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-jdbc by date:

Previous
From: Michael Bell
Date:
Subject: Hibernate and Postgres 8.3/8.4
Next
From: Michael Bell
Date:
Subject: Re: Hibernate and Postgres 8.3/8.4