%Like% Query in spring JpaRepository

by

The spring data JPA query needs the “%” chars as well as a space char following like in your query, as in

@Query("Select c from Registration c where c.place like %:place%").

Cf. http://docs.spring.io/spring-data/jpa/docs/current/reference/html.

You may want to get rid of the @Queryannotation alltogether, as it seems to resemble the standard query (automatically implemented by the spring data proxies); i.e. using the single line

List<Registration> findByPlaceContaining(String place);

is sufficient.

More Related Contents:

  1. How to properly use findBySomeOtherId not findById in Spring data jpa?
  2. setMaxResults for Spring-Data-JPA annotation?
  3. Using generics in Spring Data JPA repositories
  4. Spring Data JPA – ZonedDateTime format for json serialization
  5. How does the FetchMode work in Spring Data JPA
  6. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  7. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  8. Spring Data JPA – “No Property Found for Type” Exception
  9. Handling soft-deletes with Spring JPA
  10. How do I update an entity using spring-data-jpa?
  11. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  12. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  13. Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?
  14. JPA: update only specific fields
  15. Spring-Data FETCH JOIN with Paging is not working
  16. Why use returned instance after save() on Spring Data JPA Repository?
  17. Spring JpaRepository – Detach and Attach entity
  18. Use abstract super class as parameter for Spring data repository
  19. How to use @Transactional with Spring Data?
  20. Are you supposed to have one repository per table in JPA?
  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. Delete Not Working with JpaRepository
  24. JPQL Like Case Insensitive
  25. Spring Data JPA: query ManyToMany
  26. JpaRepository caches newly created object. How to refresh it?
  27. Spring Data JPA find by embedded object property
  28. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  29. Why has javax.persistence-api been replaced by jakarta.persistence-api in spring data jpa starter?
  30. Spring Data + JPA with multiple datasources but only one set of Repositories

Leave a Comment