java Spring引导无法满足自定义JPA请求
有了这个代码:
@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());
我的问题在哪里?我该怎么解决呢
# 1 楼答案
这里不需要使用“t”,因为它不是JPQL,而是本机查询(您已经设置了
nativeQuery = true
)将查询替换为
SELECT * FROM trainings ORDER BY RANDOM() LIMIT 8