nested exception is org.apache.ibatis.executor.result.ResultMapException: Error attempting to get co

最新推荐文章于 2024-09-21 15:18:04 发布
最新推荐文章于 2024-09-21 15:18:04 发布
阅读量1.3w 收藏 1
点赞数 1
分类专栏： error 文章标签： mybatis mysql java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_36008278/article/details/116158091
版权

完整错误

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'parentId' from result set.  Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'parentId' from result set.  Cause: java.sql.SQLException: Column 'parentId' not found.

	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
	at com.sun.proxy.$Proxy65.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:173)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)
	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.$Proxy73.findALlNodeParent(Unknown Source)
	at com.duan.service.impl.DataServiceImpl.findALlNodeParent(DataServiceImpl.java:149)
	at com.duan.ElectricApplicationTests.testNode(ElectricApplicationTests.java:202)
	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 org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:686)
	at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
	at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:140)
	at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:84)
	at org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
	at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
	at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$6(TestMethodTestDescriptor.java:212)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:208)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:137)
	at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:71)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:135)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1257)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at java.util.ArrayList.forEach(ArrayList.java:1257)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125)
	at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123)
	at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122)
	at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80)
	at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.submit(SameThreadHierarchicalTestExecutorService.java:32)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestExecutor.execute(HierarchicalTestExecutor.java:57)
	at org.junit.platform.engine.support.hierarchical.HierarchicalTestEngine.execute(HierarchicalTestEngine.java:51)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:248)
	at org.junit.platform.launcher.core.DefaultLauncher.lambda$execute$5(DefaultLauncher.java:211)
	at org.junit.platform.launcher.core.DefaultLauncher.withInterceptedStreams(DefaultLauncher.java:226)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:199)
	at org.junit.platform.launcher.core.DefaultLauncher.execute(DefaultLauncher.java:132)
	at com.intellij.junit5.JUnit5IdeaTestRunner.startRunnerWithArgs(JUnit5IdeaTestRunner.java:69)
	at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
	at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:230)
	at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:58)
Caused by: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'parentId' from result set.  Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'parentId' from result set.  Cause: java.sql.SQLException: Column 'parentId' not found.
	at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:87)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.prepareCompositeKeyParameter(DefaultResultSetHandler.java:831)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.prepareParameterForNestedQuery(DefaultResultSetHandler.java:808)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getNestedQueryMappingValue(DefaultResultSetHandler.java:784)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getPropertyMappingValue(DefaultResultSetHandler.java:504)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyPropertyMappings(DefaultResultSetHandler.java:480)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:404)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:354)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:328)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:301)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:194)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	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.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:92)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	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 org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
	... 72 more
Caused by: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'parentId' from result set.  Cause: java.sql.SQLException: Column 'parentId' not found.
	at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:87)
	at org.apache.ibatis.type.UnknownTypeHandler.getNullableResult(UnknownTypeHandler.java:74)
	at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:85)
	... 96 more
Caused by: java.sql.SQLException: Column 'parentId' not found.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
	at com.mysql.cj.jdbc.result.ResultSetImpl.findColumn(ResultSetImpl.java:556)
	at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1408)
	at com.alibaba.druid.pool.DruidPooledResultSet.getObject(DruidPooledResultSet.java:447)
	at org.apache.ibatis.type.ObjectTypeHandler.getNullableResult(ObjectTypeHandler.java:37)
	at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:85)
	... 98 more


2021-04-26 15:33:51.201  INFO 33576 --- [extShutdownHook] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'
2021-04-26 15:33:51.202  INFO 33576 --- [extShutdownHook] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closing ...
2021-04-26 15:33:51.206  INFO 33576 --- [extShutdownHook] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} closed

Process finished with exit code -1

以下是参考解决方法👇

  1. 将lombok的@data注解去掉 手动添加get，set方法和构造函数
  2. 查看数据库是否成功运行
  3. 仔细检查sql语句
    我当时写错了一点就是sql语句
@Select("select pf.fun_id,pf.functionCode,pf.functionName,#{role_id} as 'roleId',pf.funcUrl from ps_function pf inner join ps_role_premission prp on pf.fun_id = prp.fun_id where pf.parentId=0 and prp.role_id=#{roleId}")
    @Results({
            @Result(property = "childNodes",column = "{fun_id = parentId},{roleId = roleId}",many = @Many(select = "com.duan.mapper.DataMapper.findAllNodeChild"))
    })
    List<MenuNode> findALlNodeParent(int roleId);


    @Select("select pf.fun_id,pf.functionCode,pf.functionName,pf.funcUrl from ps_function pf inner join ps_role_premission prp on pf.fun_id = prp.fun_id where pf.parentId=#{parentId} and prp.role_id=#{roleId}")
    List<MenuNode> findAllNodeChild(@Param("parentId") int parentId,@Param("roleId") int roleId);

如果和我一样用的多参数一对多的话错误可能出现在

column = "{fun_id = parentId},{roleId = roleId}"

这里在这里插入图片描述
column 参数写法 ：{@Param 名称 = column 字段名 , @Param 名称 = column 字段名 …}以逗号隔开

我写反了 我的sql语句中没有parentId字段所以报错

