Executing Native SQL using Spring data

Question

I am using JDBCTemplate in my existing project and want to switch to Spring-Data. Is there anyway by which I can use native sql as is using spring data jdbc extension without using QueryDSL pattern?

Secondly, Can Spring Data JPA help in this case?

Thanks

Community · Accepted Answer · 2017-05-23 12:07:26Z

2

If I understood right, you want to use Spring Data JPA to execute native SQL.

Assuming you have integrated Spring Data JPA in your project and are using Repositories that implement Spring Data JPA interfaces, you can simply define a method in your repository and annotate it as below :

    @Query(value = "select * from table", nativeQuery = true)
    public void executeMyQuery();

Please look at this to externalize your queries :

How to store @Query sql in external file for CrudRepository?

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Jan 13, 2015 at 20:12

souser

7982 gold badges9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1045445 Over a year ago

I appreciate. I was looking for Spring Data JDBC extension specifically since I am using complex queries (stored in prop/xml file) and jdbc extension suits my solution. Will this work with JDBC extension too?

Collectives™ on Stack Overflow

Executing Native SQL using Spring data

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related