WOLFRAM

Wolfram Language & System Documentation Center
Wolfram Language Home Page »
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)Summary of the most common use cases

In[1]:=1
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-j5qpz

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:

In[2]:=2
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-8bqgua
Out[2]=2
In[3]:=3
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-i2y

Begin a transaction:

In[4]:=4
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-yqk

Insert data:

In[5]:=5
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-g6h
In[6]:=6
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-wrc

Roll back previous inserts:

In[7]:=7
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-nng9ue
In[8]:=8
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-lk8vj

Commit the transaction:

In[9]:=9
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-pmf

The table only contains data inserted after the rollback:

In[10]:=10
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-ujq
Out[10]=10

Begin another transaction:

In[11]:=11
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-tuh6ot

Insert data:

In[12]:=12
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-sgse5p

Create a savepoint:

In[13]:=13
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-texupz
Out[13]=13

Insert more data:

In[14]:=14
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-xrp2s

Roll back to the savepoint:

In[15]:=15
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-7vq4qr

Commit the transaction:

In[16]:=16
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-ct2vlx

The table only contains data inserted up to the savepoint:

In[17]:=17
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-of8r5l
Out[17]=17
In[18]:=18
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-uv3
In[19]:=19
✖
https://wolfram.com/xid/05i24xq0ahzlw4yfyhllxsp2-kzo