spring jpa创建双括号查询 [英] spring jpa create double parenthesis query

问题描述

我正在将Spring Boot与JPA(EclipseLink)和Oracle 11一起使用. 我有CrudRepository界面:

I'm using Spring Boot with JPA (EclipseLink) and Oracle 11. I have CrudRepository interface:

public interface TransportDefRepository extends CrudRepository<TransportDef, Long> {
    public List<TransportDef> findByNameInOrderByNameAsc(List<String> names);
}

调用findByNameInOrderByNameAsc方法将创建查询:

SELECT ID, NAME,
FROM TRANSPORT_DEFS WHERE (NAME IN (('A','B'))) ORDER BY NAME ASC

Oracle抛出异常:

and Oracle throws exception:

ORA-00907: missing right parenthesis

我做错什么了吗? 为什么生成的查询中有双括号?

Am I doing something wrong? Why there are double parenthesis in generated query?

推荐答案

我的解决方案:

@Query("select t from TransportDef t where t.name in ?1 order by t.name asc")
public List<TransportDef> findByNameInOrderByNameAsc(List<String> names);

使用@Query注释，eclipselink创建查询:

With @Query annotation eclipselink creates query:

SELECT ... FROM TRANSPORT_DEFS WHERE (NAME IN (?,?,?)) ORDER BY NAME ASC

这只是解决方法-我不知道为什么Spring Data JPA如果没有此注释就生成无效查询...

It's only workaround - I have no idea why Spring Data JPA generates invalid query without this annotation...

这篇关于spring jpa创建双括号查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！