Externalize query in spring boot application

by

Create META-INF inside resources folder . Now create jpa-named-queries.properties file inside that META-INF folder.

Write your query inside this properties file like this:

Customer.findAllCustomerByNamedQuery=Select c from Customer c

Where Customer denote name of entity class and findAllCustomerByNamedQuery is the query name

In your customer repository write this to call your query written in properties file:

List<Customer> findAllCustomerByNamedQuery();

More Related Contents:

  1. POSTing a @OneToMany sub-resource association in Spring Data REST
  2. Spring-boot: required a bean named ‘entityManagerFactory’ that could not be found
  3. Encoded password does not look like BCrypt
  4. Spring Data JPA without Spring Boot
  5. Missing CrudRepository#findOne method
  6. Best way of handling entities inheritance in Spring Data JPA
  7. How to persist LocalDate with JPA?
  8. Spring Boot Configure and Use Two DataSources
  9. Filter invoke twice when register as Spring bean
  10. Xml configuration versus Annotation based configuration [closed]
  11. How can I log SQL statements in Spring Boot?
  12. Using generics in Spring Data JPA repositories
  13. Spring Boot Adding Http Request Interceptors
  14. Spring boot @ResponseBody doesn’t serialize entity id
  15. Can a spring boot @RestController be enabled/disabled using properties?
  16. Is it possible with Spring Boot to serve up JSPs with a JAR packaging?
  17. How to configure embedded Tomcat integrated with Spring to listen requests to IP address, besides localhost?
  18. java.lang.NoClassDefFoundError: org/springframework/core/env/ConfigurableEnvironment
  19. How to enable HTTP response caching in Spring Boot
  20. Multiple WebSecurityConfigurerAdapter in spring boot for multiple patterns
  21. How to get bean using application context in spring boot
  22. Maven Resource Filtering with Spring Boot: Could not resolve placeholder
  23. Unable to use Spring Property Placeholders in logback.xml
  24. Max limit of MultipartFile in Spring Boot
  25. Spring Data – Multi-column searches
  26. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  27. How to use Spring Boot with MySQL database and JPA?
  28. How do I add method based security to a Spring Boot project?
  29. How to instrument / advice a Spring Data (JPA) repository?
  30. How I create an error handler (404, 500…) in Spring Boot/MVC

Leave a Comment