[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ojb-user
Subject:    Re: Order By not working!
From:       Danilo Tommasina <dtommasina () risksys ! com>
Date:       2006-03-30 6:59:52
Message-ID: 442B8263.3050900 () risksys ! com
[Download RAW message or body]

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:dtommasina@risksys.com] 
> 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: ojb-user-unsubscribe@db.apache.org
> 
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
> 
> 
> 

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


[prev in list] [next in list] [prev in thread] [next in thread]