Name
sql_transact — get list of available DSNs
Synopsis
sql_transact
(
|
in dsn_name varchar , |
in
rollback
integer
) ; |
Description
This procedure can be used to control the commit/rollback behavior of a particular remote data source during a Virtuoso transaction such as in a stored procedure.
Under normal circumstances Virtuoso will correctly commit or
rollback all associated work as expected, however it may be desirable
intervene. When issued without the second parameter a commit will be
forced upon the current transactions of the dsn_name above
the call to sql_transact
regardless
of overall outcome. When rollback = 1 is set then a rollback will be forced
likewise, hence this will not rollback work on the remote dsn_name prior
to
sql_transact
.
Parameters
dsn_name
The name of the data source being used on the remote.
rollback
Activate the desired behavior. Set to 1 for rollback, ignore to commit.
Return Types
None.
Examples
Example 24.401. Control remote rollback/commit behavior
This code fragment can be used to demonstrate the effects of directly controlling the rollback/commit behavior of remote data sources connected to Virtuoso.
create procedure TEST_ROLLBACK () { commit work; insert into mydsn..rb_test values (1); sql_transact('mydsn'); insert into mydsn..rb_test values (2); rollback work; }; create procedure TEST_ROLLBACK () { commit work; insert into mydsn..rb_test values (1); sql_transact('mydsn', 1); insert into mydsn..rb_test values (2); commit work; }; delete from mydsn..rb_test; commit work; TEST_COMMIT(); select MIN (ID) from mydsn..rb_test; -- returns 1 delete from mydsn..rb_test; commit work; TEST_ROLLBACK(); select MIN (ID) from mydsn..rb_test; -- returns 2
See Also
sql_columns
sql_primary_keys
,
sql_gettypeinfo
,
sql_statistics
,
sql_tables
.