如何在JPA本机查询中传递Lists参数List[重复]

Question

我需要创建一个与以下示例相关的JPA本机查询：

select * from inventory where (server, product) in (('server1','product1'), ('server2','product2'), ('server1','product3'));

我创建了一个本机查询：

@Query(
            value = "select server, product from inventory where (server, product) in (:myList)",
            nativeQuery = true
    )
    List<Product> getProducts(List<List<String>> myList);

List<List<String>> myList= Arrays.asList(
    Arrays.asList("server1","product1"),
    Arrays.asList("server2","product2"),
    Arrays.asList("server1","product3")
);
List<Product> products = myRepository.getProducts(myList);

java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator

Answer 1

使用此：

@Query("select server, product from inventory where (server, product) in (:myList)",
        nativeQuery = true)
List<Product> getProducts(@Param("myList") List<List<String>> myList);