db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramah" <ra...@gft.com>
Subject RE: Using Upper and Lower functions in Criteria
Date Mon, 22 Dec 2003 06:32:00 GMT
Heres the code which results in Null Pointer Exception

 	criteria=new Criteria();
   	criteria.add(EmpPeer.ENAME,(Object)eName,Criteria.LIKE);
	criteria.getCriterion(EmpPeer.ENAME).setIgnoreCase(true);
	List list=EmpPeer.doSelect(criteria);

I get the exception in the last line of the code.

Is anything to be modified?

Thanks and Regards
Ramah

-----Original Message-----
From: Scott Eade [mailto:seade@backstagetech.com.au]
Sent: Saturday, December 20, 2003 6:05 PM
To: Apache Torque Users List
Subject: Re: Using Upper and Lower functions in Criteria


Please post the code that builds the criteria that resulted in the NPE.

Scott

-- 
Scott Eade
Backstage Technologies Pty. Ltd.
http://www.backstagetech.com.au


Ramah wrote:

>When I tried, 
>
>criteria.getCriterion(YourPeerPeer.ENAME).setIgnoreCase(true);
>
>The following exception occurs.
>
>
>java.lang.NullPointerException
>	at org.apache.torque.util.BasePeer.createQuery(BasePeer.java:1066)
>	at org.apache.torque.util.BasePeer.createQueryString(BasePeer.java:927)
>	...
>
>Thanks and Regards,
>Ramah
>
>
>
>-----Original Message-----
>From: Scott Eade [mailto:seade@backstagetech.com.au]
>Sent: Saturday, December 20, 2003 7:34 AM
>To: Apache Torque Users List
>Subject: Re: Using Upper and Lower functions in Criteria
>
>
>Ramah wrote:
>
>  
>
>>Is there any possibility to use UPPER and LOWER function of SQL in 
>>Criteria?
>>
>>*Ex: Select eid from employee where upper(ename)='XYZ'.
>>How to create Criteria for the above Query?*
>>
>>    
>>
>
>try:
>
>            criteria.getCriterion(YourPeerPeer.ENAME).setIgnoreCase(true);
>
>Scott
>  
>




---------------------------------------------------------------------
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


Mime
View raw message