org.mybatis.spring.MyBatisSystemException

最新推荐文章于 2024-06-19 09:29:01 发布
最新推荐文章于 2024-06-19 09:29:01 发布
阅读量1.8k 收藏 1
点赞数
文章标签： spring java intellij-idea
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ZJZQL/article/details/121767139
版权 
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'description' from result set.  Cause: java.lang.NumberFormatException: For input string: "vue￥ﾅﾥ￩ﾗﾨ"
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
	at com.sun.proxy.$Proxy89.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:108)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)
	at com.sun.proxy.$Proxy92.getCoursePublishVo(Unknown Source)
	at com.zj.eduservice.service.impl.EduCourseServiceImpl.getCoursePublishInfo(EduCourseServiceImpl.java:90)
	at com.zj.eduservice.service.impl.EduCourseServiceImpl$$FastClassBySpringCGLIB$$2aba971b.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)
	at com.zj.eduservice.service.impl.EduCourseServiceImpl$$EnhancerBySpringCGLIB$$73cac47a.getCoursePublishInfo(<generated>)
	at com.zj.eduservice.controller.EduCourseController.getCoursePublishInfo(EduCourseController.java:70)
	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.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:888)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1579)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'description' from result set.  Cause: java.lang.NumberFormatException: For input string: "vue￥ﾅﾥ￩ﾗﾨ"
	at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:83)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createUsingConstructor(DefaultResultSetHandler.java:671)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createByConstructorSignature(DefaultResultSetHandler.java:654)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject(DefaultResultSetHandler.java:618)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.createResultObject(DefaultResultSetHandler.java:591)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:397)
	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 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.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy148.query(Unknown Source)
	at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:67)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:163)
	at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:90)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	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.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:426)
	... 61 more
Caused by: java.lang.NumberFormatException: For input string: "vue￥ﾅﾥ￩ﾗﾨ"
	at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043)
	at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110)
	at java.lang.Double.parseDouble(Double.java:538)
	at com.mysql.cj.protocol.a.MysqlTextValueDecoder.getDouble(MysqlTextValueDecoder.java:238)
	at com.mysql.cj.result.AbstractNumericValueFactory.createFromBytes(AbstractNumericValueFactory.java:57)
	at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(MysqlTextValueDecoder.java:132)
	at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:133)
	at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:241)
	at com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:132)
	at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1285)
	at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:786)
	at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:807)
	at com.zaxxer.hikari.pool.HikariProxyResultSet.getInt(HikariProxyResultSet.java)
	at org.apache.ibatis.type.IntegerTypeHandler.getNullableResult(IntegerTypeHandler.java:37)
	at org.apache.ibatis.type.IntegerTypeHandler.getNullableResult(IntegerTypeHandler.java:26)
	at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:81)
	... 91 more

记录下：使用springboot整合mybatis-plus时，遇到复杂的场景需要我们写xml配置自定义sql语句。

  我自己写的：

 <select id="getCoursePublishVo" resultType="com.zj.eduservice.entity.vo.CoursePublishVo">
                SELECT course.title,course.cover,course.price,ecd.description,et.name teacherName,es1.title subjectLevelOne,es2.title subjectLevelTwo,course.lesson_num lessonNum
                FROM edu_course course
                             LEFT JOIN edu_teacher et ON course.teacher_id=et.id
                             LEFT JOIN edu_course_description ecd ON course.id=ecd.id
                             LEFT JOIN edu_subject es1 ON course.subject_parent_id=es1.id
                             LEFT JOIN edu_subject es2 ON course.subject_id=es2.id
                WHERE course.id=#{courseId}

        </select>

  复制老师的：

 <select id="getCoursePublishVo" resultType="com.zj.eduservice.entity.vo.CoursePublishVo">
        SELECT ec.id,ec.title,ec.price,ec.lesson_num AS lessonNum,ec.cover,
               et.name AS teacherName,
               es1.title AS subjectLevelOne,
               es2.title AS subjectLevelTwo
        FROM edu_course ec LEFT OUTER JOIN edu_course_description ecd ON ec.id=ecd.id
                           LEFT OUTER JOIN edu_teacher et ON ec.teacher_id=et.id
                           LEFT OUTER JOIN edu_subject es1 ON ec.subject_parent_id=es1.id
                           LEFT OUTER JOIN edu_subject es2 ON ec.subject_id=es2.id
        WHERE ec.id=#{courseId}
        </select>

很奇怪，自己写的就报上述异常，难不成是起别名没用AS吗。

先将问题放这，以后再来研究

