Lecture 16 - JDBC Part 2

Question 1

What are JDBC transactions?

Answer 1

• Transaction = more than one statement which must all succeed (or all fail) together
• If one fails, the system must reverse all previous actions
• Also can’t leave DB in inconsistent state halfway through a transaction
• COMMIT = complete transaction
• ROLLBACK = abort

Question 2

What is transaction management?

Answer 2

• Transactions are not explicitly opened and closed
• The connection has a state called AutoCommit mode
• if AutoCommit is true, then every statement is automatically committed
• if AutoCommit is false, then every statement is added to an ongoing transaction
• Default: true