org.springframework.dao.DataIntegrityViolationException: Error attempting to get column ‘blood_press

最新推荐文章于 2024-09-27 08:26:13 发布

三尺犁耙

最新推荐文章于 2024-09-27 08:26:13 发布

阅读量5.1k

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/j59580/article/details/107990887

版权

Java 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

org.springframework.dao.DataIntegrityViolationException: Error attempting to get column 'blood_pressure_last_alert_time' from result set. Cause: java.sql.SQLDataException: Unsupported conversion from TIMESTAMP to java.lang.Integer
; Unsupported conversion from TIMESTAMP to java.lang.Integer; nested exception is java.sql.SQLDataException: Unsupported conversion from TIMESTAMP to java.lang.Integer
   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)
...............
Caused by: com.mysql.cj.exceptions.DataConversionException: Unsupported conversion from TIMESTAMP to java.lang.Integer
   at com.mysql.cj.result.DefaultValueFactory.unsupported(DefaultValueFactory.java:47)
   at com.mysql.cj.result.DefaultValueFactory.createFromTimestamp(DefaultValueFactory.java:59)
   at com.mysql.cj.result.BaseDecoratingValueFactory.createFromTimestamp(BaseDecoratingValueFactory.java:61)
   at com.mysql.cj.result.BaseDecoratingValueFactory.createFromTimestamp(BaseDecoratingValueFactory.java:61)
   at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeTimestamp(MysqlTextValueDecoder.java:183)
   at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:87)
   at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:250)
   at com.mysql.cj.protocol.a.result.ByteArrayRow.getValue(ByteArrayRow.java:91)
   at com.mysql.cj.jdbc.result.ResultSetImpl.getNonStringValueFromRow(ResultSetImpl.java:656)
   ... 211 common frames omitted

Error attempting to get column 'blood_pressure_last_alert_time' from result set. Cause: java.sql.SQLDataException: Unsupported conversion from TIMESTAMP to java.lang.Integer
; Unsupported conversion from TIMESTAMP to java.lang.Integer; nested exception is java.sql.SQLDataException: Unsupported conversion from TIMESTAMP to java.lang.Integer

数据库字段与实体类字段类型不匹配