Rollback Command

The rollback command issues a java.sql.Connection.rollback request, which rolls back (undoes) the currently active transaction and initiates a new transaction.

You should only use this command when auto-commit mode is disabled.

Usage Notes

In contrast to the  Rollback to Savepoint command, the Rollback command aborts the current transaction and starts a new one.

Examples

splice> autocommit off;
splice> INSERT INTO menu VALUES ('dessert', 'rhubarb pie', 4);
1 row inserted/updated/deleted
splice> SELECT * from menu;
COURSE    |ITEM                |PRICE
-----------------------------------------------
entree    |lamb chop           |14
dessert   |creme brulee        |7
appetizer |baby greens         |7
dessert   |rhubarb pie         |4

4 rows selected
splice> rollback;
splice> SELECT * FROM menu;
COURSE    |ITEM                |PRICE
-----------------------------------------------
entree    |lamb chop           |14
dessert   |creme brulee        |7
appetizer |baby greens         |7

3 rows selected
splice>