Using spring data jpa how to execute a native sql query programmatically?

Question

I am aware about how spring data jpa allows using native queries.

@Query(
  value = "SELECT * FROM USERS u WHERE u.status = 1", 
  nativeQuery = true)
Collection<User> findAllActiveUsersNative();

Reference - https://www.baeldung.com/spring-data-jpa-query

But my interest here is, instead of using the SQL with @Query annotation, it is possible to execute the sql query programmatically (for example say how we do while using jdbc) and get result in to a dto or resultset.

I just want to explore above approach for cases where the query might be generated dynamically and may not be know at compile time.

I have seen sof posts, which suggests other approaches like QueryByExample and QueryDSL and i know using JPA Specification also this case can be addressed. And these are great and the right way of addressing dynamic query situation.

But in this Q, I am interested in knowing if SQL queries can be executed programmatically (not through @Query annotation). If yes, how? (some demo code will help)

Look at EntityManager#createNativeQuery and JdbcOperations#query methods — Nikolai Shevchenko
– Nikolai Shevchenko, Commented Feb 11, 2022 at 10:44

crizzis · Accepted Answer · 2022-02-11 11:07:14Z

2

Well, you can always write a repository extension, into which you can inject the EntityManager.

answered Feb 11, 2022 at 11:07

crizzis

10.8k2 gold badges32 silver badges54 bronze badges

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

1 Comment

joven Over a year ago

could you add any code examples so i can accept the answer ++1

Collectives™ on Stack Overflow

Using spring data jpa how to execute a native sql query programmatically?

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