Return-Path: 
 <torque-dev-return-5559-apmail-db-torque-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-dev-archive@www.apache.org
Received: (qmail 85983 invoked from network); 1 Aug 2005 08:03:22 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 1 Aug 2005 08:03:22 -0000
Received: (qmail 27752 invoked by uid 500); 1 Aug 2005 08:03:22 -0000
Delivered-To: apmail-db-torque-dev-archive@db.apache.org
Received: (qmail 27604 invoked by uid 500); 1 Aug 2005 08:03:21 -0000
Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-dev-unsubscribe@db.apache.org>
List-Help: <mailto:torque-dev-help@db.apache.org>
List-Post: <mailto:torque-dev@db.apache.org>
List-Id: "Apache Torque Developers List" <torque-dev.db.apache.org>
Reply-To: "Apache Torque Developers List" <torque-dev@db.apache.org>
Delivered-To: mailing list torque-dev@db.apache.org
Received: (qmail 27590 invoked by uid 99); 1 Aug 2005 08:03:21 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Aug 2005 01:03:21 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [194.175.229.106] (HELO mail.seitenbau.net) (194.175.229.106)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Aug 2005 01:03:12 -0700
Received: from [195.127.188.18] (helo=www.seitenbau.net)
	by router1.seitenbau.net with esmtp (Exim 4.43)
	id 1DzVGW-0000PH-Nr
	for torque-dev@db.apache.org; Mon, 01 Aug 2005 10:03:16 +0200
In-Reply-To: <42EA3CE1.7040900@jahia.com>
Subject: RE: [torque-gen 3.2-rc1] Problem with PostgreSQL and BIT default
 value
To: "Apache Torque Developers List" <torque-dev@db.apache.org>
X-Mailer: Lotus Notes Release 6.0 September 26, 2002
Message-ID: 
 <OFE3CE879C.EB3C9649-ONC1257050.002BE897-C1257050.002C3EBF@seitenbau.net>
From: Thomas Fischer <fischer@seitenbau.net>
Date: Mon, 1 Aug 2005 10:03:15 +0200
X-MIMETrack: Serialize by Router on www/seitenbau(Release 6.5.1|January 21,
 2004) at
 01.08.2005 10:03:16 AM
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N






Hi Serge,

sorry I do not have the time at the moment to look into this myself, but
have you tried
<column name="ALLOW_USER_SET" default="false" type="BIT"/>
?

Background: Most probably your definition has worked within torque 3.1.x,
but the songle quotes in '0' causes problems with other dbs like hibernate,
so it got changed (should be in the list of changes)

   Thomas


Jan Bauer | Stefan Eichenhofer

Serge Huber <shuber2@jahia.com> schrieb am 29.07.2005 16:27:45:

>
> Hi all,
>
> I'm having some problems with PostgreSQL and Torque Gen 3.2 rc 1.
>
> I have the following column declaration in my XML schema file :
>
>         <column name="ALLOW_USER_SET" default="0" type="BIT"/>
>         <column name="REQUIRES_CERTIFICATE" default="0" type="BIT"/>
>
> This gets generated to :
>
>     ALLOW_USER_SET BOOLEAN default 0,
>     REQUIRES_CERTIFICATE BOOLEAN default 0,
>
> This does not work with PostgreSQL, because it considers 0 as an integer
> and does not perform implicit conversions. If this was generated instead
:
>
>     ALLOW_USER_SET BOOLEAN default '0',
>     REQUIRES_CERTIFICATE BOOLEAN default '0',
>
> It would work.
>
> I looked a bit into Torque's code base, and looked at
> org.apache.torque.engine.database.model.TypeMap.TEXT_TYPES, but these
> are shared among all platforms, so it doesn't work as expected.
>
> Is there anything I'm doing wrong ? Do you have any suggestions ? Thank
you.
>
> Regards,
>   Serge Huber.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-help@db.apache.org
>


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