Enum AutocommitDmlMode (6.83.0)

public enum AutocommitDmlMode extends Enum<AutocommitDmlMode>

Enum used to define the behavior of DML statements in autocommit mode

Static Fields

Name Description
PARTITIONED_NON_ATOMIC

PARTITIONED_NON_ATOMIC: DML statements use a Partitioned DML transaction.

TRANSACTIONAL

TRANSACTIONAL: DML statements use a standard atomic transaction.

TRANSACTIONAL_WITH_FALLBACK_TO_PARTITIONED_NON_ATOMIC

TRANSACTIONAL_WITH_FALLBACK_TO_PARTITIONED_NON_ATOMIC: DML statements are first executed with a standard atomic transaction. If that fails due to the mutation limit being exceeded, the statement will automatically be retried using a Partitioned DML transaction. These statements are not guaranteed to be atomic. The corresponding TransactionRetryListener methods will be invoked when a DML statement falls back to Partitioned DML.

Static Methods

Name Description
valueOf(String name)
values()

Methods

Name Description
getStatementString()

Use this method to get the correct format for use in a SQL statement. Autocommit dml mode must be wrapped between single quotes in SQL statements: SET AUTOCOMMIT_DML_MODE='TRANSACTIONAL' This method returns the value without the single quotes.