Can I combine a @Query definition with a Specification in a Spring Data JPA repository method?

by

First thing, you should read this Spring blog post.

Second, according to the JpaSpecificationExecutor interface, that your repositories should implement, the following method take a Specification argument:

  • count(Specification<T> spec)
  • List<T> findAll(Specification<T> spec)
  • Page<T> findAll(Specification<T> spec, Pageable pageable)
  • List<T> findAll(Specification<T> spec, Sort sort)
  • T findOne(Specification<T> spec)

So, you can’t mix a @Query definition with a Specification.

However, since you can express the firstName <> ?1 condition using a Specification and because you combine as many specifications as you want, you can rewrite the whole @Query using Specification(s) only.

More Related Contents:

  1. How does the FetchMode work in Spring Data JPA
  2. Spring JpaRepository – Detach and Attach entity
  3. How to map sql native query result into DTO in spring jpa repository?
  4. Difference between save and saveAndFlush in Spring data jpa
  5. spring data jpa @query and pageable
  6. Bypass GeneratedValue in Hibernate (merge data not in db?)
  7. Using generics in Spring Data JPA repositories
  8. Spring Data JPA – ZonedDateTime format for json serialization
  9. No Dialect mapping for JDBC type: 1111
  10. ImprovedNamingStrategy no longer working in Hibernate 5
  11. @Transactional method called from another method doesn’t obtain a transaction
  12. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  13. How to set up default schema name in JPA configuration?
  14. Transaction marked as rollback only: How do I find the cause
  15. Spring boot JPA insert in TABLE with uppercase name with Hibernate
  16. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  17. JPA: update only specific fields
  18. When are connections returned to the connection pool with Spring JPA (Hibernate) Entity Manager?
  19. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  20. Change database schema during runtime based on logged in user
  21. The onFlushDirty Hibernate Interceptor method is never called
  22. JPQL Like Case Insensitive
  23. Spring Data JPA: query ManyToMany
  24. Hibernate, spring, JPS & isolation – custom isolation not supported
  25. Error creating bean with name ‘entityManagerFactory
  26. Spring Data JPA find by embedded object property
  27. Spring, JPA, and Hibernate – how to increment a counter without concurrency issues
  28. Mapping JPA or Hibernate projection query to DTO (Data Transfer Object)
  29. Spring Data + JPA with multiple datasources but only one set of Repositories
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment