Mybatis错误符号_was expecting one of:-CSDN博客

本文记录了学习期间遇到的Java使用MyBatis时的错误。错误为查询数据库时，OGNL表达式 'userRole! =0' 语法错误，给出了详细的错误堆栈信息，方便后续碰到类似问题时快速定位解决。

作为学习期间的错误总结，同时也方便以后碰到类似问题不会找很久特此记录下来

Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.apache.ibatis.builder.BuilderException: Error evaluating expression 'userRole ! =0'. Cause: org.apache.ibatis.ognl.ExpressionSyntaxException: Malformed OGNL expression: userRole ! =0 [org.apache.ibatis.ognl.ParseException: Encountered " "!" "! "" at line 1, column 10.
Was expecting one of:
<EOF>
"," ...
"=" ...
"?" ...
"||" ...
"or" ...
"&&" ...
"and" ...
"|" ...
"bor" ...
"^" ...
"xor" ...
"&" ...
"band" ...
"==" ...
"eq" ...
"!=" ...
"neq" ...
"<" ...
"lt" ...
">" ...
"gt" ...
"<=" ...
"lte" ...
">=" ...
"gte" ...
"in" ...
"not" ...
"<<" ...
"shl" ...
">>" ...
"shr" ...
">>>" ...
"ushr" ...
"+" ...
"-" ...
"*" ...
"/" ...
"%" ...
"instanceof" ...
"." ...
"(" ...
"[" ...
<DYNAMIC_SUBSCRIPT> ...
"(" ...
]
### Cause: org.apache.ibatis.builder.BuilderException: Error evaluating expression 'userRole ! =0'. Cause: org.apache.ibatis.ognl.ExpressionSyntaxException: Malformed OGNL expression: userRole ! =0 [org.apache.ibatis.ognl.ParseException: Encountered " "!" "! "" at line 1, column 10.
Was expecting one of:
<EOF>
"," ...
"=" ...
"?" ...
"||" ...
"or" ...
"&&" ...
"and" ...
"|" ...
"bor" ...
"^" ...
"xor" ...
"&" ...
"band" ...
"==" ...
"eq" ...
"!=" ...
"neq" ...
"<" ...
"lt" ...
">" ...
"gt" ...
"<=" ...
"lte" ...
">=" ...
"gte" ...
"in" ...
"not" ...
"<<" ...
"shl" ...
">>" ...
"shr" ...
">>>" ...
"ushr" ...
"+" ...
"-" ...
"*" ...
"/" ...
"%" ...
"instanceof" ...
"." ...
"(" ...
"[" ...
<DYNAMIC_SUBSCRIPT> ...
"(" ...
]
   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
   at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
   at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
   at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)
   at com.sun.proxy.$Proxy4.getSMUser(Unknown Source)
   at com.bdqn.DynamicTest.main(DynamicTest.java:17)
Caused by: org.apache.ibatis.builder.BuilderException: Error evaluating expression 'userRole ! =0'. Cause: org.apache.ibatis.ognl.ExpressionSyntaxException: Malformed OGNL expression: userRole ! =0 [org.apache.ibatis.ognl.ParseException: Encountered " "!" "! "" at line 1, column 10.
Was expecting one of:
<EOF>
"," ...
"=" ...
"?" ...
"||" ...
"or" ...
"&&" ...
"and" ...
"|" ...
"bor" ...
"^" ...
"xor" ...
"&" ...
"band" ...
"==" ...
"eq" ...
"!=" ...
"neq" ...
"<" ...
"lt" ...
">" ...
"gt" ...
"<=" ...
"lte" ...
">=" ...
"gte" ...
"in" ...
"not" ...
"<<" ...
"shl" ...
">>" ...
"shr" ...
">>>" ...
"ushr" ...
"+" ...
"-" ...
"*" ...
"/" ...
"%" ...
"instanceof" ...
"." ...
"(" ...
"[" ...
<DYNAMIC_SUBSCRIPT> ...
"(" ...
]
   at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:48)
   at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
   at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
   at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
   at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
   at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
   at org.apache.ibatis.scripting.xmltags.TrimSqlNode.apply(TrimSqlNode.java:55)
   at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
   at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
   at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
   at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)
   at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:297)
   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
   ... 6 more
Caused by: org.apache.ibatis.ognl.ExpressionSyntaxException: Malformed OGNL expression: userRole ! =0 [org.apache.ibatis.ognl.ParseException: Encountered " "!" "! "" at line 1, column 10.
Was expecting one of:
<EOF>
"," ...
"=" ...
"?" ...
"||" ...
"or" ...
"&&" ...
"and" ...
"|" ...
"bor" ...
"^" ...
"xor" ...
"&" ...
"band" ...
"==" ...
"eq" ...
"!=" ...
"neq" ...
"<" ...
"lt" ...
">" ...
"gt" ...
"<=" ...
"lte" ...
">=" ...
"gte" ...
"in" ...
"not" ...
"<<" ...
"shl" ...
">>" ...
"shr" ...
">>>" ...
"ushr" ...
"+" ...
"-" ...
"*" ...
"/" ...
"%" ...
"instanceof" ...
"." ...
"(" ...
"[" ...
<DYNAMIC_SUBSCRIPT> ...
"(" ...
]
   at org.apache.ibatis.ognl.Ognl.parseExpression(Ognl.java:112)
   at org.apache.ibatis.scripting.xmltags.OgnlCache.parseExpression(OgnlCache.java:55)
   at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)
   ... 19 more
Caused by: org.apache.ibatis.ognl.ParseException: Encountered " "!" "! "" at line 1, column 10.
Was expecting one of:
<EOF>
"," ...
"=" ...
"?" ...
"||" ...
"or" ...
"&&" ...
"and" ...
"|" ...
"bor" ...
"^" ...
"xor" ...
"&" ...
"band" ...
"==" ...
"eq" ...
"!=" ...
"neq" ...
"<" ...
"lt" ...
">" ...
"gt" ...
"<=" ...
"lte" ...
">=" ...
"gte" ...
"in" ...
"not" ...
"<<" ...
"shl" ...
">>" ...
"shr" ...
">>>" ...
"ushr" ...
"+" ...
"-" ...
"*" ...
"/" ...
"%" ...
"instanceof" ...
"." ...
"(" ...
"[" ...
<DYNAMIC_SUBSCRIPT> ...
"(" ...

   at org.apache.ibatis.ognl.OgnlParser.generateParseException(OgnlParser.java:3172)
   at org.apache.ibatis.ognl.OgnlParser.jj_consume_token(OgnlParser.java:3051)
   at org.apache.ibatis.ognl.OgnlParser.topLevelExpression(OgnlParser.java:16)
   at org.apache.ibatis.ognl.Ognl.parseExpression(Ognl.java:110)
   ... 21 more