TRANSACTION MANAGEMENT USING JDBC

Question 1

What is a transaction and give examples of transactions

Answer 1

• Transaction represents a single unit of work
• Examples:
• In case of an ATM: Check balance, Withdraw
• In case of Database management: Update a table’s field data,
Add data item to a table in the DB

Question 2

Describe the ACID properties of Transaction Management

Answer 2

• Atomicity means either all successful or none.
• Consistency ensures bringing the database from one consistent state to
another consistent state.
• Isolation ensures that transaction is isolated from other transaction.
• Durability means once a transaction has been committed, it will remain so,
even in the event of errors, power loss etc.

Question 3

What is the advantage of transaction management

Answer 3

• Fast performance
• TM makes the performance fast because database is hit at the time of
commit.

Question 4

What are the methods provided by the connection interface to manage transactions

Answer 4

void setAutoCommit(boolean status)- True by default means each transaction is committed by default

void commit()- commits the transaction

void rollback()- cancels the transaction

Question 5

Draw a diagram representing the transaction model

Answer 5

*See notes for pic

Question 6

Write code for the implementation of JDBC Transaction Management using Statement

Answer 6

*See notes for pic