JPA - native queries

Native queries using jpa

We can write SQL native queries in Spring Boot applications with @Query annotation.

1. define SQL in the value attribute
2. set the nativeQuery attribute value to true

Note that:

1. Spring Data JPA don’t adjust the query to database’s specific SQL dialect, so ensure that the provided statement is supported by RDBMS.

2. Spring Data JPA does not currently support dynamic sorting for native queries, because it would have to manipulate the actual query declared, which it cannot do reliably for native SQL.

   How to make the query ignore the optional parameters?

   https://github.com/explorer436/programming-playground/blob/main/java-playground/spring-data-examples/spring-data-jpa-with-h2/src/main/java/com/mycompany/tutorial/nativequeriesusingjparepository/repositories/TutorialRepositoryUsingNativeQueries.java

Implementation

https://github.com/explorer436/programming-playground/blob/main/java-playground/spring-data-examples/spring-data-jpa-with-h2/src/main/java/com/mycompany/tutorial/nativequeriesusingjparepository/repositories/TutorialRepositoryUsingNativeQueries.java

Reading material

https://thorben-janssen.com/jpa-native-queries/