Spring Data JPA – Pass column name and value as parameters

by

The only dynamic parameter Spring JPA supports is #{#entityName}. Dynamic column names in @Query annotations are not supported., and that is what you are trying to accomplish.

Your only option is to construct a query manually using either QueryDSL, Specifications or Criteria API or simply by building a query string and passing it to your EntityManager. Regardless, you’ll have to write code for that.

See, for instance:

More Related Contents:

  1. How to do bulk (multi row) inserts with JpaRepository?
  2. How to use Spring managed Hibernate interceptors in Spring Boot?
  3. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  4. Spring Boot & JPA: Implementing search queries with optional, ranged criteria
  5. Disable all Database related auto configuration in Spring Boot
  6. JPQL Constructor Expression – org.hibernate.hql.ast.QuerySyntaxException:Table is not mapped
  7. Spring Boot & Spring Data: how are Hibernate Sessions managed?
  8. Spring Data optional parameter in query method
  9. Hibernate field naming issue with Spring Boot (naming strategy)
  10. Spring Data JDBC / Spring Data JPA vs Hibernate
  11. JPA Uppercase table names
  12. Configure Jackson to omit lazy-loading attributes in Spring Boot
  13. Spring Boot + JPA2 + Hibernate – enable second level cache
  14. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  15. Apparent connection leak detected with Hikari CP
  16. Spring Boot Data JPA – Modifying update query – Refresh persistence context
  17. Why has javax.persistence-api been replaced by jakarta.persistence-api in spring data jpa starter?
  18. org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set
  19. What is the difference between DAO and Repository patterns?
  20. How to query data for Primefaces dataTable using lazy loading and pagination
  21. Performing Date/Time Math In HQL?
  22. Hibernate – why use many-to-one to represent a one-to-one?
  23. Filtering data with Spring boot CrudRepository
  24. Deleted object would be re-saved by cascade (remove deleted object from associations)
  25. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  26. Delete Not Working with JpaRepository
  27. When to Use EntityManager.clear()?
  28. Best way of handling entities inheritance in Spring Data JPA
  29. createEntityManager throws java.lang.NullPointerException at org.hibernate.engine.transaction.internal.jta.JtaStatusHelper.getStatus
  30. CDI injection in EntityListeners

Leave a Comment