How to insert into multiple table using JPA @Query only?

Question

I am using JPA @Query annotation . Want to insert into two table using simple oracle query in JPA. How can I achieve this .

Don't want to use begin clause . Want single query to insert into two table.

Don't want to used one to many or any relationship due to some restriction.

Please see this https://stackoverflow.com/questions/5178697/mysql-insert-into-multiple-tables-database-normalization Based on that answer, you cant. — JCompetence, Sep 24 '21 at 12:09
I think there is a misunderstanding. I meant that it will (not) work and I provided a stack overflow for why. For native sql, you need Begin — JCompetence, Sep 24 '21 at 13:15

score 0 · Answer 1 · answered Sep 24 '21 at 12:12

0

It depends: if you want to have two Entity classes or one mapped from two tables. In the second case you can do it by @SecondaryTable annotation, more about it you can find on baeldung

answered Sep 24 '21 at 12:12

paulonio

311
1
5

No paulonio , I want to achieve this using @Query annotation with normal sql due to some restriction in project. – Ganesh Java Sep 24 '21 at 13:11

score 0 · Answer 2 · answered Mar 07 '22 at 02:40

0

I handle this using join and one to many relationship . Thanks all for your support.

answered Mar 07 '22 at 02:40

Ganesh Java

37
2
9

How to insert into multiple table using JPA @Query only?

2 Answers2