hi douglas,
you have to add either 'asc' or 'desc' to make it work.
i do not know wether really OQL requires asc or desc ???
jakob
----- Original Message -----
From: "Douglas Montanus" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 5:38 PM
Subject: Order By ??????????
> 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
>
>
--
To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
