Pass SQL statement to JPA @Query

Question

Is there a way to pass the whole sql statement or a part of it to @Query annotation?

@Modifying
@Query(value = "INSERT INTO my_table :query", nativeQuery = true)
@Transactional
void test(@Param("query") String query);

You can't execute INSERT that way. But what's your use case? — Simon Martinelli
– Simon Martinelli, Commented Aug 5, 2022 at 11:53
I need to make UPSERT into PostgreSQL. And some fields can be NULL in DAO, which cause error on inserting into column of some types, for instance, BIGINT and TIMESTAMP — meridbt
– meridbt, Commented Aug 5, 2022 at 11:57

Mihael Mihov · Accepted Answer · 2022-08-05 12:46:06Z

1

I think a viable option for you would be to use the entity manager, instead of the repository. You can do it using NativeQuery and its executeUpdate method. Please check:

Inserting in my JPA using entity manager native query

answered Aug 5, 2022 at 12:46

Mihael Mihov

1616 bronze badges

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

Collectives™ on Stack Overflow

Pass SQL statement to JPA @Query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related