"C:\Program Files\Java\jdk1.8.0_121\bin\java" -Dnet.jini.discovery.LookupLocatorDiscovery=FINE "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.3.2\lib\idea_rt.jar=61507:C:\Program Files\JetBrains\IntelliJ IDEA Community Edition 2017.3.2\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program Files\Java\jdk1.8.0_121\jre\lib\charsets.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\deploy.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\access-bridge-64.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\cldrdata.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\dnsns.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\jaccess.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\jfxrt.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\localedata.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\nashorn.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\sunec.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\sunjce_provider.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\sunmscapi.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\sunpkcs11.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\ext\zipfs.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\javaws.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\jce.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\jfr.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\jfxswt.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\jsse.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\management-agent.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\plugin.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\resources.jar;C:\Program Files\Java\jdk1.8.0_121\jre\lib\rt.jar;C:\Users\Dixson\IdeaProjects\SimpleClient\out\production\SimpleClient;C:\Users\Dixson\IdeaProjects\SimpleClient\out\production\RemoteModel;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\xap-asm.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\xap-trove.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\xap-common.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\xap-datagrid.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\xap-openspaces.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\xap-premium-common.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\commons-logging-1.1.3.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\spring-tx-4.1.1.RELEASE.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\spring-aop-4.1.1.RELEASE.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\spring-core-4.1.1.RELEASE.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\spring-beans-4.1.1.RELEASE.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\spring-aspects-4.1.1.RELEASE.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\spring-context-4.1.1.RELEASE.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\spring-expression-4.1.1.RELEASE.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\spring-context-support-4.1.1.RELEASE.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\required\com.springsource.org.aopalliance-1.0.0.jar;C:\Users\Dixson\.m2\repository\javax\persistence\persistence-api\1.0.2\persistence-api-1.0.2.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\optional\near-cache\xap-near-cache.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\optional\near-cache\xap-near-cache-spring.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\optional\map\xap-map.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\optional\map\xap-map-spring.jar;C:\Users\Dixson\.m2\repository\javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\platform\logger\slf4j-api-1.6.1.jar;C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\lib\platform\logger\slf4j-jdk14-1.7.12.jar;C:\Users\Dixson\.m2\repository\org\hsqldb\hsqldb\2.3.2\hsqldb-2.3.2.jar" com.samples.proxy.Main 2018-05-01 15:25:57,848 CONFIG [com.gigaspaces.logger] - Log file: C:\Users\Dixson\work\xap\gigaspaces-insightedge-12.2.1-ga-b18100\logs\2018-05-01~15.25-gigaspaces-service-192.168.56.1-14524.log 2018-05-01 15:25:57,839 INFO [net.jini.discovery.LookupLocatorDiscovery] - Connected to LUS using locator 10.10.10.117:4174 org.openspaces.core.ReadMultipleException: Success:0, errors:1, [class com.j_spaces.core.client.sql.SQLQueryException:1 StackTrace: com.j_spaces.core.client.sql.SQLQueryException: Failed to execute SQLQuery : [item[*].message is not null] cause: java.sql.SQLException: Error in statement [item[*].message is not null]; Cause: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "is" "is "" at line 1, column 17. Was expecting one of: "between" ... "in" ... "like" ... "not" ... "." ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "!=" ... "<>" ... "(" ... "[*]" ... at com.j_spaces.core.client.sql.QueryManager.readTake(QueryManager.java:177) at com.j_spaces.core.client.sql.QueryManager.readTakeMultiple(QueryManager.java:143) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.newReadTakeMultiple(SpaceProxyImplReadTakeMultipleAction.java:83) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.readMultiple(SpaceProxyImplReadTakeMultipleAction.java:44) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.readMultiple(SpaceProxyImplReadTakeMultipleAction.java:36) at com.gigaspaces.internal.client.spaceproxy.actions.AbstractSpaceProxyActionManager.readMultiple(AbstractSpaceProxyActionManager.java:225) at com.gigaspaces.internal.client.spaceproxy.AbstractSpaceProxy.readMultiple(AbstractSpaceProxy.java:280) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:680) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:674) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:670) at com.samples.proxy.Main.reader(Main.java:73) at com.samples.proxy.Main.main(Main.java:115) Caused by: java.sql.SQLException: Error in statement [item[*].message is not null]; Cause: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "is" "is "" at line 1, column 17. Was expecting one of: "between" ... "in" ... "like" ... "not" ... "." ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "!=" ... "<>" ... "(" ... "[*]" ... at com.j_spaces.core.client.sql.SqlQueryParser.parseSqlQuery(SqlQueryParser.java:100) at com.j_spaces.core.client.sql.QueryManager.readTake(QueryManager.java:159) ... 11 more Caused by: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "is" "is "" at line 1, column 17. Was expecting one of: "between" ... "in" ... "like" ... "not" ... "." ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "!=" ... "<>" ... "(" ... "[*]" ... at com.j_spaces.jdbc.parser.grammar.SqlParser.generateParseException(SqlParser.java:4967) at com.j_spaces.jdbc.parser.grammar.SqlParser.jj_consume_token(SqlParser.java:4829) at com.j_spaces.jdbc.parser.grammar.SqlParser.containsNode(SqlParser.java:3140) at com.j_spaces.jdbc.parser.grammar.SqlParser.condition(SqlParser.java:2500) at com.j_spaces.jdbc.parser.grammar.SqlParser.SqlSimpleExpression(SqlParser.java:1897) at com.j_spaces.jdbc.parser.grammar.SqlParser.SqlAndExpression(SqlParser.java:1870) at com.j_spaces.jdbc.parser.grammar.SqlParser.SqlExpression(SqlParser.java:1846) at com.j_spaces.jdbc.parser.grammar.SqlParser.selectSqlQuery(SqlParser.java:272) at com.j_spaces.jdbc.parser.grammar.SqlParser.readMultipleQuery(SqlParser.java:242) at com.j_spaces.core.client.sql.ReadQueryParser.parse(ReadQueryParser.java:39) at com.j_spaces.core.client.sql.SqlQueryParser.parseSqlQuery(SqlQueryParser.java:71) ... 12 more ]; nested exception is com.gigaspaces.client.ReadMultipleException: Success:0, errors:1, [class com.j_spaces.core.client.sql.SQLQueryException:1 StackTrace: com.j_spaces.core.client.sql.SQLQueryException: Failed to execute SQLQuery : [item[*].message is not null] cause: java.sql.SQLException: Error in statement [item[*].message is not null]; Cause: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "is" "is "" at line 1, column 17. Was expecting one of: "between" ... "in" ... "like" ... "not" ... "." ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "!=" ... "<>" ... "(" ... "[*]" ... at com.j_spaces.core.client.sql.QueryManager.readTake(QueryManager.java:177) at com.j_spaces.core.client.sql.QueryManager.readTakeMultiple(QueryManager.java:143) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.newReadTakeMultiple(SpaceProxyImplReadTakeMultipleAction.java:83) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.readMultiple(SpaceProxyImplReadTakeMultipleAction.java:44) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.readMultiple(SpaceProxyImplReadTakeMultipleAction.java:36) at com.gigaspaces.internal.client.spaceproxy.actions.AbstractSpaceProxyActionManager.readMultiple(AbstractSpaceProxyActionManager.java:225) at com.gigaspaces.internal.client.spaceproxy.AbstractSpaceProxy.readMultiple(AbstractSpaceProxy.java:280) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:680) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:674) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:670) at com.samples.proxy.Main.reader(Main.java:73) at com.samples.proxy.Main.main(Main.java:115) Caused by: java.sql.SQLException: Error in statement [item[*].message is not null]; Cause: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "is" "is "" at line 1, column 17. Was expecting one of: "between" ... "in" ... "like" ... "not" ... "." ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "!=" ... "<>" ... "(" ... "[*]" ... at com.j_spaces.core.client.sql.SqlQueryParser.parseSqlQuery(SqlQueryParser.java:100) at com.j_spaces.core.client.sql.QueryManager.readTake(QueryManager.java:159) ... 11 more Caused by: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "is" "is "" at line 1, column 17. Was expecting one of: "between" ... "in" ... "like" ... "not" ... "." ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "!=" ... "<>" ... "(" ... "[*]" ... at com.j_spaces.jdbc.parser.grammar.SqlParser.generateParseException(SqlParser.java:4967) at com.j_spaces.jdbc.parser.grammar.SqlParser.jj_consume_token(SqlParser.java:4829) at com.j_spaces.jdbc.parser.grammar.SqlParser.containsNode(SqlParser.java:3140) at com.j_spaces.jdbc.parser.grammar.SqlParser.condition(SqlParser.java:2500) at com.j_spaces.jdbc.parser.grammar.SqlParser.SqlSimpleExpression(SqlParser.java:1897) at com.j_spaces.jdbc.parser.grammar.SqlParser.SqlAndExpression(SqlParser.java:1870) at com.j_spaces.jdbc.parser.grammar.SqlParser.SqlExpression(SqlParser.java:1846) at com.j_spaces.jdbc.parser.grammar.SqlParser.selectSqlQuery(SqlParser.java:272) at com.j_spaces.jdbc.parser.grammar.SqlParser.readMultipleQuery(SqlParser.java:242) at com.j_spaces.core.client.sql.ReadQueryParser.parse(ReadQueryParser.java:39) at com.j_spaces.core.client.sql.SqlQueryParser.parseSqlQuery(SqlQueryParser.java:71) ... 12 more ] at org.openspaces.core.exception.DefaultExceptionTranslator.internalTranslate(DefaultExceptionTranslator.java:176) at org.openspaces.core.exception.DefaultExceptionTranslator.translate(DefaultExceptionTranslator.java:86) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:682) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:674) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:670) at com.samples.proxy.Main.reader(Main.java:73) at com.samples.proxy.Main.main(Main.java:115) Caused by: com.gigaspaces.client.ReadMultipleException: Success:0, errors:1, [class com.j_spaces.core.client.sql.SQLQueryException:1 StackTrace: com.j_spaces.core.client.sql.SQLQueryException: Failed to execute SQLQuery : [item[*].message is not null] cause: java.sql.SQLException: Error in statement [item[*].message is not null]; Cause: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "is" "is "" at line 1, column 17. Was expecting one of: "between" ... "in" ... "like" ... "not" ... "." ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "!=" ... "<>" ... "(" ... "[*]" ... at com.j_spaces.core.client.sql.QueryManager.readTake(QueryManager.java:177) at com.j_spaces.core.client.sql.QueryManager.readTakeMultiple(QueryManager.java:143) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.newReadTakeMultiple(SpaceProxyImplReadTakeMultipleAction.java:83) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.readMultiple(SpaceProxyImplReadTakeMultipleAction.java:44) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.readMultiple(SpaceProxyImplReadTakeMultipleAction.java:36) at com.gigaspaces.internal.client.spaceproxy.actions.AbstractSpaceProxyActionManager.readMultiple(AbstractSpaceProxyActionManager.java:225) at com.gigaspaces.internal.client.spaceproxy.AbstractSpaceProxy.readMultiple(AbstractSpaceProxy.java:280) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:680) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:674) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:670) at com.samples.proxy.Main.reader(Main.java:73) at com.samples.proxy.Main.main(Main.java:115) Caused by: java.sql.SQLException: Error in statement [item[*].message is not null]; Cause: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "is" "is "" at line 1, column 17. Was expecting one of: "between" ... "in" ... "like" ... "not" ... "." ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "!=" ... "<>" ... "(" ... "[*]" ... at com.j_spaces.core.client.sql.SqlQueryParser.parseSqlQuery(SqlQueryParser.java:100) at com.j_spaces.core.client.sql.QueryManager.readTake(QueryManager.java:159) ... 11 more Caused by: com.j_spaces.jdbc.parser.grammar.ParseException: Encountered " "is" "is "" at line 1, column 17. Was expecting one of: "between" ... "in" ... "like" ... "not" ... "." ... "<" ... "<=" ... ">" ... ">=" ... "=" ... "!=" ... "<>" ... "(" ... "[*]" ... at com.j_spaces.jdbc.parser.grammar.SqlParser.generateParseException(SqlParser.java:4967) at com.j_spaces.jdbc.parser.grammar.SqlParser.jj_consume_token(SqlParser.java:4829) at com.j_spaces.jdbc.parser.grammar.SqlParser.containsNode(SqlParser.java:3140) at com.j_spaces.jdbc.parser.grammar.SqlParser.condition(SqlParser.java:2500) at com.j_spaces.jdbc.parser.grammar.SqlParser.SqlSimpleExpression(SqlParser.java:1897) at com.j_spaces.jdbc.parser.grammar.SqlParser.SqlAndExpression(SqlParser.java:1870) at com.j_spaces.jdbc.parser.grammar.SqlParser.SqlExpression(SqlParser.java:1846) at com.j_spaces.jdbc.parser.grammar.SqlParser.selectSqlQuery(SqlParser.java:272) at com.j_spaces.jdbc.parser.grammar.SqlParser.readMultipleQuery(SqlParser.java:242) at com.j_spaces.core.client.sql.ReadQueryParser.parse(ReadQueryParser.java:39) at com.j_spaces.core.client.sql.SqlQueryParser.parseSqlQuery(SqlQueryParser.java:71) ... 12 more ] at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.readMultiple(SpaceProxyImplReadTakeMultipleAction.java:49) at com.gigaspaces.internal.client.spaceproxy.actions.SpaceProxyImplReadTakeMultipleAction.readMultiple(SpaceProxyImplReadTakeMultipleAction.java:36) at com.gigaspaces.internal.client.spaceproxy.actions.AbstractSpaceProxyActionManager.readMultiple(AbstractSpaceProxyActionManager.java:225) at com.gigaspaces.internal.client.spaceproxy.AbstractSpaceProxy.readMultiple(AbstractSpaceProxy.java:280) at org.openspaces.core.DefaultGigaSpace.readMultiple(DefaultGigaSpace.java:680) ... 4 more Process finished with exit code 0