[CM-020301]SQL: select *,? page_id from `gallery` where href = ? ### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77) ~[mybatis-spring-1.3.1.jar:1.3.1] #9
2019-02-03 09:56:57.533 INFO 9044 --- [ main] s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat started on port(s): 8082 (http)
2019-02-03 09:56:57.540 INFO 9044 --- [ main] c.o.springqianbailu.GalleryApplication : Started GalleryApplication in 6.324 seconds (JVM running for 7.019)
2019-02-03 09:57:58.267 INFO 9044 --- [:20881-thread-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Started.
2019-02-03 09:57:58.486 DEBUG 9044 --- [:20881-thread-2] c.o.s.d.g.GalleryMapper.selectByMenuId : ==> Preparing: select id, title,content, href,updateTime,submenuId,pageNo,createDate from gallery where submenuId = ? limit ?,?
2019-02-03 09:57:58.505 DEBUG 9044 --- [:20881-thread-2] c.o.s.d.g.GalleryMapper.selectByMenuId : ==> Parameters: 1(Integer), 0(Integer), 10(Integer)
2019-02-03 09:57:58.522 DEBUG 9044 --- [:20881-thread-2] c.o.s.d.g.GalleryMapper.selectByMenuId : <== Total: 10
2019-02-03 09:59:46.719 DEBUG 9044 --- [:20881-thread-3] c.o.s.d.g.GalleryMapper.selectByHref : ==> Preparing: select *,? page_id from gallery where href = ?
2019-02-03 09:59:46.720 DEBUG 9044 --- [:20881-thread-3] c.o.s.d.g.GalleryMapper.selectByHref : ==> Parameters: 1(String), /tttppp/1002499.html(String)
2019-02-03 09:59:46.724 ERROR 9044 --- [:20881-thread-3] c.a.dubbo.rpc.filter.ExceptionFilter : [DUBBO] Got unchecked and undeclared exception which called by 192.168.12.163. service: com.open.springqianbailu.service.gallery.GalleryImageService, method: selectImage, exception: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
The error may exist in file [/Users/guangjing.feng/github/springqianbailu/spring-boot-dubbo-gallery/target/classes/mybatis-mappers/GalleryMapper.xml]
The error may involve com.open.springqianbailu.dao.gallery.GalleryMapper.selectByHref
The error occurred while handling results
SQL: select *,? page_id from gallery where href = ?
Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById, dubbo version: 2.5.3, current host: 192.168.12.163
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
The error may exist in file [/Users/guangjing.feng/github/springqianbailu/spring-boot-dubbo-gallery/target/classes/mybatis-mappers/GalleryMapper.xml]
The error may involve com.open.springqianbailu.dao.gallery.GalleryMapper.selectByHref
The error occurred while handling results
SQL: select *,? page_id from gallery where href = ?
Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77) ~[mybatis-spring-1.3.1.jar:1.3.1]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) ~[mybatis-spring-1.3.1.jar:1.3.1]
at com.sun.proxy.$Proxy73.selectList(Unknown Source) ~[na:na]
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) ~[mybatis-spring-1.3.1.jar:1.3.1]
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) ~[mybatis-3.4.5.jar:3.4.5]
at com.sun.proxy.$Proxy76.selectByHref(Unknown Source) ~[na:na]
at com.open.springqianbailu.service.impl.gallery.GalleryImageServiceImpl.selectImage(GalleryImageServiceImpl.java:47) ~[classes/:na]
at com.alibaba.dubbo.common.bytecode.Wrapper1.invokeMethod(Wrapper1.java) ~[na:2.5.3]
at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46) ~[dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72) ~[dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53) ~[dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64) ~[dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:112) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:108) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52) [dubbo-2.5.3.jar:2.5.3]
at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82) [dubbo-2.5.3.jar:2.5.3]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_152]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_152]
Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
The error may exist in file [/Users/guangjing.feng/github/springqianbailu/spring-boot-dubbo-gallery/target/classes/mybatis-mappers/GalleryMapper.xml]
The error may involve com.open.springqianbailu.dao.gallery.GalleryMapper.selectByHref
The error occurred while handling results
SQL: select *,? page_id from gallery where href = ?
Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.5.jar:3.4.5]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_152]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_152]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_152]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_152]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-1.3.1.jar:1.3.1]
... 35 common frames omitted
Caused by: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:888) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:721) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:714) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getNestedQueryMappingValue(DefaultResultSetHandler.java:751) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:460) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:436) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:399) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:351) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:326) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:299) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:192) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.5.jar:3.4.5]
... 41 common frames omitted
guangjingfenggmail
commented
5 years ago 
2019-02-03 09:56:57.533 INFO 9044 --- [ main] s.b.c.e.t.TomcatEmbeddedServletContainer : Tomcat started on port(s): 8082 (http) 2019-02-03 09:56:57.540 INFO 9044 --- [ main] c.o.springqianbailu.GalleryApplication : Started GalleryApplication in 6.324 seconds (JVM running for 7.019) 2019-02-03 09:57:58.267 INFO 9044 --- [:20881-thread-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Started. 2019-02-03 09:57:58.486 DEBUG 9044 --- [:20881-thread-2] c.o.s.d.g.GalleryMapper.selectByMenuId : ==> Preparing: select id, title,content, href,updateTime,submenuId,pageNo,createDate from gallery where submenuId = ? limit ?,? 2019-02-03 09:57:58.505 DEBUG 9044 --- [:20881-thread-2] c.o.s.d.g.GalleryMapper.selectByMenuId : ==> Parameters: 1(Integer), 0(Integer), 10(Integer) 2019-02-03 09:57:58.522 DEBUG 9044 --- [:20881-thread-2] c.o.s.d.g.GalleryMapper.selectByMenuId : <== Total: 10 2019-02-03 09:59:46.719 DEBUG 9044 --- [:20881-thread-3] c.o.s.d.g.GalleryMapper.selectByHref : ==> Preparing: select *,? page_id from
gallerywhere href = ? 2019-02-03 09:59:46.720 DEBUG 9044 --- [:20881-thread-3] c.o.s.d.g.GalleryMapper.selectByHref : ==> Parameters: 1(String), /tttppp/1002499.html(String) 2019-02-03 09:59:46.724 ERROR 9044 --- [:20881-thread-3] c.a.dubbo.rpc.filter.ExceptionFilter : [DUBBO] Got unchecked and undeclared exception which called by 192.168.12.163. service: com.open.springqianbailu.service.gallery.GalleryImageService, method: selectImage, exception: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
The error may exist in file [/Users/guangjing.feng/github/springqianbailu/spring-boot-dubbo-gallery/target/classes/mybatis-mappers/GalleryMapper.xml]
The error may involve com.open.springqianbailu.dao.gallery.GalleryMapper.selectByHref
The error occurred while handling results
SQL: select *,? page_id from
gallerywhere href = ?Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById, dubbo version: 2.5.3, current host: 192.168.12.163
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
The error may exist in file [/Users/guangjing.feng/github/springqianbailu/spring-boot-dubbo-gallery/target/classes/mybatis-mappers/GalleryMapper.xml]
The error may involve com.open.springqianbailu.dao.gallery.GalleryMapper.selectByHref
The error occurred while handling results
SQL: select *,? page_id from
gallerywhere href = ?Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
Caused by: org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
The error may exist in file [/Users/guangjing.feng/github/springqianbailu/spring-boot-dubbo-gallery/target/classes/mybatis-mappers/GalleryMapper.xml]
The error may involve com.open.springqianbailu.dao.gallery.GalleryMapper.selectByHref
The error occurred while handling results
SQL: select *,? page_id from
gallerywhere href = ?Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById
Caused by: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.open.com.open.springqianbailu.dao.gallery.GalleryImageMapper.selectById at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:888) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:721) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:714) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getNestedQueryMappingValue(DefaultResultSetHandler.java:751) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:460) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:436) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:399) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:351) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:326) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:299) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:192) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.5.jar:3.4.5] ... 41 common frames omitted