org.springframework.orm.jpa.jpasystemexception：无法反序列化

Question

我想创建mysql字符串数组类型的数据字段。因此，我在我的spring-boot gradle项目中创建模型类，如下所示。

@Entity
@Table(name = "single_questions")
public class SingleQuestions {
    @Id
    private Integer id;
    private String[] fieldtypevalues;

    public SingleQuestions() {
    }

    public SingleQuestions(Integer id, String category, String field, String field_type, String[] fieldtypevalues) {
        this.id = id;
        this.fieldtypevalues = fieldtypevalues;
    }

    public Integer getId() {
        return this.id;
    }

    public void setId(Integer id) {
        this.id = id;
    }


    public String[] getFieldtypevalues() {
        return this.fieldtypevalues;
    }

    public void setFieldtypevalues(String[] fieldtypevalues) {
        this.fieldtypevalues = fieldtypevalues;
    }

}

这是我的存储库，它通过JpaRepository扩展

public interface SingleQuestionRepository extends JpaRepository<SingleQuestions,Integer>{
    
}

@RestController
@RequestMapping("/singleques")
@CrossOrigin(origins = "*")
public class SingleQuestionController {
    private SingleQuestionRepository singleQuestionRepository;

    public SingleQuestionController(SingleQuestionRepository singleQuestionRepository) {
        this.singleQuestionRepository = singleQuestionRepository;
    }

    @GetMapping("/getall")
    Collection<SingleQuestions> getquestions() {
        return singleQuestionRepository.findAll();
    }

}

但是当我在controller类中运行'getQuestions()'函数时，它给出了以下错误。

嵌套异常为org.hibernate.type.serializationexception：无法反序列化org.springframework.orm.jpa.jpasystemexception：无法反序列化；嵌套异常为org.hibernate.type.serializationexception：无法在org.springframework.orm.jpa.vendor.hibernateejpadialt.converthibernateAccessException（hibernateejpadialt.java:353)上反序列化org.springframework.orm.jpa.vendor.hibernateejpadialt.java:353)

Answer 1

尝试简单地用@elementCollection来注释String[]字段。

@ElementCollection(targetClass=String.class)
@Column(name = "field_type_values")
private String[] fieldTypeValues;