yes, the database name ist specified in the schema file and in the torque.properties file. Additionally i tried to set the database name in the criteria object but even if i do all this three things it still doesnt work. Did you already try to use an SQL Statement instead of criteria? I think this works so I think it has definitely something to do with the criteria object. Is that right?
> -----Original Message----- > From: Scott Eade [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 21, 2004 1:14 AM > To: Apache Torque Users List > Subject: Re: Criteria.addAscendingOrderByColumn(field) NullPointerEx > > Daniel, > > The most common cause of this problem is when the database > name has not been specified in the schema file. Are you doing this? > > Scott > > -- > Scott Eade > Backstage Technologies Pty. Ltd. > http://www.backstagetech.com.au > > > > Daniel Kreuzhofer wrote: > > >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]
