RE: Criteria.addAscendingOrderByColumn(field) NullPointerEx

[Jaya <ja...@gft.com>]

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:mr.x@tele2.ch]
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
"torque.database.@torque.database.name@.adapter=mysql" was missing
(misspelled) in the configs. Strange behaviour ;->

Anyway. Thanks for helping

Cheers Rolf

-----Original Message-----
From: Gerhard Otte [mailto:Gerhard.Otte@emediapark.de]
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:G.Otte@emediapark.de     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:mr.x@tele2.ch]
Gesendet: Montag, 15. Dezember 2003 20:49
An: torque-user@db.apache.org
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: 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