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?


{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}

asked 2008-12-17 10:05:25 -0500

sabag2's avatar

updated 2013-08-08 09:52:00 -0500

jaissefsfex's avatar
edit retag flag offensive close merge delete