com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string ‘xx‘

原创已于 2026-05-08 21:41:37 修改 · 28 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

GEO检测

标签

#mybatis #java

话题

#IT疑难杂症诊疗室

于 2026-05-08 21:41:16 首次发布

Java常规问题专栏专栏收录该内容

4 篇文章

订阅专栏

1、问题

运行程序报错：

2026-05-08 21:18:55.197 [http-nio-8080-exec-1] ERROR o.a.c.c.C.[.[localhost].[/].[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'master_name' from result set.  Cause: java.sql.SQLDataException: Cannot determine value type from string 'xx'
; Cannot determine value type from string 'xx'] with root cause
com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string 'xx'
	at com.mysql.cj.result.AbstractNumericValueFactory.createFromBytes(AbstractNumericValueFactory.java:65)
	at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(MysqlTextValueDecoder.java:143)
	at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:135)
	at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:243)
	at com.mysql.cj.protocol.a.result.ByteArrayRow.getValue(ByteArrayRow.java:91)
	at com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1324)
	at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:830)
	at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:851)

项目主要是springboot+mybatis，我这个功能验证是分页查询数据，但是查询报错，可以看出是类型原因