Database--No converter found capable of converting from type [java.sql.Timestamp] to typeXXX

问题描述

在使用SpringDataJpa操作数据库中，自行编写sql语言，数据查询到无法赋值到Entity对象中

Caused by: org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [java.sql.Timestamp] to type [com.xxxx.lbs.entity.ConfigFileInfoEntity]
	at org.springframework.core.convert.support.GenericConversionService.handleConverterNotFound(GenericConversionService.java:321)
	at org.springframework.core.convert.support.GenericConversionService.convert(GenericConversionService.java:194)
	at org.springframework.core.convert.support.ArrayToObjectConverter.convert(ArrayToObjectConverter.java:68)
	at org.springframework.core.convert.support.ConversionUtils.invokeConverter(ConversionUtils.java:40)
2020-11-25 16:08:16,865 INFO (GlobalResponseHandler.java:46)- RESPONSE : {"code":500,"msg":"Failed to convert from type [java.lang.Object[]] to type [com.xxxx.lbs.entity.ConfigFileInfoEntity] for value '{2020-11-24 15:02:37.879, 7, StefanieSun, /NR1-ADR-Resource/2d91c575-f7e6-4391-aadf-2dfd13056a94.jpg, D:\\044 Test\\2d91c575-f7e6-4391-aadf-2dfd13056a94.jpg, , 47590, 1}'; nested exception is org.springframework.core.convert.ConverterNotFoundException: No converter found capable of converting from type [java.sql.Timestamp] to type [com.xxxxx.lbs.entity.ConfigFileInfoEntity]"}

问题分析

错误信息可以明确看出是在转换数据的是时候报错，仔细检查发现持久层支持的Entity与查询的Entity不匹配

问题解决

如图中红色标注，保持两处的B