order by in sqlquery without where
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}