Spring Data JPA: query ManyToMany

by

The following method signature will get you want to want:

List<Test> findByUsers_UserName(String userName)

This is using the property expression feature of Spring Data JPA. The signature Users_UserName will be translated to the JPQL x.users.userName. Note that this will perform an exact match on the given username.

More Related Contents:

  1. setMaxResults for Spring-Data-JPA annotation?
  2. Using generics in Spring Data JPA repositories
  3. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  4. Handling soft-deletes with Spring JPA
  5. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  6. Spring-Data FETCH JOIN with Paging is not working
  7. Why use returned instance after save() on Spring Data JPA Repository?
  8. How to use @Transactional with Spring Data?
  9. Spring Data JPA find by embedded object property
  10. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  11. Spring Data + JPA with multiple datasources but only one set of Repositories
  12. Dynamic spring data jpa repository query with arbitrary AND clauses
  13. Spring Boot, Spring Data JPA with multiple DataSources
  14. How to fetch FetchType.LAZY associations with JPA and Hibernate in a Spring Controller
  15. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  16. Filtering database rows with spring-data-jpa and spring-mvc
  17. Implementing custom methods of Spring Data repository and exposing them through REST
  18. Spring data jpa- No bean named ‘entityManagerFactory’ is defined; Injection of autowired dependencies failed
  19. How to manually force a commit in a @Transactional method? [duplicate]
  20. Use abstract super class as parameter for Spring data repository
  21. How to map sql native query result into DTO in spring jpa repository?
  22. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  23. Difference between save and saveAndFlush in Spring data jpa
  24. Delete Not Working with JpaRepository
  25. spring data jpa @query and pageable
  26. Spring Data JPA: Query by Example?
  27. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  28. How to store @Query sql in external file for CrudRepository?
  29. Spring Data – Multi-column searches
  30. Best way of handling entities inheritance in Spring Data JPA

Leave a Comment