WOLFRAM

Wolfram Language & System Documentation Center

SQLRollbackTransaction[conn]

terminates an SQL transaction.

SQLRollbackTransaction[conn,savepoint]

returns to an SQLSavepoint.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
See Also
Tech Notes
Related Guides
DatabaseLink`
DatabaseLink`

SQLRollbackTransaction

SQLRollbackTransaction[conn]

terminates an SQL transaction.

SQLRollbackTransaction[conn,savepoint]

returns to an SQLSavepoint.

Details and Options

  • To use SQLRollbackTransaction, you first need to load DatabaseLink using Needs["DatabaseLink`"].
  • A group of SQL commands grouped into a transaction will only take effect permanently when the transaction is committed. The transaction can be canceled or returned to a savepoint.

Examples

Basic Examples  (1)

Wolfram Language code: Needs["DatabaseLink`"]

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the "DatabaseLink`DatabaseExamples`" package, as described in Using the Example Databases.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection["demo"]
Wolfram Language code: SQLCreateTable[conn, SQLTable["TEST"], {SQLColumn["X", "DataTypeName" -> "Integer"], SQLColumn["Y", "DataTypeName" -> "Float"]}];

Begin a transaction:

Wolfram Language code: SQLBeginTransaction[conn]

Insert data:

Wolfram Language code: SQLInsert[conn, "TEST", {"X", "Y"}, {61, 80.3}];
Wolfram Language code: SQLInsert[conn, "TEST", {"X", "Y"}, {72, 5.5}];

Roll back previous inserts:

Wolfram Language code: SQLRollbackTransaction[conn]
Wolfram Language code: SQLInsert[conn, "TEST", {"X", "Y"}, {1, N@Pi}];

Commit the transaction:

Wolfram Language code: SQLCommitTransaction[conn]

The table only contains data inserted after the rollback:

Wolfram Language code: SQLSelect[conn, "TEST"]

Begin another transaction:

Wolfram Language code: SQLBeginTransaction[conn]

Insert data:

Wolfram Language code: SQLInsert[conn, "TEST", {"X", "Y"}, {61, 80.3}];

Create a savepoint:

Wolfram Language code: savepoint = SQLSetSavepoint[conn, "my savepoint"]

Insert more data:

Wolfram Language code: SQLInsert[conn, "TEST", {"X", "Y"}, {72, 5.5}];

Roll back to the savepoint:

Wolfram Language code: SQLRollbackTransaction[conn, savepoint]

Commit the transaction:

Wolfram Language code: SQLCommitTransaction[conn]

The table only contains data inserted up to the savepoint:

Wolfram Language code: SQLSelect[conn, "TEST"]
Wolfram Language code: SQLDropTable[conn, "TEST"];
Wolfram Language code: CloseSQLConnection[conn];