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);
Asked
Active
Viewed 465 times
0
meridbt
- 304
- 1
- 11
-
You can't execute INSERT that way. But what's your use case? – Simon Martinelli Aug 05 '22 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 Aug 05 '22 at 11:57
-
1But then you can not use JPA. Checkout the JdbcTemplate – Simon Martinelli Aug 05 '22 at 12:05
-
It's a pity. Thank you for your comment – meridbt Aug 05 '22 at 12:13
-
Why can't you simply use the Repository.save function? – Daniellllll Aug 05 '22 at 12:37
-
@Daniellllll, in short - I need concurrent save & update, which is not possible that way. – meridbt Aug 05 '22 at 13:17
1 Answers
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:
Mihael Mihov
- 61
- 5