order by in sqlquery without where

edit

Hi, this code throws exception: class MyClass { String myId; }

SQLQuery<myclass> query = new SQLQuery<myclass>(MyClass.class, "ORDER BY myId ASC"); Object[] classes = ijSpace.readMultiple(query, null, Integer.MAX_VALUE);

the exception is: Error in statement [select * from com.mycompany.MyClass where ORDER BY myId ASC]

how can I make the query work?

Avi.

{quote}This thread was imported from the previous forum. For your reference, the original is [available here|http://forum.openspaces.org/thread.jspa?threadID=2772]{quote}