From torque-user-return-6131-apmail-db-torque-user-archive=db.apache.org@db.apache.org Tue May 31 07:05:10 2005 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 7465 invoked from network); 31 May 2005 07:05:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 May 2005 07:05:10 -0000 Received: (qmail 33371 invoked by uid 500); 31 May 2005 07:05:08 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 33343 invoked by uid 500); 31 May 2005 07:05:07 -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 33314 invoked by uid 99); 31 May 2005 07:05:07 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from mail.seitenbau.net (HELO mail.seitenbau.net) (194.175.229.106) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 31 May 2005 00:05:06 -0700 Received: from [195.127.188.18] (helo=www.seitenbau.net) by router1.seitenbau.net with esmtp (Exim 4.43) id 1Dd0o5-0005yo-1K for torque-user@db.apache.org; Tue, 31 May 2005 09:04:57 +0200 In-Reply-To: Subject: RE: nullpointer BasePeer To: "Apache Torque Users List" X-Mailer: Lotus Notes Release 6.0 September 26, 2002 Message-ID: From: Thomas Fischer Date: Tue, 31 May 2005 09:04:55 +0200 X-MIMETrack: Serialize by Router on www/seitenbau(Release 6.5.1|January 21, 2004) at 31.05.2005 09:04:56 AM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Hi, Is the table you want to use for joining (Adres) in your schema.xml ? If not, you have to put it in there (this means you have to edit the db scripts manually in order not to create and drop that table automatically, but that is the price to pay) If yes, which Torque version are you using and which is the exact code you use to do the join ? Thomas Robert Kromkamp schrieb am 30.05.2005 14:50:04: > Hi all, > > I'm trying to do a query with an order by on a foreign table. > A foreign table means another table than the one on which the doSelect is > executed. By example: > > Get a person (PersonPeer executes the doSelect query) and order by Zipcode > (Adres is the foreign orderby table) > > When i execute this i will get an error in BasePeer.java on line 1148: > > ColumnMap column = dbMap.getTable(table).getColumn(columnName); > > The adres table is not part a the dbMap (the Person table is part of it). > Is this a bug, do I do something wrong or does anyone have a solution? > > Cheers, > Robert > > --------------------------------------------------------------------- > To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org > For additional commands, e-mail: torque-user-help@db.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org