Hi,
Even after using addOrderByAscending(),addOrderBydesending()
the sorting of data is not working.
The repository user xml mapping is as follows:
<class-descriptor
class="com.inetpsa.pac.ojb.bean.EntityData" table="PACQTENT">
<field-descriptor id="1" name="entcode"
column="ID" jdbc-type="INTEGER" primarykey="true" autoincrement="true"
access="readonly" />
<field-descriptor id="2" name="entityAcronym"
column="ACRONYM" jdbc-type="CHAR" />
<field-descriptor id="3" name="entlibelle"
column="LABEL" jdbc-type="VARCHAR" />
<field-descriptor id="4" name="startDate"
column="STARTDATE" jdbc-type="DATE" />
<field-descriptor id="5" name="completeDate"
column="ENDDATE" jdbc-type="DATE" />
<field-descriptor id="6" name="attribute1"
column="ATTRIBUTE1" jdbc-type="CHAR" />
<field-descriptor id="16" name="parentid"
column="PARENTID" jdbc-type="INTEGER" access="anonymous" />
<reference-descriptor
class-ref="com.inetpsa.pac.ojb.bean.EntityData" name="parentEntity"
auto-retrieve="true">
<foreignkey field-ref="parentid" />
</reference-descriptor>
</class-descriptor>
We are querying on this table sorting by the entity acronym
field.
java version : jdk 1.4
OJB version : 1.0
error messages : none. Only data not sorted
Please Help!
Very urgently needed.
Thanks and Regards,
Vagula
-----Original Message-----
From: Danilo Tommasina [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 4:42 PM
To: OJB Users List
Subject: Re: Order By not working!
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
