Java Topics
Transaction Management
Last Updated : 26 May, 2026
title: Transaction Management in JDBC
title: Transaction Management in JDBC description: JDBC mein transactions handle karna
Group of operations — ya sab hoon, ya koi nahi (Atomicity).
Default: Auto-commit ON
Har statement automatically commit hota hai. Transaction ke liye off karo.
Transaction Example
Connection conn = null;
try {
conn = DBConfig.getConnection();
conn.setAutoCommit(false); // Transaction start
// Operation 1: Withdraw from account A
PreparedStatement ps1 = conn.prepareStatement(
"UPDATE accounts SET balance = balance - ? WHERE id = ?");
ps1.setDouble(1, 1000);
ps1.setInt(2, 1);
ps1.executeUpdate();
// Operation 2: Deposit to account B
PreparedStatement ps2 = conn.prepareStatement(
"UPDATE accounts SET balance = balance + ? WHERE id = ?");
ps2.setDouble(1, 1000);
ps2.setInt(2, 2);
ps2.executeUpdate();
conn.commit(); // Dono operation successful — commit
System.out.println("Transfer successful!");
} catch (SQLException e) {
if (conn != null) {
try {
conn.rollback(); // Koi bhi fail — rollback sab
System.out.println("Transaction rolled back");
} catch (SQLException ex) { ex.printStackTrace(); }
}
e.printStackTrace();
} finally {
if (conn != null) conn.setAutoCommit(true); // Reset
}Savepoints
conn.setAutoCommit(false);
Savepoint sp1 = conn.setSavepoint("SP1");
// Some operations...
Savepoint sp2 = conn.setSavepoint("SP2");
// More operations...
conn.rollback(sp2); // SP2 tak rollback (SP1 ke baad wali operations undo)
conn.commit();
conn.releaseSavepoint(sp1);Isolation Levels
conn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); // Most common
// READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, SERIALIZABLEExam Focus
Revise definitions, diagrams, examples, and short-answer points for Transaction Management.
Interview Use
Prepare one clear explanation, one practical example, and one common mistake for this Java topic.
Search Terms
java, java programming, core java, java master course, java notes, master, course, jdbc
Related Java Topics