JDBC - update many table on single submit

How to achieve a single value from web page to be updated/stored in many tables ?

rjk1203
Profile Answers by rjk1203 Questions by rjk1203
Oct 31st, 2011
6
6199

Showing Answers 1 - 6 of 6 Answers

G S

Nov 3rd, 2011

By using Transactions.

Every JDBC Driver will be able to perform Transactions. But its not recommended.

If we want to use out own Transactions we will set

con.setAutoCommit(false); and after executing the transactions we will execute con.commit();

sekhar

Mar 15th, 2012

To update data in multiple table using single click ,we can go with triggers in database.we have different types of triggers like after insert,after update,after delete.Better using triggers.