Re: Order By not working!

Danilo Tommasina Wed, 29 Mar 2006 22:59:49 -0800

Hi,

Activate p6spy and let the generated SQL statement be logged, then take the 
statement and execute it in a database SQL client.
If the sorting does not work there then it is the database having trouble 
sorting a CHAR column, otherwise it is OJB.


why do you use:
 criteria.addLike( "UPPER(ACRONYM)", entityAcronym.trim().toUpperCase() );
instead of:
 criteria.addLike( "UPPER(entityAcronym)", entityAcronym.trim().toUpperCase() );

The above statement will probably work only because OJB is unable to find the internal name 'ACRONYM' and will simply write it as it is in the SQL statement.This way there is a double self correcting error, it will work, but maybe there are collateral effects.


bye
danilo


Vagula wrote:

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]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: Order By not working!

Reply via email to