Order By ??????????

[Douglas Montanus]

  I have a question the ODMG implementation of OQL.  I seem to be having
problems with the ORDER BY clause in my query statement.  It appears to
be ignored.  I have examined the DEBUG log for
org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl.LogLevel=D
EBUG
and my order by clause dose not appear.  Help me.  In need things sorted
badly.  Here is a code sniplet:
 
        tx.begin();
 
          // 2. get an OQLQuery object from the ODMG facade
          OQLQuery query = odmg.newOQLQuery()
 
          // 3. set the OQL select statement
            
          query.create("select allEmployee from "+
Employee.class.getName() + " order by lastname, firstname") ;
 
          // 4. perform the query and store the result in a persistent
Collection
          col = (DList) query.execute();
          tx.commit();
 
 
Douglas