Re: Derby not honoring order by clause (insight requested)

[Bob Morley <rm...@emforium.com>]

BJ Freeman wrote:
> 
> if I read this correct
> summary:
> using the entity engine you get the correct results
> using SQL you don't.
> since the entity engine returns the correct results what is it sending
> to the dB and how is it sorting.
> If you are sending sql(sql pass through) then you by-passing ofbiz and
> just the JBDC and databse are concerned.
> 
> =========================
> BJ Freeman
> http://bjfreeman.elance.com
> Strategic Power Office with Supplier Automation
> <http://www.businessesnetwork.com/automation/viewforum.php?f=93>
> Specialtymarket.com <http://www.specialtymarket.com/>
> 
> Systems Integrator-- Glad to Assist
> 
> Chat  Y! messenger: bjfr33man
> Linkedin
> <http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro>
> 

Hi BJ -- I think you misunderstood.  I am using the entity model via the
findByAnd method on the standard delegator implementation.  When debugging I
stepped down to the generation for the sql statement and just posted the raw
sql that Ofbiz was generating.

BTW - I had edited my original post to fix a mis-spelling in the title, so I
just quoted your post back to this thread.
-- 
View this message in context: http://n4.nabble.com/Derby-not-honoring-order-by-clause-insight-requested-tp1835819p1836051.html
Sent from the OFBiz - Dev mailing list archive at Nabble.com.