Cannot determine value type from string 'xxxxxx'

最新推荐文章于 2025-02-27 22:04:58 发布

心系蝶相印

最新推荐文章于 2025-02-27 22:04:58 发布

阅读量3.8w

点赞数 12

分类专栏： Java

本文链接：https://blog.youkuaiyun.com/qq_34729698/article/details/89510827

版权

Java 专栏收录该内容

12 篇文章

订阅专栏

报错如下：

查到的都是说字段和属性没对上

还有一种情况，构造函数问题，有参构造创建后，无参构造没有创建，也会导致这个问题。弄了一下午，换数据库、换字段、换属性名都没解决，最后想起来是不是缺少无参构造了

There was an unexpected error (type=Internal Server Error, status=500).
Error attempting to get column 'u_account' from result set. Cause: java.sql.SQLDataException: Cannot determine value type from string '201577D0510' ; Cannot determine value type from string '201577D0510'; nested exception is java.sql.SQLDataException: Cannot determine value type from string '201577D0510'
org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'u_account' from result set.  Cause: java.sql.SQLDataException: Cannot determine value type from string '201577D0510'
; Cannot determine value type from string '201577D0510'; nested exception is java.sql.SQLDataException: Cannot determine value type from string '201577D0510'
	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:84)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy65.selectList(Unknown Source)