Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of p.ledbrook@gmail.com designates
 64.233.182.185 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=ijSAX8Qp6g/NFFXBTW2R58L2c2xZkgUjkGhx24smzio6AwouccLhsuMv0N7c6WUa8rMrKIKZOq+1hr7jGP5Rl8wNfY9BNfWN+IzVgXLhHdBvYuKFbFgJJcCClvehdNgeMY3Htv1CHBd4WqIjU3YfFJtMIJiWr3MYPyuCUnRtlKg=
Message-ID: <d95c613f0604150450m29eecb6es69a4b64b08b68b71@mail.gmail.com>
Date: Sat, 15 Apr 2006 12:50:13 +0100
From: "Peter Ledbrook" <peter@cacoethes.co.uk>
Sender: p.ledbrook@gmail.com
To: "Apache Torque Users List" <torque-user@db.apache.org>
Subject: Re: Postgresql, integer types, and size (Torque 3.2 only)
In-Reply-To: <d95c613f0604110108u3ffec7b4pa00877279159e950@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <d95c613f0603250505k4cf90bedk@mail.gmail.com>
	 <d95c613f0603270601r2a2c9963x@mail.gmail.com>
	 <20060410124320.F76906@minotaur.apache.org>
	 <d95c613f0604110108u3ffec7b4pa00877279159e950@mail.gmail.com>

On 11/04/06, Peter Ledbrook <peter@cacoethes.co.uk> wrote:
> > If you are still of the opinion that this is a bug, can you please prod=
uce
> > a test case and create a issue in Torque's bug tracker ?
> >
> >    Thanks,
> >
> >      Thomas
>

Well, I downloaded and ran the Torque tests, and they worked fine. I
have also looked at the code generated by Torque for Scarab, and it
uses the "correctBooleans()" method to convert booleans to integers. I
thought that having 'javaType=3D"primitive"' might be the problem, but
it has no effect on the unit test.

And yet, I'm still getting this exception in Scarab:

Caused by: org.apache.torque.TorqueException:
org.postgresql.util.PSQLException: ERROR: operator does not exist:
smallint =3D boolean
=09at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:10=
3)
=09at org.apache.torque.util.BasePeer.executeQuery(BasePeer.java:899)
=09at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:740)
=09at org.apache.torque.util.BasePeer.doSelect(BasePeer.java:702)
=09at org.tigris.scarab.om.BaseIssueTypePeer.doSelectVillageRecords(BaseIss=
ueTypePeer.java:428)
=09at org.tigris.scarab.om.BaseIssueTypePeer.doSelectVillageRecords(BaseIss=
ueTypePeer.java:400)
=09at org.tigris.scarab.om.BaseIssueTypePeer.doSelect(BaseIssueTypePeer.jav=
a:369)
=09at org.tigris.scarab.om.AbstractScarabModule.getIssueTypes(AbstractScara=
bModule.java:852)
=09at org.tigris.scarab.om.AbstractScarabModule.getIssueTypes(AbstractScara=
bModule.java:826)

Any ideas how to trace the queries that are going to PostgreSQL? I
just can't see how a boolean is being sent rather than an integer...

Cheers,

Peter

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