SQL, commit, rollback
Normally, all SQL-commands are carried out immediatly. If you want to avoid this, „AutoCommit“ must be turned off explicitly:
try { // turn off AutoCommit: connection.setAutoCommit(false); // put down divers SQL-commands... // Until here everything has worked out, so now commit: connection.commit(); } catch (SQLException e) { // Something went wrong, so revoke everything: connection.rollback(); }