Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor

最新推荐文章于 2025-01-18 14:30:29 发布
原创 最新推荐文章于 2025-01-18 14:30:29 发布 · 2.7k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#java

博客介绍了Java异常的解决办法，即加入空参构造方法，为Java开发中遇到异常问题提供了一种解决方案。
部署运行你感兴趣的模型镜像 
org.springframework.security.authentication.InternalAuthenticationServiceException: nested exception is org.apache.ibatis.executor.ExecutorException: No constructor found in com.ittext.springsecurity.entity.Users matching [java.lang.Long, java.lang.String, java.lang.String]
	at org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:123) ~[spring-security-core-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:144) ~[spring-security-core-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:175) ~[spring-security-core-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:195) ~[spring-security-core-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.attemptAuthentication(UsernamePasswordAuthenticationFilter.java:95) ~[spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:212) ~[spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:92) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:77) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178) [spring-security-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) [spring-web-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1579) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_91]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_91]
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.27.jar:9.0.27]
	at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91]
Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: No constructor found in com.ittext.springsecurity.entity.Users matching [java.lang.Long, java.lang.String, java.lang.String]
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77) ~[mybatis-spring-1.3.2.jar:1.3.2]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) ~[mybatis-spring-1.3.2.jar:1.3.2]
	at com.sun.proxy.$Proxy68.selectOne(Unknown Source) ~[na:na]
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166) ~[mybatis-spring-1.3.2.jar:1.3.2]
	at com.baomidou.mybatisplus.core.override.PageMapperMethod.execute(PageMapperMethod.java:101) ~[mybatis-plus-core-3.0.5.jar:na]
	at com.baomidou.mybatisplus.core.override.PageMapperProxy.invoke(PageMapperProxy.java:64) ~[mybatis-plus-core-3.0.5.jar:na]
	at com.sun.proxy.$Proxy70.selectOne(Unknown Source) ~[na:na]
	at com.ittext.springsecurity.service.MyUserDetailsService.loadUserByUsername(MyUserDetailsService.java:36) ~[classes/:na]
	at org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:108) ~[spring-security-core-5.2.1.RELEASE.jar:5.2.1.RELEASE]
	... 51 common frames omitted
Caused by: org.apache.ibatis.executor.ExecutorException: No constructor found in com.ittext.springsecurity.entity.Users matching [java.lang.Long, java.lang.String, java.lang.String]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createByConstructorSignature(DefaultResultSetHandler.java:668) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject(DefaultResultSetHandler.java:621) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject(DefaultResultSetHandler.java:594) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:396) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:355) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:330) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:303) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:196) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.6.jar:3.4.6]
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) ~[mybatis-3.4.6.jar:3.4.6]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_91]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_91]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_91]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_91]
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-1.3.2.jar:1.3.2]
	... 58 common frames omitted

异常解决办法,加入空参构造方法

您可能感兴趣的与本文相关的镜像

Yolo-v8.3

Yolo-v8.3

Yolo

YOLO（You Only Look Once）是一种流行的物体检测和图像分割模型，由华盛顿大学的Joseph Redmon 和Ali Farhadi 开发。 YOLO 于2015 年推出，因其高速和高精度而广受欢迎

