How do I reuse a parameter witha Spring-Data-JPA Repository?

Question

In looking at the Query Creation for the Spring Data JPA Repositories, I'm wondering how I would reuse a parameter. For example, how would I name the method if I wanted to do something like:

@Query("select c from #{#entityName} c where c.lower <= ?1 and c.upper >= ?1")
E findByConversionFor(Double amount);

Can that query be converted to a SpEL method name (to be used by the query builder)?

It seems like a kludge to require the same value to be passed twice:

E findByLowerLessThanOrEqualAndUpperGreaterThanOrEqual(Double a, Double b); // where a==b

Take a look: https://stackoverflow.com/questions/19417670/using-generics-in-spring-data-jpa-repositories — Rana_S, Jun 20 '17 at 20:00

score 2 · Accepted Answer · answered Jun 20 '17 at 19:58

2

Just mark your parameter with @Param("amount") and then will be able to use it by name:

@Query("select c from #{#entityName} c where c.lower <= :amount and c.upper >= :amount")

answered Jun 20 '17 at 19:58

Bohdan Levchenko

3,411
2
24
28

3

Yes, this works perfectly for the JPQL query. Do you know how I can reuse parameters in the SpEL method? – end-user Jun 22 '17 at 12:58
So, there's no way to pass through "query method name creation"? (without the need of the @Query annotation) – Mr. Anderson May 10 '18 at 15:29

How do I reuse a parameter witha Spring-Data-JPA Repository?

1 Answers1

Linked