Hello J�rgen, I have the same problem and tried all the previous hints, but i still habe the same problem. Is this a bug in Torque 3.1? Is there a better solution available now?
> -----Original Message----- > From: J�rgen Hoffmann [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 13, 2004 6:25 PM > To: Apache Torque Users List > Subject: Re: Criteria.addAscendingOrderByColumn(field) NullPointerEx > > Hi Jaya, > > before you do anything with the Criteria try the following: > > Criteria c = new Criteria(); > c.setDbName("mydb"); > . > . > . > c.addAscendingOrderByColumn(PeerClassPeer.ORDER_COLUMN); > > PeerClassPeer.doSelect(c); > > This should solve your Problem. > > kind regards > > J�rgen Hoffmann > > Jaya wrote: > > >Hi, > > > >I have added the following in torque.properties file > > > >torque.database.default=mydb > >torque.database.mydb.adapter=oracle > > > >where mydb is the db name.But still I am getting the same > error ,if we > >use addAscendingOrderByColumn() for sorting the character values. > > > >Please let me know what should be done. > > > >Thank you, > >Regards, > >Jaya. > > > > > > > >-----Original Message----- > >From: Gerhard Otte [mailto:[EMAIL PROTECTED] > >Sent: Friday, January 09, 2004 1:30 PM > >To: Apache Torque Users List > >Subject: AW: Criteria.addAscendingOrderByColumn(field) NullPointerEx > > > > > >[EMAIL PROTECTED]@.adapter=oracle > > > >HTH > >Gerhard Otte > >__ > >mailto:[EMAIL PROTECTED] emediapark GmbH > http://www.emediapark.de > >Tel:+49 (0)941 630804-2 Fax:-9 Hemauerstr.14,93047 > Regensburg,Germany > > > >-----Urspr�ngliche Nachricht----- > >Von: Jaya [mailto:[EMAIL PROTECTED] > >Gesendet: Freitag, 9. Januar 2004 06:04 > >An: Apache Torque Users List > >Betreff: RE: Criteria.addAscendingOrderByColumn(field) NullPointerEx > > > > > >Hello, > > > >We are also facing the same problem. > > > >Please let me know how to specify the parameter in torque.properties > >for oracle database. > > > >Thank you, > >Regards, > >Jaya. > > > > > > > >-----Original Message----- > >From: mr.x [mailto:[EMAIL PROTECTED] > >Sent: Thursday, December 18, 2003 1:03 AM > >To: 'Apache Torque Users List' > >Subject: RE: Criteria.addAscendingOrderByColumn(field) NullPointerEx > > > > > >Hello > > > >Thanks for your replies. Finally i found the problem: the parameter > >"[EMAIL PROTECTED]@.adapter=mysql" was missing > >(misspelled) in the configs. Strange behaviour ;-> > > > >Anyway. Thanks for helping > > > >Cheers Rolf > > > >-----Original Message----- > >From: Gerhard Otte [mailto:[EMAIL PROTECTED] > >Sent: Dienstag, 16. Dezember 2003 11:56 > >To: Apache Torque Users List > >Subject: AW: Criteria.addAscendingOrderByColumn(field) NullPointerEx > > > > > >Hello Rolf > > > >I faced the same problem here - NullPOinter Exception when using > >addAscendingOrderByColumn(). After putting the line > >torque.database.LVS.adapter=mssql (where LVS is the Name of > my database > >using SQL Server) into my configuration file the problem > didn't come up > >again. > > > >I think it has to do with database naming. Kind of magic. > > > >Bye > >Gerhard Otte > >__ > >mailto:[EMAIL PROTECTED] emediapark GmbH > http://www.emediapark.de > >Tel:+49 (0)941 630804-2 Fax:-9 Hemauerstr.14,93047 > Regensburg,Germany > > > >-----Urspr�ngliche Nachricht----- > >Von: mr.x [mailto:[EMAIL PROTECTED] > >Gesendet: Montag, 15. Dezember 2003 20:49 > >An: [EMAIL PROTECTED] > >Betreff: Criteria.addAscendingOrderByColumn(field) NullPointerEx > > > > > >Hello all > > > >I'm currently developing my first "torque based" java-app. (Almost) > >everything works fine; but if i use > addAscendingOrderByColumn() with a > >character field or use setLimit() on a Criteria object i get a > >NullPointerException: > >java.lang.NullPointerException > > at > >org.apache.torque.util.BasePeer.createQuery(BasePeer.java:1277) > > at > >org.apache.torque.util.BasePeer.createQueryString(BasePeer.java:984) > > at > org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1391) > > at > org.apache.torque.util.BasePeer.doSelect(BasePeer.java:1368) > >(Sample=addAscendingOrderByColumn) > > > >I'm using torque 3.1 on winxp with mysql 4.0.15 > > > >Is this a torque "feature" or a "config issue" ? Is it > possible to sort > >and or limit the result set in another way ? (... groupBy > works i know > >-> thats not sorting ;->) > > > >Thanks for help > > > >Regards > > > >Rolf > > > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
