problem running trigger through J2EE application
hi,
i have a unique problem running trigger.
i have 2 triggers attached to 2 different tables.
on insert / update of each row in table-1, a trigger is fired to update value in table-2. Again on update of a row in table-2 trigger is fired to update a value in table-3.
The problem is, if i have 'n' number of rows to update, it works only for 'n-1' rows. The problem is only through the J2EE application. if the same table is updated through regular UPDATE command, the trigger is working perfectly.
If any one have come across this kind of situation please help.
Thanks in advance.
i have a unique problem running trigger.
i have 2 triggers attached to 2 different tables.
on insert / update of each row in table-1, a trigger is fired to update value in table-2. Again on update of a row in table-2 trigger is fired to update a value in table-3.
The problem is, if i have 'n' number of rows to update, it works only for 'n-1' rows. The problem is only through the J2EE application. if the same table is updated through regular UPDATE command, the trigger is working perfectly.
If any one have come across this kind of situation please help.
Thanks in advance.