java jdbc insert fire a trigger in oracle db

Question

suppose that

i make an insert into a table using Java Jdbc
the insert fire a trigger

java waits that the trigger finish the execution or it continue the execution??

(using oracle 11g)

if it dose continue without wait, there i way to wait the end of the trigger execution?

Justin Cave · Accepted Answer · 2012-10-22 14:05:00Z

1

The INSERT statement is not complete until all the triggers that need to fire have fired and run to completion. It doesn't matter what front-end language you use to issue the INSERT statement, the INSERT must always wait for the triggers to complete.

answered Oct 22, 2012 at 14:05

Justin Cave

233k25 gold badges378 silver badges395 bronze badges

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

Comments

Mukul Goel · Accepted Answer · 2012-10-22 14:11:35Z

0

Even If a INSERT calls N NUMBER OF TRIGGER, First all the TRIGGERS will complete execution while the INSERT will wait, and then it will come back to INSERT

that is logical as well, if I am firing some triggers before inserting into a database than I would want them to complete before inserting.

The JAVA wont move to next statement until the INSERT statement responds and it wont respond until it has completed execution and it will not complete execution until All Triggers that are Triggered are completed.

answered Oct 22, 2012 at 14:11

Mukul Goel

8,4836 gold badges42 silver badges77 bronze badges

Collectives™ on Stack Overflow

java jdbc insert fire a trigger in oracle db

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related