Order By not working!

[Vagula <Va...@infosys.com>]

Hi,



            The following query is not working for wild character search
(%, ?,  *)

           

                        criteria.addLike("UPPER(ACRONYM)
",entityAcronym.trim().toUpperCase());

                        criteria.addOrderBy("entityAcronym");

                        query = new QueryByCriteria(EntityData.class,
criteria);                      



entityAcronym: can either be simple string or any of the wild characters




This is an urgent requirement.



Please Help!!!!!            



Thanks and Regards,

Vagula







**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

Re: Order By not working!

[Danilo Tommasina <dt...@risksys.com>]

Hi,

Criteria.addOrderBy(...) is deprecated, you should use the addOrderByAscending(...) or addOrderByDescending(...) on the QueryByCriteria instance.

If this does not work, please provide more information, java version, OJB version, error messages, repository XML definition for the table, table DDL or anthing 
that could be helpful to figure out what the problem is.

bye
danilo

> Hi,
> 
> 
> 
>             The following query is not working for wild character search
> (%, ?,  *)
> 
>            
> 
>                         criteria.addLike("UPPER(ACRONYM)
> ",entityAcronym.trim().toUpperCase());
> 
>                         criteria.addOrderBy("entityAcronym");
> 
>                         query = new QueryByCriteria(EntityData.class,
> criteria);                      
> 
> 
> 
> entityAcronym: can either be simple string or any of the wild characters
> 
> 
> 
> 
> This is an urgent requirement.
> 
> 
> 
> Please Help!!!!!            
> 
> 
> 
> Thanks and Regards,
> 
> Vagula
> 
> 
> 
> 
> 
> 
> 
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***

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