java - Spring Boot 无法处理自定义 JPA 请求

Question

有这个代码:

@Query(value = "SELECT t FROM trainings t ORDER BY RANDOM() LIMIT 8", nativeQuery = true)
List<Training> findRandom();

收到此错误:

org.postgresql.util.PSQLException: The column name id was not found in this ResultSet.

执行此代码时:

System.out.println(trainingRepo.findRandom());

我的问题出在哪里？怎么解决呢？

Answer 1

您不需要在此处使用“t”，因为它不是 JPQL，而是 native 查询(您已设置 nativeQuery = true)

将查询替换为 SELECT * FROM Trainings ORDER BY RANDOM() LIMIT 8