陈漂流
关注
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorEx
DN金猿的博客
09-08 1000
属性，这个属性会返回自动生成的ID设置到参数中，如果参数中没有。方案二：如果需要返回ID值，在传的参数中加上。的参数封装成实体，包含这几个字段。方案一：如果不需要返回ID值，就把。插入数据时mybatis报错。插入数据传的参数中没有。
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.Reflecti
DN金猿的博客
09-08 235
dao层查询mybatis报错。
解决：Jackson反序列化Java内部类失败（序列化后的识别码为LinkedHashMap，而非内部类本身）
yokoのBlog
03-06 8900
问题描述 先看实体类： import com.fasterxml.jackson.annotation.*; import lombok.Data; import org.jeecg.common.system.base.entity.JeecgEntity; import org.jeecg.modules.iot.entity.jackson.WorkerConverter; import org.jeecg.modules.iot.entity.jackson.WorkersDeserializer;
完美解决org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.Refl
m0_55927959的博客
06-19 1万+
完美解决org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.Refl
Caused by: com.fasterxml.jackson.databind.exc.InvalidTypeIdException: Could not resolve type id ‘sys
m0_62943934的博客
07-25 1597
完整异常：Caused by: com.fasterxml.jackson.databind.exc.InvalidTypeIdException: Could not resolve type id ‘sys:role:add’ as a subtype of : no such class found at [Source: (byte[])“[“sys:role:add”,“sys:permission:delete”,“sys:log:list”,“sys:log:delete”,“sys:perm
Springboot报错
日拱一卒,功不唐捐
08-18 4190
com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature
com.fasterxml.jackson.databind.exc.InvalidDefinitionException
热门推荐
嘻嘻呵呵的博客
06-09 1万+
com.fasterxml.jackson.databind.exc.InvalidDefinitionException
完美解决org.mybatis.spring.MyBatisSystemException nested exception is org.apache.ibatis.reflection.Refl
m0_74825093的博客
01-18 943
确认文件中的配置正确无误。确保MapperXML文件中的SQL语句和映射关系正确。确认实体类的字段和数据库表的列名一致。确认数据库连接配置正确，确保能够成功连接到数据库。确认使用的MyBatis版本与项目的其他依赖版本兼容。通过以上步骤，可以有效解决相关的错误，确保MyBatis在项目中正确使用。如果问题依旧存在，请进一步检查配置文件和依赖版本。以上内容仅供参考，具体问题具体分析，如果对你没有帮助，深感抱歉。
记录一些遇见的bug——项目启动报错org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.e
weixin_56039103的博客
09-17 4946
报错截图： 错误代码： 二、问题原因 虽然看起来是一个空指针异常，但真正的原因在第二张报错截图上：也就是如下内容： 因为数据库表中有个字段名叫desc,如图所示： desc是MySQL语法中的关键字，mybatis plus自动生成的sql中因为这个关键字的影响，就造成了语法错误。方案1：更换字段名为非MySQL关键字即可。 例如此处我把字段名改成describer，同时更改Java中的实体类属性名。 clean之后再次运行，项目顺利启动不再报错。 方案2：不使用mybatis plus ，更换成
Mybatis报错: org.apache.ibatis.exceptions.PersistenceException解决办法
09-09
在使用Mybatis框架时，你可能会遇到`org.apache.ibatis.exceptions.PersistenceException`这样的异常。这个异常通常表示在执行数据库查询操作时遇到了问题。本篇将详细分析这个问题并提供解决方法。 ### 问题概述 ...
com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class
qq_45593903的博客
12-02 2727
使用SpringMVC和mybatis响应JSON格式的数据时发生错误：响应状态码500 原因：mybatis配置文件或者mapper文件中使用了懒加载 解决方案一：关闭mybatis配置文件中或者mapper文件中配置的懒加载 将两者一起关闭，或者将mapper文件中的fetchType属性修改为eager 解决方案二： 在关联查询的相关bean上添加注解@JsonIgnoreProperties("handler") 原理应该是开启懒加载后导致Employee对象的数据不完整，...
【异常】com.fasterxml.jackson.databind.exc.InvalidDefinitionException
imagination-kids的博客
09-26 3960
描述 今天在利用mapper.writeValueAsString 时出现了如下异常 异常 com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class com.work.recycle.component.MyToken and no properties discovered to create BeanSerializer (to avoid exception, disa
com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class tonels.
诗和远方，任重道远
06-09 1833
错误解决记录 在使用fasterxml jackson 做对象的序列化的时候，出现如下错误 com.fasterxml.jackson.databind.exc.InvalidDefinitionException: No serializer found for class tonels.feature.domain.P3 and no properties discovered to create BeanSerializer (to avoid exception, disable Serializa
Spring boot : com.fasterxml.jackson.databind.exc.InvalidDefinitionException
张小凡
08-29 2923
spring-boot-starter-web 这个架包已经包含了所有的jackson依赖，去掉pom中的: <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-annotati...
java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.sjsemi.quartz.util.JobInvokeUtil.invokeMethod(JobInvokeUtil.java:61) at com.sjsemi.quartz.util.JobInvokeUtil.invokeMethod(JobInvokeUtil.java:33) at com.sjsemi.quartz.util.QuartzDisallowConcurrentExecution.doExecute(QuartzDisallowConcurrentExecution.java:19) at com.sjsemi.quartz.util.AbstractQuartzJob.execute(AbstractQuartzJob.java:44) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) Caused by: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.sjsemi.activiti.mapper.SysIncomingRecordMapper.selectcountbybatch'. It's likely that neither a Result Type nor a Result Map was specified. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy100.selectOne(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:90) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy182.selectcountbybatch(Unknown Source) at com.sjsemi.activiti.service.impl.SysIncomingRecordServiceImpl.allocateBatchId(SysIncomingRecordServiceImpl.java:289) at com.sjsemi.activiti.service.impl.SysIncomingRecordServiceImpl.importIncomingRecord(SysIncomingRecordServiceImpl.java:235) at com.sjsemi.activiti.service.impl.SysIncomingRecordServiceImpl.downIQADataFromMes(SysIncomingRecordServiceImpl.java:687) at com.sjsemi.activiti.service.impl.SysIncomingRecordServiceImpl$$FastClassBySpringCGLIB$$460d5fb3.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386) at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704) at com.sjsemi.activiti.service.impl.SysIncomingRecordServiceImpl$$EnhancerBySpringCGLIB$$866a2229.downIQADataFromMes(<generated>) at com.sjsemi.quartz.task.RyTask.downIQADataFromMes(RyTask.java:62) ... 10 more Caused by: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.sjsemi.activiti.mapper.SysIncomingRecordMapper.selectcountbybatch'. It's likely that neither a Result Type nor a Result Map was specified. at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.validateResultMapsCount(DefaultResultSetHandler.java:290) at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:192) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at com.sun.proxy.$Proxy114.query(Unknown Source) at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:69) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:165) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy113.query(Unknown Source) at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:132) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy113.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 26 more这个报错是什么意思
最新发布
10-29
这个报错信息的核心问题是： ``` Caused by: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.sjsemi.activiti.mapper.SysIncomingRecordMapper.selectcountbybatch'. It's likely that neither a Result Type nor a Result Map was specified. ``` --- ### ✅ 错误解释 这是 **MyBatis** 报出的异常，说明你在执行一个名为 `selectcountbybatch` 的查询语句时，**没有指定返回结果的类型（resultType 或 resultMap）**。 换句话说：**你写了一个 SQL 查询，但 MyBatis 不知道如何把数据库的结果映射成 Java 对象。** --- ### 🔍 详细分析堆栈 - 根本原因： ```java Caused by: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found ... ``` 表明在解析 `MappedStatement` 时，找不到对应的 `resultMap` 或 `resultType`。 - 出问题的方法是： ``` com.sjsemi.activiti.mapper.SysIncomingRecordMapper.selectcountbybatch ``` - 这个方法可能是用来统计数量的，比如： ```java int selectCountByBatch(@Param("batchId") String batchId); ``` 但是它的 XML 配置或注解中**缺少了 resultType 属性**。 --- ## ✅ 解决方案 你需要检查 `SysIncomingRecordMapper.xml` 文件中是否定义了如下类似的内容： ```xml <select id="selectcountbybatch" parameterType="string"> SELECT COUNT(*) FROM sys_incoming_record WHERE batch_id = #{batchId} </select> ``` ### ❌ 问题就在这里！ 上面这段 SQL 没有声明 `resultType`，虽然它只返回一个整数，但 MyBatis **不会自动推断基本类型的返回值类型**（尤其是当使用 XML 映射文件时）。 --- ### ✅ 正确写法（添加 `resultType`） #### 方式一：XML 中显式指定 resultType ```xml <select id="selectcountbybatch" parameterType="string" resultType="int"> SELECT COUNT(*) FROM sys_incoming_record WHERE batch_id = #{batchId} </select> ``` > 可用的基本类型别名包括： > - `int`, `integer` → `java.lang.Integer` > - `long` → `java.lang.Long` > - `string` → `java.lang.String` > - `boolean` → `java.lang.Boolean` 也可以写全类名： ```xml resultType="java.lang.Integer" ``` #### 方式二：使用注解方式（如果不用 XML） 如果你是在 Mapper 接口中直接写的注解，应该这样写： ```java @Select("SELECT COUNT(*) FROM sys_incoming_record WHERE batch_id = #{batchId}") int selectcountbybatch(String batchId); ``` 在这种情况下，不需要手动指定 `resultType`，因为接口返回类型已经明确了是 `int`。 --- ### ⚠️ 常见错误点总结 | 错误 | 说明 | |------|------| | 忘记写 `resultType` | 尤其在 XML 中查询返回简单类型（如 int、String）时必须写 | | 方法名大小写不一致 | 如 Java 方法叫 `selectCountByBatch`，但 XML 写的是 `selectcountbybatch`（注意驼峰 vs 全小写） | | XML namespace 错误 | `<mapper namespace="...">` 是否正确指向了该 Mapper 接口？ | | 编译后 XML 未更新 | 清理并重新构建项目，确保最新的 XML 被复制到 classes 目录 | --- ### 🛠 排查步骤建议 1. 检查 `SysIncomingRecordMapper.java` 接口是否有方法： ```java Integer selectcountbybatch(String batchId); ``` 2. 检查 `SysIncomingRecordMapper.xml` 是否有对应 `<select>` 标签，并确认： - `id` 匹配方法名 - `parameterType` 正确（可省略） - **必须有 `resultType`** - `namespace` 正确 3. 示例完整 XML 片段： ```xml <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.sjsemi.activiti.mapper.SysIncomingRecordMapper"> <select id="selectcountbybatch" parameterType="string" resultType="int"> SELECT COUNT(*) FROM sys_incoming_record WHERE batch_id = #{batchId} </select> </mapper> ``` 4. 确保 `resources` 下的 XML 文件被正确打包进 jar/war（Maven 注意 resource 配置）。 5. 如果用了 MyBatis-Plus，请确认不是拦截器干扰，但本错误与 MP 关系不大，本质还是映射缺失。 --- ### ✅ 总结 > 你的程序崩溃是因为：**MyBatis 执行了一个查询，但不知道该如何处理返回的数据结构（缺少 resultType）**。 ✅ **修复方法就是给你的 `<select>` 标签加上 `resultType="int"` 或其他合适的类型。** ---
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值