Skip to content
DuckDB Extensions All extensions ADBC Scanner

Transactions functions in the ADBC Scanner DuckDB extension

Function category

Transactions

3 functions

Manual transaction control. Toggle autocommit, then commit or roll back explicitly.

adbc_commit

Scalar function Transactions
Signature
adbc_commit(connection_handle: BIGINT) → BOOLEAN
Arguments (Positional)
Argument connection_handle Type BIGINT Mode Positional Description
Description

Commit the current transaction on the connection. Pair with adbc_set_autocommit(false) for explicit transaction control.

1 Example 1 
SELECT adbc_commit(connection_handle);
Related functions

adbc_rollback

Scalar function Transactions
Signature
adbc_rollback(connection_handle: BIGINT) → BOOLEAN
Arguments (Positional)
Argument connection_handle Type BIGINT Mode Positional Description
Description

Roll back the current transaction.

1 Example 1 
SELECT adbc_rollback(connection_handle);
Related functions

adbc_set_autocommit

Scalar function Transactions
Signature
adbc_set_autocommit(connection_handle: BIGINT, enabled: BOOLEAN) → BOOLEAN
Arguments (Positional)
Argument connection_handle Type BIGINT Mode Positional Description
Argument enabled Type BOOLEAN Mode Positional Description
Description

Toggle autocommit mode. Pass false to start an explicit transaction; pair with adbc_commit / adbc_rollback.

1 Example 1 
SELECT adbc_set_autocommit(connection_handle, false);
2 Example 2 
SELECT adbc_set_autocommit(connection_handle, true);
Related functions