SQLQueryException: Failed to execute SQLQuery
I'm getting an SQLQueryException, can you tell me if this is correct?
SQLQuery<messageentry> query = new SQLQuery<messageentry>(MessageEntry.class, "timestamp >= ? AND timestamp <= ?"); query.setParameter(1, minTimestamp); query.setParameter(2, maxTimestamp); gigaSpaceClustered.takeMultiple(query);
where MessageEntry has a field Long timestamp (with getTimestamp() and setTimestamp() methods)
StackTrace: com.j_spaces.core.client.sql.SQLQueryException: Failed to execute SQLQuery : [timestamp >= ? AND timestamp <= ?] at com.j_spaces.core.client.sql.QueryManager.readTake(QueryManager.java:187) at com.j_spaces.core.client.sql.QueryManager.readTakeMultiple(QueryManager.java:148) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.newReadTakeMultiple(SpaceProxyImplReadTakeMultipleAction.java:85) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.takeMultiple(SpaceProxyImplReadTakeMultipleAction.java:58) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.takeMultiple(SpaceProxyImplReadTakeMultipleAction.java:26) at com.gigaspaces.internal.client.spaceproxy.actions.AbstractSpaceProxyActionManager.takeMultiple(AbstractSpaceProxyActionManager.java:400) at com.gigaspaces.internal.client.spaceproxy.AbstractSpaceProxy.takeMultiple(AbstractSpaceProxy.java:357) at org.openspaces.core.DefaultGigaSpace.takeMultiple(DefaultGigaSpace.java:1124) at org.openspaces.core.DefaultGigaSpace.takeMultiple(DefaultGigaSpace.java:1118)
Caused by: java.sql.SQLException: Error in statement [timestamp >= ? AND timestamp <= ?]; Cause: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "timestamp" "timestamp "" at line 1, column 1. Was expecting one of: <EOF> "rownum" ... <IDENTIFIER> ... <ESC_IDENTIFIER> ... ";" ... "(" ...
at com.j_spaces.core.client.sql.SqlQueryParser.parseSqlQuery(SqlQueryParser.java:103)
at com.j_spaces.core.client.sql.QueryManager.readTake(QueryManager.java:165)
... 33 more
Caused by: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "timestamp" "timestamp "" at line 1, column 1. Was expecting one of: <EOF> "rownum" ... <IDENTIFIER> ... <ESC_IDENTIFIER> ... ";" ... "(" ...
at com.j_spaces.jdbc.parser.grammar.SqlParser.generateParseException(SqlParser.java:3911)
at com.j_spaces.jdbc.parser.grammar.SqlParser.jj_consume_token(SqlParser.java:3787)
at com.j_spaces.jdbc.parser.grammar.SqlParser.deleteSqlQuery(SqlParser.java:312)
at com.j_spaces.core.client.sql.TakeQueryParser.parse(TakeQueryParser.java:31)
at com.j_spaces.core.client.sql.SqlQueryParser.parseSqlQuery(SqlQueryParser.java:66)
... 34 more
]; nested exception is com.gigaspaces.client.TakeMultipleException: Success:0, errors:1, [class com.j_spaces.core.client.sql.SQLQueryException:1
Hi,
What version are you using?
GigaSpaces XAP: Edition: XAP Premium 9.7.0 GA Build: 10551-9