From torque-user-return-2691-apmail-db-torque-user-archive=db.apache.org@db.apache.org Thu Jul 10 15:14:00 2003 Return-Path: Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 41996 invoked by uid 500); 10 Jul 2003 15:13:59 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Turbine Torque Users List" Reply-To: "Turbine Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 41926 invoked from network); 10 Jul 2003 15:13:58 -0000 Received: from sam.hotapp.com (HELO sam.bka-inc.com) (12.145.73.6) by daedalus.apache.org with SMTP; 10 Jul 2003 15:13:58 -0000 Received: from sleipnir (users.springfield.bka-inc.com [12.145.79.23]) by sam.bka-inc.com (8.12.8/8.12.8) with ESMTP id h6AFGsXR031229 for ; Thu, 10 Jul 2003 11:17:03 -0400 Reply-To: From: "Tim Clotworthy" To: "'Turbine Torque Users List'" Subject: RE: Criteria.addAscendingOrderByColumn() bug? (DB IS NULL) Date: Thu, 10 Jul 2003 11:13:53 -0400 Organization: BKA Message-ID: <000b01c346f5$e3446cb0$3201a8c0@sleipnir> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 In-Reply-To: <200307100212.AA01764@CM00001.arksystems.co.jp> X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Thanks for reply. I am checking the Criteria object right before the doSelect() is called, and it contains the proper database name. So I assume this means my problem lies elsewhere.. Any other ideas? Thanks. > -----Original Message----- > From: Koichi Nakagawa [mailto:nakagawa@arksystems.co.jp] > Sent: Wednesday, July 09, 2003 10:12 PM > To: Turbine Torque Users List > Subject: Re: Criteria.addAscendingOrderByColumn() bug? (DB IS NULL) > > I don't have no problem with using a string column for ordering. > I solved this problem checking the following. > > 1. Check schema.xml file . > (name attribute of database element) > > In many case , this attribute is missing. > > >In my schema file I have the element > > > # Geoff , It's OK. > > 2. Check Torque.prperties > (torque.database.XXXX.adapter=RDBMS NAME) > XXXX must be your database name. > > > > Geoff Fortytwo wrote: > >I'm having the problem as well. People have asked about this on this list > a > >number of times, but no one seems to have an answer. The problem lies > with > >using a string column for ordering vs any other column type. Try ordering > >with any other column which is not a string column. I'll bet it works. > > > >In the source code of BasePeer, it appears that the "db" variable is > null. > >That variable is only referred to if the order by column is a string, so > >that's why there's a problem only when using string columns to order by. > > > >The value of db is set higher up in the function with: > > DB db = Torque.getDB(criteria.getDbName()); > > > >So for some reason Torque.getDB is returning null. > > > >I've tried creating the Criteria using: > > Criteria crit = new Criteria(); > >or > > Criteria crit = new Criteria("rego"); > >where "rego" is my database name. > > > >I've tried calling > > crit.setDbName("rego"); > > > >In my schema file I have the element > > > > > >But none of those things makes any difference. > > > >Can anyone help? Does anyone know how to fix this? > > > > > >At 01:50 PM 7/9/2003, Tim Clotworthy wrote: > >>Thanks for the reply. Did you ever resolve this, and if so, could you > >>tell me how? I am using Oracle9i database, and torque3.0. Thanks again. > >> > >> > -----Original Message----- > >> > From: Duddikunta, Padmanabha [mailto:Pkd2@cdc.gov] > >> > Sent: Wednesday, July 09, 2003 4:32 PM > >> > To: 'Turbine Torque Users List' > >> > Subject: RE: Criteria.addAscendingOrderByColumn() bug? > >> > > >> > I have encountered same NullPointerException when ordering by > >>ascending as > >> > well as descending. > >> > > >> > Paddy > >> > > >> > > >> > -----Original Message----- > >> > From: Tim Clotworthy [mailto:tclotworthy@bka-inc.com] > >> > Sent: Wednesday, July 09, 2003 4:22 PM > >> > To: Torque-User@Db. Apache. Org > >> > Subject: Criteria.addAscendingOrderByColumn() bug? > >> > > >> > Hello, > >> > I was hoping some could tell me whether there are any know bugs with > >>the > >> > > >> > org.apache.torque.util.Criteria. addAscendingOrderByColumn() method? > >> > I have a very simple query: > >> > > >> > FESCriteria crit = new FESCriteria(); > >> > > >>crit.addAscendingOrderByColumn(RefTransactionCodesPeer.TYPE_OF_TRANSAC TI > >> > ON); > >> > > >> > transList = (ArrayList) RefTransactionCodesPeer.doSelect(crit); > >> > > >> > If I leave out the addAscendingOrderByColumn line, it works fine. > When > >> > included, > >> > I get an exception: > >> > > >> > java.lang.NullPointerException > >> > at > >> > org.apache.torque.util.BasePeer.createQuery(BasePeer.java:1209) > >> > at > >> > org.apache.torque.util.BasePeer.createQueryString(BasePeer.java:927) > >> > at > >>org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1321) > >> > at > >> > com.hotapp.fes.om.BaseRefTransactionCodesPeer.doSelectVillageRecords( > >> > BaseRefTransactionCodesPeer.java:398) > >> > at > >> > com.hotapp.fes.om.BaseRefTransactionCodesPeer.doSelectVillageRecords( > >> > BaseRefTransactionCodesPeer.java:366) > >> > at > >> > com.hotapp.fes.om.BaseRefTransactionCodesPeer.doSelect(BaseRefTransac > >> > tionCodesPeer.java:334) > >> > at > >> > com.hotapp.fes.support.FESSupportDAO.selectTransTypes(FESSupportDAO.j > >> > ava:202)...blah, blah, blah.. > >> > > >> > I have verified that the RefTransactionCodesPeer.TYPE_OF_TRANSACTION > >>is > >> > equivalent to a valid and appropriate String value, so its not that. > >> > > >> > Any ideas would be greatly appreciated. Thanks. > >> > > >> > > >> > > >> > --------------------------------------------------------------------- > >> > 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 > > > > > >--------------------------------------------------------------------- > >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 --------------------------------------------------------------------- To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org For additional commands, e-mail: torque-user-help@db.apache.org