Is it possible to use raw SQL within a Spring Repository

java hibernate spring-data-jpa
Webnet picture Webnet · Apr 11, 2013 · Viewed 192.2k times · Source

I need to use raw SQL within a Spring Data Repository, is this possible? Everything I see around @Query is always entity based.

Answer

zagyi picture zagyi · Apr 11, 2013

The @Query annotation allows to execute native queries by setting the nativeQuery flag to true.

Quote from Spring Data JPA reference docs.

Also, see this section on how to do it with a named native query.

Related questions

Difference between save and saveAndFlush in Spring data jpa

I am trying to learn spring data JPA by testing some CRUD operation via JpaRepository. I came across two methods save and saveAndFlush. I don't get the difference between these two. On calling save also my changes are getting saved …

Read More
How does the FetchMode work in Spring Data JPA

I do have a relation between three model object in my project (model and repository snippets in the end of the post. When I call PlaceRepository.findById it does fire three select queries: ("sql") SELECT * FROM place p where id = …

Read More
spring data jpa @query and pageable

I'm using Spring Data JPA, and when I use @Query to to define a query WITHOUT Pageable, it works: public interface UrnMappingRepository extends JpaRepository<UrnMapping, Long> { @Query(value = "select * from internal_uddi where urn like %?1% or contact like %?1%", …

Read More