MANAGING DATABASE TRANSACTIONS

Understanding transactions

Understanding transactions Application programmers benefit from developing their applications on platforms such as Java 2Enterprise Edition (J2EE) that support transactions. A transaction-based system simplifies application development because it frees the developer from the complex issues of failure recovery and multi-user programming. Transactions are not limited to single databases or single sites. Distributed transactions can simultaneously update multiple databases …

Understanding transactions Read More »

Committing a Transaction

Committing a Transaction When you set the auto-commit mode to false, the operation perfomed by SQL statements are not reflected permanently in a database. You need to explicitly call the commit() method of the Connection interface to reflect the changes made by the transactions in the database. All the SQL statements that appear between two commit() methods are treated as a …

Committing a Transaction Read More »