ZJZQL
关注
Mybatis报错：org.mybatis.spring.MyBatisSystemException:...Parameter ‘name‘ not found.的解决方法！
任聪聪的博客
02-24 187
本篇文章主要讲解：Mybatis报错org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘你的字段，任意的’ not found. Available parameters are [arg1, arg0, param1, param2]的解决办法日期：2024年2月24日作者：任聪聪。
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingExce
xujunming668的博客
12-30 2393
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(
mybatis配置导致的null空指针错误
tendecss
03-12 4818
04:38:54.134 [http-nio-8080-exec-5] DEBUG o.s.w.s.m.m.a.RequestMappingHandlerMapping - Looking up handler method for path /manage/product/search.action 04:38:54.137 [http-nio-8080-exec-5] DEBUG o....
完美解决org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.Refl
最新发布
m0_55927959的博客
06-19 5081
完美解决org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.Refl
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException
热门推荐
qq_43593107的博客
11-04 7万+
spring整合mybatis 在测试插入操作时出现此异常，具体如下： org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='name', mode=IN, javaType=c...
org.mybatis.spring.MyBatisSystemException异常及处理
weixin_30315435的博客
07-25 2万+
MyBatisSystemException异常 测试场景 在测试springboot中使用MyBatis/通用Mapper的自定义方法时出现此异常。 异常如下: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set par...
解决Mybatis系统异常org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflec
qq_35759451的博客
11-09 2万+
解决Mybatis系统异常org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'certno' in 'class java.lang.String' 这是我第二次遇到这个错误了，我必须要写个博客安慰一下自己… org.mybatis.spring.MyBati
报错：nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.iba
lijiahao_li的博客
07-21 5527
报错信息如下： 七月 21, 2021 3:27:50 下午 org.apache.catalina.core.StandardWrapperValve invoke 严重: Servlet.service() for servlet [springmvc] in context with path [/NovelReading] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBat
Mybatis报错org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.Bu
q393147005的博客
10-01 3040
使用spring+Mybatis報錯org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error invoking SqlProvider method (tk.mybatis.mapper.provider.base.BaseSelectProvider.dynamicSQL). Cause: java.lang.InstantiationE
SSM_bug:org.mybatis.spring.MyBatisSystemException:
77的博客
09-01 512
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     at o
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.Per异常的正确
PythonAigc的博客
06-05 4010
`org.mybatis.spring.MyBatisSystemException` 是 MyBatis 与 Spring 集成时遇到的一个异常，它通常表示 MyBatis 在与数据库交互过程中遇到了问题。这个异常通常会有一个嵌套的异常（nested exception），在这个例子中，是 `org.apache.ibatis.exceptions.PersistenceException`，但这个异常名称可能是一个笔误，因为 MyBatis 通常使用 `org.apache.ibatis.excepti
mybatis报错：org.mybatis.spring.MyBatisSystemException
我就是那个大头
01-30 2978
我这个报错是在测试环境（windows系统），在正式环境（Linux）上没有报错，报错代码如下： Mapper.xml 文件中： resultMap="phoneLockMap"> select order_number,phone_number,DATE_FORMAT(create_Time,'%Y-%m-%d %H:%i:%s') create_Time f
org.mybatis.spring.MyBatisSystemException:Error evaluating expression ‘query. xxx!=null ‘ 对象为空异常
我的博客
08-07 7143
此异常经过两天的研究终于解决。。。 一开始以为传递参数错误，检查mapper中的参数指定，没有发现问题。 检查xml中也未发现问题。 原因在于在Controller层没有使用@RequestBody注解，导致传入的请求对象是空的。添加@RequestBody注解后问题解决。 ...
java.lang.AbstractMethodError: org.mybatis.spring.transaction.SpringManagedTransaction.getTimeout()L
HeyShHeyou的博客
10-05 482
错误日志如下： java.lang.AbstractMethodError: org.mybatis.spring.transaction.SpringManagedTransaction.getTimeout()Ljava/lang/Integer; at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleEx...
开发maven时遇到无效的绑定语句（未找到）,org.apache.ibatis.binding.BindingException：
Kahen的博客
08-02 3558
今天做一个springmvc+mybatis的maven项目时运行登录时报错，显示找不到绑定语句 我们的class文件被编译了，但是绑定语句xml文件没有被编译。 在做maven项目时，以后都要注意一个点，要在build标签里加上这个语句
org.mybatis.spring.MyBatisSystemException: null
09-01
org.mybatis.spring.MyBatisSystemException是一个MyBatis框架的异常类，它表示在使用MyBatis时发生了系统错误。具体的错误信息为null，这表示在异常发生时，没有提供详细的错误消息。要解决这个问题，我们需要查看异常的堆栈跟踪以获取更多的信息，以便定位问题所在。可能的原因包括但不限于配置错误、数据访问对象定义错误、数据库连接问题等。根据异常的堆栈跟踪和相关代码，我们可以进一步分析并解决这个问题。<span class="em">1</span><span class="em">2</span> #### 引用[.reference_title] - *1* [org.mybatis.spring.MyBatisSystemException异常及处理](https://blog.csdn.net/weixin_30315435/article/details/97534789)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *2* [基于mybatis考试管理及成绩查询模块的设计与开发](https://download.csdn.net/download/dearmite/88277358)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值