Comven commented on issue #13544:
URL:
https://github.com/apache/shardingsphere/issues/13544#issuecomment-981360335
Oh, I don't know why this problem is like this. When I test locally, the
results are always like this
```
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.lang.NullPointerException
### The error may exist in file
[D:\WorkPlace\idea\shardingsphere-jdbc\target\classes\META-INF\mybatis\mapper\OrderInfoDao.xml]
### The error may involve
org.demo.shardingsphere.jdbc.mapper.OrderInfoDao.queryInfo
### The error occurred while handling results
### SQL: select id , order_no, user_id, add_time
from order_info where add_time between ? and ? order by add_time
### Cause: java.lang.NullPointerException
at
org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
~[mybatis-3.5.7.jar:3.5.7]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
~[mybatis-3.5.7.jar:3.5.7]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
~[mybatis-3.5.7.jar:3.5.7]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
~[mybatis-3.5.7.jar:3.5.7]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_181]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_181]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_181]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181]
at
org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
~[mybatis-spring-2.0.6.jar:2.0.6]
... 69 common frames omitted
Caused by: java.lang.NullPointerException: null
at
org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByValue.getOrderValuesCaseSensitiveFromTables(OrderByValue.java:74)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByValue.getOrderValuesCaseSensitive(OrderByValue.java:64)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByValue.<init>(OrderByValue.java:58)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByStreamMergedResult.orderResultSetsToQueue(OrderByStreamMergedResult.java:56)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.merge.dql.orderby.OrderByStreamMergedResult.<init>(OrderByStreamMergedResult.java:50)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.build(ShardingDQLResultMerger.java:85)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.sharding.merge.dql.ShardingDQLResultMerger.merge(ShardingDQLResultMerger.java:63)
~[shardingsphere-sharding-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.merge.MergeEngine.executeMerge(MergeEngine.java:90)
~[shardingsphere-infra-merge-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.infra.merge.MergeEngine.merge(MergeEngine.java:80)
~[shardingsphere-infra-merge-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.mergeQuery(ShardingSpherePreparedStatement.java:393)
~[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
at
org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.getResultSet(ShardingSpherePreparedStatement.java:339)
~[shardingsphere-jdbc-core-5.0.0.jar:5.0.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[na:1.8.0_181]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[na:1.8.0_181]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[na:1.8.0_181]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_181]
at
org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:69)
~[mybatis-3.5.7.jar:3.5.7]
at com.sun.proxy.$Proxy215.getResultSet(Unknown Source) ~[na:na]
at
org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getFirstResultSet(DefaultResultSetHandler.java:238)
~[mybatis-3.5.7.jar:3.5.7]
at
org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:188)
~[mybatis-3.5.7.jar:3.5.7]
at
org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
~[mybatis-3.5.7.jar:3.5.7]
at
org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
~[mybatis-3.5.7.jar:3.5.7]
at
org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
~[mybatis-3.5.7.jar:3.5.7]
at
org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
~[mybatis-3.5.7.jar:3.5.7]
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
~[mybatis-3.5.7.jar:3.5.7]
at
org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
~[mybatis-3.5.7.jar:3.5.7]
at
com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:132)
~[pagehelper-5.3.0.jar:na]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
~[mybatis-3.5.7.jar:3.5.7]
at com.sun.proxy.$Proxy214.query(Unknown Source) ~[na:na]
at
org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
~[mybatis-3.5.7.jar:3.5.7]
```
Maybe it's not typical. I'm looking at it myself again. thank you!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
