You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Daniel Kreuzhofer <da...@netoption.de> on 2004/04/20 20:37:37 UTC

RE: Criteria.addAscendingOrderByColumn(field) NullPointerEx

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:jh@byteaction.de] 
> 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:Gerhard.Otte@emediapark.de]
> >Sent: Friday, January 09, 2004 1:30 PM
> >To: Apache Torque Users List
> >Subject: AW: Criteria.addAscendingOrderByColumn(field) NullPointerEx
> >
> >
> >torque.database.@torque.database.name@.adapter=oracle
> >
> >HTH
> >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: Jaya [mailto:jaya@gft.com]
> >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: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
> >
> >
> >---------------------------------------------------------------------
> >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


Which one of these is a good design?

Posted by Saravana Kannan <sk...@engr.uky.edu>.
Hi,

  Since almost all of the people in this list have probably worked a lot with 
DBs, I pose this question hoping for some guidance -

I'm developing a WebApp and deploying it using Tomcat. I have several Entities 
that are represented as my own classes in the Business Logic layer and as Torque 
OM classes in the DB layer (there is also ofcourse a UI layer but it is not 
relevant in this question). Which one of these is a good design?

1. My classes extend the DB layer classes and to persist my objects, I do a 
myobject.save().

2. My classes dont extend DB layer classes, instead they have a method, say, 
toDB() which gives me the Torque OM representation of my object. To persist 
myobjects I do xyz=myobjects.toDB() then xyz.save().

Please guide me as I'm continuing development a half completed code written by 
someone else. The code is in alpha stage. It currently follows design 2, but I 
thought it would be better to follow design 1. What do you say?

~Sarav.

-- 
There are 10 kinds of people in the world,
those who know binary and those who don't.

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Bug in copy() for blob field?

Posted by sk...@engr.uky.edu.
Hi,

  I have a table called Image with a field called data which is of type Blob. I 
noticed that the copy() of the Image object has something like (actually code 
below is that of copyInto() which is called by copy() )

{
          copyObj.setImageId(imageId);
          copyObj.setReferenceId(referenceId);
          copyObj.setData(data);

          copyObj.setImageId(0);


        return copyObj;
}

and setData() is like -

    public void setData(byte[] v)
    {

           if (!ObjectUtils.equals(this.data, v))
           {
            this.data = v;
            setModified(true);
           }


    }

Isn't this wrong? Coz if I do

Image X = Y.copy();

and then change the value of Y.data then the value of the X.data will also 
change! Since X.data and Y.data refer to the same byte[].

~Sarav

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Release a connection

Posted by Alexandru Dovlecel <al...@siemens.com>.
Hi all,

I am using a connection pool defined by torque in the runtime config file
(see end of message). I want to implement a transaction using the objects
generated by torque. So I create a
java.sql.Connection con = Transaction.begin( "transporter" ) ;

After executing the methods I call the Transaction.rollBack or
Transaction.commit( con ) method.

QUESTION: DO I HAVE TO CLOSE THE CONNECTION??? Like con.close() ???

What if I'm going to use a DataSet exposed with the JNDI and referenced by
torque? Do I have to close the connection?

The code generated by torque does not close the connection. Is it correct?

Pls answer ASAP. Thanks,
Alex

Here is the config file:


torque.database.transporter.adapter=mssql
torque.database.transporter.driver=com.microsoft.jdbc.sqlserver.SQLServerDri
ver
torque.database.transporter.url=jdbc:microsoft:sqlserver://localhost:1433;Da
tabaseName=mydb
torque.database.transporter.username=myuser
torque.database.transporter.password=mypwd

torque.dsfactory.transporter.factory=org.apache.torque.dsfactory.SharedPoolD
ataSourceFactory
torque.dsfactory.transporter.connection.driver=com.microsoft.jdbc.sqlserver.
SQLServerDriver
torque.dsfactory.transporter.connection.url=jdbc:microsoft:sqlserver://local
host:1433;DatabaseName=mydb
torque.dsfactory.transporter.connection.user=myuser
torque.dsfactory.transporter.connection.password=mypwd


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


RE: Criteria.addAscendingOrderByColumn(field) NullPointerEx

Posted by Daniel Kreuzhofer <dk...@netoption.de>.
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:seade@backstagetech.com.au] 
> 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:jh@byteaction.de] 
> >>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:Gerhard.Otte@emediapark.de]
> >>>Sent: Friday, January 09, 2004 1:30 PM
> >>>To: Apache Torque Users List
> >>>Subject: AW: Criteria.addAscendingOrderByColumn(field) 
> NullPointerEx
> >>>
> >>>
> >>>torque.database.@torque.database.name@.adapter=oracle
> >>>
> >>>HTH
> >>>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: Jaya [mailto:jaya@gft.com]
> >>>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: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


Re: Criteria.addAscendingOrderByColumn(field) NullPointerEx

Posted by Scott Eade <se...@backstagetech.com.au>.
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:jh@byteaction.de] 
>>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:Gerhard.Otte@emediapark.de]
>>>Sent: Friday, January 09, 2004 1:30 PM
>>>To: Apache Torque Users List
>>>Subject: AW: Criteria.addAscendingOrderByColumn(field) NullPointerEx
>>>
>>>
>>>torque.database.@torque.database.name@.adapter=oracle
>>>
>>>HTH
>>>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: Jaya [mailto:jaya@gft.com]
>>>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: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