Spring Data JPA native @Query with whole entity as named @Param

Question

Say I have two entities:

class User {
  @Id private int id;
  private String name;
  private int addressId;
}

class Address {
  @Id private int id;
  private String street;
}

Is it possible to do this:

interface UserRepository extends CrudRepository<User, Integer> {
  @Query(nativeQuery=true,
    value=
      "select * from user "
    + "inner join address a on a.id = u.addressId "
    + "where a.street = :address.street")
  List<User> findByAddress(@Param("address") Address address);
}

That is: accept an entity (Address in this case) as the parameter, but reference one of its properties (Address.street in this case) in the native query?

For various reasons, I cannot use "normal" @ManyToMany and JPA queries for these two entities.

levant pied · Accepted Answer · 2020-01-02 22:06:11Z

9

Found an answer here:

https://spring.io/blog/2014/07/15/spel-support-in-spring-data-jpa-query-definitions

This can be used:

+ "where a.street = :#{#address.street}")

Bonus - for a.street in(...), use collection projections:

https://docs.spring.io/spring/docs/4.3.10.RELEASE/spring-framework-reference/html/expressions.html#expressions-collection-projection

That is:

+ "where a.street in(:#{#address.![street]})")

edited Jan 2, 2020 at 22:06

answered Jan 2, 2020 at 21:44

levant pied

4,6515 gold badges46 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring Data JPA native @Query with whole entity as named @Param

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related