温柔如風
关注
专栏目录
解决MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException错误
念兮为美
03-05 4508
多种方法解决org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 2或者Expected one result (or null) to be returned by getOne的错误。
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorEx
DN金猿的博客
09-08 265
属性，这个属性会返回自动生成的ID设置到参数中，如果参数中没有。方案二：如果需要返回ID值，在传的参数中加上。的参数封装成实体，包含这几个字段。方案一：如果不需要返回ID值，就把。插入数据时mybatis报错。插入数据传的参数中没有。
mybatis中Error attempting to get column ‘xx‘ from result set 问题解决
guily_kiss的博客
03-01 6881
文章部分摘要:https://www.cnblogs.com/asplover/p/12376550.html
Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping:
最新发布
m0_72957390的博客
09-21 213
运行时一直报标题的错误，原因是不能再sql语句中使用注释符号。这是我的xml的mapper文件的部分。将上面的注释删除即可整常运行。
报错：nested exception is org.apache.ibatis.executor.result.ResultMapException
weixin_48052655的博客
11-14 1776
在完成需求的时候遇到了以下问题，调用某查询接口中，返回了报错信息，用到了ExtBeanWrapper对象，Oracle数据库中的NCLOB类型。查询道德数据中，墨条数据中的ExtBeanWrapper字段不是JSON数据，导致了Java中的插件无法进行解析。数据库中查找提示的字段中，把不是{}包起来的数据用{}包起来或者进行删除（危险操作，一定搞清楚有无作用）
记一次使用lombok时mybaties报错"nested exception is org.apache.ibatis.executor.result.ResultMapException:"
一条路走到黑
10-17 6922
报错nested exception is org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column ‘user_name’ from result set. Cause: java.lang.NumberFormatException: For input string: “shenz...
Mybatis异常分析之 org.apache.ibatis.executor.result.ResultMapException
代码缔造者的博客
03-20 9500
前文 本文章主要正对org.apache.ibatis.executor.result.ResultMapException 异常出现情况分析。从原理角度明白为啥会有这样的异常，以后不管那种场景下，明白原理后，不需要百度自己即可知道问题的根源。 怎么会出现这样错误 情况一 情况二 通过源码分析原理 如何解决 情况一解决 对象类型值与mysql 一一对应 情况二解决 剔除注解@Builder 或者@AllArgsConstructor 代理生成构造方法注解都要剔除。 第一条不剔除的话，按照数据库查询出
Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column
abc44532的博客
05-18 1141
为了搞这个问题，卡了一个多小时，问chatgpt弄了半天，用上typeHandler发现版本有问题，也没有深究，退回原来版本看了半天，又从网上看了半天博客和mybatis使用说明，终于发现了问题。而chatgpt给我的解释也是从数字转成字符串导致问题，我居然没有想到。这是我原来的实体类，如果你是一个细心的人，已经发现了。这是我原来的数据库,下面是改之后的。是的，我的命名顺序不同。
org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column ‘password’ from
weixin_55836603的博客
03-19 475
描述 服务器遇到一个意外的情况，阻止它完成请求。HTTP状态 500 - 内部服务器错误。在对应实体类中补充无参和全参的构造器。
nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for propert
念兮为美
03-23 3411
全网多种方法解决nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'xxx' in 'class com.xxx'的错误
mybatis报错nested exception is org.apache.ibatis.builder.IncompleteElementException:Could not find par
执子手 吹散苍茫茫烟波
06-11 1379
一.问题描述 2021-06-11 09:12:29.869 [http-nio-8080-exec-3] INFO com.course.controller.UserManger - request url is:http://localhost:8080/v1/login 2021-06-11 09:12:29.869 [http-nio-8080-exec-3] INFO com.course.controller.UserManger - tt 2021-06-11 09:12:29.869
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingExce
xujunming668的博客
12-30 2435
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘ids’ not found. Available parameters are [collection, list] at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(
SpringBoot报错：nested exception is org.apache.ibatis.executor.ExecutorException: No constructor found ...
weixin_30617737的博客
01-08 4937
错误提示： Caused by: org.apache.ibatis.executor.ExecutorException: No constructor found in com.tuyrk._161_java_socket.project6.entity.User matching [java.lang.Long, java.lang.String, java.lang.String] 这里就...
解决：mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorEx
T
11-07 3181
报错： 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 ‘Mapper.Equipmen...
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.Executor
燃烧的梦想是信仰
10-26 2179
错误是：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.example.manage.mapper.DeptMapper.queryAllDept'. It's likely that n.
ERROR 338684 ---e.s.common.exception.RRExceptionHandler : nested exception is org.apache.ibatis
jungleirim的博客
04-28 365
2024-04-28 17:03:16.510 ERROR 338684 --- [nio-8082-exec-3] e.s.common.exception.RRExceptionHandler : nested exception is org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'gender' from result set. Cause: java.lang.Illeg
java mybatis org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.
Li_Chunxiao_的博客
09-24 1443
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.NullPointerException ### Cause: java.lang.NullPointerException at org.mybatis.spring.MyBatisE
【问题解决】nested exception is org.apache.ibatis.exceptions.TooManyResultException:Expected one result
专注Java后端技术干货、项目源码总结分享，期待您的关注。
02-26 2203
今天在调试项目的时候，控制台出现了如下的报错信息，从下面报错信息可以明白大致的意思是：出现了过多的结果返回值，只希望得到一个值，但是现在返回了2个。
org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the
sinat_38605308的博客
01-06 295
select语句上没有写resultMap
nested exception is org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'change_type' from result set.
05-30
这个异常是MyBatis查询结果集中某个字段不存在导致的。具体原因可能是以下几种情况之一： 1. 数据库表中不存在该字段：检查一下你的数据库表中是否存在该字段，如果不存在，需要在表中添加该字段。...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值