如何解决组织.Spring框架.核心.转换.转换失败异常，同时使用Spring数据jpa从数据库获取数据

Question

领域类别

@Data
@NoArgsConstructor
@AllArgsConstructor
@Entity
@Table(name = "SAMPLE_DATA")
@TypeDefs({
        @TypeDef(name = "json", typeClass = JsonStringType.class),
        @TypeDef(name = "jsonb", typeClass = JsonBinaryType.class)
})
public class Sample implements Serializable {

    private static final long serialVersionUID = 1719868663566734198L;

    @Id
    private Long Id;
    
    @Type(type = "json")
    @Column(columnDefinition = "json",name = "person")
    private Person personObj;
    private String sampledata;
    private String createdBy;

}

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Person implements Serializable {

    private static final long serialVersionUID = -5427425033242474312L;
    private String firstName;
    private String lastName;
    
}

知识库类

@Repository
public interface SampleRepository extends JpaRepository<Sample, Long> {
   @Query(value = "select s.personObj,s.sampledata from     Sample s where s.Id=:Id")
List<Sample> findPersonById(Long Id);
}

要映射以映射JSON对象类型，请使用

<dependency>
        <groupId>com.vladmihalcea</groupId>
        <artifactId>hibernate-types-52</artifactId>
        <version>${hibernate-types.version}</version> 
 </dependency> 

当我试图获取Sample对象列表时，我得到了以下异常

org.springframework.core.covert。ConversionFailedException:无法将值“[Person（firstName=abc，lastName=test）]”从类型[java.lang.Object[]]转换为类型[@org.springframework.data.jpa.repository.Query com.domain.Sample]；嵌套异常是org.springframework.core.covert。ConverterNotFoundException:找不到能够从类型[com.domain.Person]转换为类型[@org.springframework.data.jpa.repository.Query com.domman.Sample]的转换器…………原因：org.sprinkframework.core.covert。ConverterNotFoundException:未找到能够从类型[com.domain.Person]转换为类型[@org.springframework.data.jpa.repository.Query com.domman.Sample]的转换器

Answer 1

您不必选择不同的列。您必须选择实体:

@Repository
public interface SampleRepository extends JpaRepository<Sample, Long> {

   @Query(value = "select s from Sample s where s.Id=:Id")
   List<Sample> findPersonById(Long Id);
}