ALTER TRANSACTION RULE
Description
The ALTER TRANSACTION RULE syntax is used to alter transaction rule configuration.
Syntax
AlterTransactionRule ::=
'ALTER' 'TRANSACTION' 'RULE' '(' 'DEFAULT' '=' defaultTransactionType (',' transactionProvider)? ')'
transactionProvider ::=
'TYPE' '(' 'NAME' '=' transactionManager (',' propertiesDefinition)? ')'
propertiesDefinition ::=
'PROPERTIES' '(' (key '=' value (',' key '=' value)*)? ')'
defaultTransactionType ::=
string
transactionManager ::=
string
key ::=
string
value ::=
literalSupplement
-
defaultTransactionTypesupportsLOCAL,XA,BASE -
transactionManagersupportsAtomikosandNarayana
Example
- Alter transaction rule
ALTER TRANSACTION RULE(
DEFAULT="XA", TYPE(NAME="Narayana")
);Reserved word
ALTER, TRANSACTION, RULE, DEFAULT, TYPE, NAME, PROPERTIES