db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Graham Leggett <minf...@sharp.fm>
Subject Postgres' bit handling hosed
Date Sat, 12 Jul 2003 19:20:17 GMT
Hi all,

I have defined a column in a table like so:

     <column
       name="active"
       required="true"
       type="BIT"
       description=""/>

When using criteria to query this column like so:

criteria.add(CompanyPeer.ACTIVE, true);

It results in the following added to the query:

WHERE company.ACTIVE=1

This causes the following SQLException:

java.sql.SQLException: ERROR:  Unable to identify an operator '=' for 
types 'boolean' and 'integer'
         You will have to retype this query using an explicit cast

I am using Postgres v7.3, and the latest Torque v3.1 snapshot as 
provided by Maven.

Any ideas?

Regards,
Graham
-- 
-----------------------------------------
minfrin@sharp.fm		"There's a moon
					over Bourbon Street
						tonight..."


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


Mime
View raw message