Eddie,

  I just tested it . . .

MyTestHome.java __________

  public interface MyTestHome {
 
    ....
    public Collection findAll () ...

  }

mytest.jsp__________

  ....

  <%= myTestHome.findall ().getClass () %>

output_____________

  java.util.ArrayList

peace - scot

> Eddie wrote:
> 
> Hellu there,
> 
> Some time ago someone made a remark that it make no sense putting a
> "ORDER
> BY" in the where clause in the orion-ejb-jar.xml, as the finder
> methods of
> the home interface do return a Collection, which are not sorted by
> definition.
> 
> Hmmm makes sence, but if I play around with it and put a "ORDER BY id
> ASC"
> or "ORDER BY id DESC" in the where clause in the orion-ejb-jar.xml, to
> fine
> tune some queries, it does  return sorted collections !!!!
> 
> Howcome ?? Does the finder methods return a  sorted List as a J2EE
> feature,
> that is a subClass of a Collection, or is this just Orion. ??
> 
> The thing is that I like to optimize my queries, but if this feature
> isn't
> J2EE for example I will have a problem with the following upgrades if
> it's
> left out for some reason !!
> 
> BTW: in the J2EE spec, in section 10.5.6 they only talk about the
> Collection
> data type.!!
> 
> Some advise please ??
> Eddie

-- 

  scot weber - [EMAIL PROTECTED]
  -------------
  Given a choice between a folly and a sacrament, one should
  always choose the folly -- because we know a sacrament
  will not bring us closer to God and there's always a chance
  that a folly will. - Erasmus

  The only man who never makes a mistake is the man who
  never does anything. - Theodore Roosevelt.

Reply via email to