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]