From torque-dev-return-3198-apmail-db-torque-dev-archive=db.apache.org@db.apache.org Sat Jul 12 19:20:50 2003 Return-Path: Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 70656 invoked by uid 500); 12 Jul 2003 19:20:50 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Turbine Torque Developers List" Reply-To: "Turbine Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 70642 invoked from network); 12 Jul 2003 19:20:48 -0000 Received: from unknown (HELO localhost.localdomain) (196.30.143.210) by daedalus.apache.org with SMTP; 12 Jul 2003 19:20:48 -0000 Received: from sharp.fm (localhost.localdomain [127.0.0.1]) by localhost.localdomain (8.11.6/8.11.6) with ESMTP id h6CJKHd04205 for ; Sat, 12 Jul 2003 21:20:28 +0200 Message-ID: <3F105F71.4050102@sharp.fm> Date: Sat, 12 Jul 2003 21:20:17 +0200 From: Graham Leggett User-Agent: Mozilla/5.0 (X11; U; Linux ppc; en-US; rv:1.3) Gecko/20030318 X-Accept-Language: en-gb, en-za, en MIME-Version: 1.0 To: Turbine Torque Developers List Subject: Postgres' bit handling hosed Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Hi all, I have defined a column in a table like so: 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