From torque-user-return-8038-apmail-db-torque-user-archive=db.apache.org@db.apache.org Wed Dec 03 10:35:53 2008 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 79162 invoked from network); 3 Dec 2008 10:35:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 3 Dec 2008 10:35:53 -0000 Received: (qmail 32842 invoked by uid 500); 3 Dec 2008 10:36:04 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 32814 invoked by uid 500); 3 Dec 2008 10:36:03 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 32803 invoked by uid 99); 3 Dec 2008 10:36:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Dec 2008 02:36:03 -0800 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [217.24.207.26] (HELO mail.seitenbau.net) (217.24.207.26) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 03 Dec 2008 10:34:35 +0000 Received: from [192.168.15.18] (helo=www.seitenbau.net) by router.seitenbau.net with esmtp (Exim 4.43) id 1L7p4c-0001vx-Sd for torque-user@db.apache.org; Wed, 03 Dec 2008 11:35:20 +0100 In-Reply-To: <49359CC9.6060906@daimi.au.dk> References: <74359.65033.qm@web94810.mail.in2.yahoo.com> <49317324.4050803@daimi.au.dk> <55B8568AFA5F144F886F18186BAD5B2C2D3BBD76@durham-e2k7mb1.dukece.com> <49359CC9.6060906@daimi.au.dk> To: "Apache Torque Users List" MIME-Version: 1.0 Subject: Re: Unsigned integers X-KeepSent: 83D4CC2C:51B2B84A-C1257514:0039A57D; type=4; name=$KeepSent X-Mailer: Lotus Notes Release 8.0.2 August 07, 2008 Message-ID: From: Thomas Fischer Date: Wed, 3 Dec 2008 11:35:13 +0100 X-MIMETrack: Serialize by Router on www/seitenbau(Release 8.0.1|February 07, 2008) at 03.12.2008 11:35:13, Serialize complete at 03.12.2008 11:35:13 Content-Type: multipart/alternative; boundary="=_alternative 003A282DC1257514_=" X-Spam-Score: -1.4 (-) X-Spam-Report: -1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP X-Virus-Checked: Checked by ClamAV on apache.org --=_alternative 003A282DC1257514_= Content-Type: text/plain; charset="US-ASCII" > > That said, the best bet would be to manually define the column > > type to be an UNSIGNED INTEGER in the DB and then use BIGINT > > as the type in the schema. This will make the Record object > > use the long type and avoid having large binary int values > > become negative. > > > That sound like a good solution. The only small problem is that I > generate the schema.xml directly from the database, > so next time i change the database and need a new schema.xml file, I > will have to change the schema.xml file again. IMHO torque:jdbc is no good as a totally automatic way to create a schema.xml. It is good as a first guess, but nothing more, because the informations from the jdbc driver are not complete enough to extract a good schema. If it worked for you so far, you were lucky. > Oh and to be total off-topic: Does anyone have a description/status for > "torque 4.0" I am thinking about things such as > "New features","Status"(Is anyone really working on it at all) and > "expected release date"). Hm, yes, "we are thinking about it" is a good description of the status. The problem is that everybody was very busy with other stuff the last half of a year. But now with the economy crisis coming, probably there will be more time in the near future. Thomas --=_alternative 003A282DC1257514_=--