SQLQuery: Not Returning Expected Result

edit

String sqlQuery = "Number < ?";
List parms = new ArrayList();
parms.add(Long.valueOf("700"));

SQLQuery sqlQuery = new SQLQuery(Pojo.class, sqlQuery);
sqlQuery.setParameters(parms.toArray());

Object result = space.readMultiple(sqlQuery, Integer.MAX_VALUE);

Hi,

Can you please post your Pojo class source code as well?

"number" is a reserved word in our SQL parser so in your case you should expect a ReadMultipleException with an SQLQueryException as its cause.

If you follow java's naming convention your pojo should look like:

public class MyClass {
        private String uniqueId;
private Long numberValue;

public MyClass() {
}

@SpaceId
        public String getUniqueId() {
            return uniqueId;
        }
        public void setUniqueId(String uniqueId) {
            this.uniqueId = uniqueId;
        }
        public Long getNumberValue() {
            return numberValue;
        }
        public void setNumberValue(Long number) {
            this.numberValue = number;
        }
}

And query:
SQLQuery query = new SQLQuery(MyClass.class, "numberValue < ?");