The way to allow two or more statements to be grouped into a transaction is to disable the auto-commit mode. Be prepared for Tech Support to ask you to temporarily switch back to the bundled. In almost all cases, however, a statement is completed, and therefore committed, right after it is executed.) A statement is completed when all of its result sets and update counts have been retrieved. (To be more precise, the default is for a SQL statement to be committed when it is completed, not when it is executed. This means that each individual SQL statement is treated as a transaction and is automatically committed right after it is executed. When a connection is created, it is in auto-commit mode.

Using Transactions to Preserve Data Integrity.

A transaction is a set of one or more statements that is executed as a unit, so either all of the statements are executed, or none of the statements is executed. The way to be sure that either both actions occur or neither action occurs is to use a transaction. However, the amount sold per week and the total amount sold should be updated at the same time otherwise, the data will be inconsistent.

For example, when the proprietor of The Coffee Break updates the amount of coffee sold each week, the proprietor will also want to update the total amount sold to date. There are times when you do not want one statement to take effect unless another one completes.

Roll back java update