问题描述
在使用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