ALTER TRANSACTION RULE

Description

The ALTER TRANSACTION RULE syntax is used to alter transaction rule configuration.

Syntax

Grammar Railroad diagram

  1. AlterTransactionRule ::=
  2. 'ALTER' 'TRANSACTION' 'RULE' '(' 'DEFAULT' '=' defaultTransactionType ',' 'TYPE' '(' 'NAME' '=' transactionManager ',' propertiesDefinition ')' ')'
  3. propertiesDefinition ::=
  4. 'PROPERTIES' '(' key '=' value (',' key '=' value)* ')'
  5. defaultTransactionType ::=
  6. string
  7. transactionManager ::=
  8. string
  9. key ::=
  10. string
  11. value ::=
  12. literal

Supplement

  • defaultTransactionType support LOCAL, XA, BASE

  • transactionManager support Atomikos, Narayana and Bitronix

Example

  • Alter transaction rule
  1. ALTER TRANSACTION RULE(
  2. DEFAULT="XA", TYPE(NAME="Narayana", PROPERTIES("databaseName"="jbossts", "host"="127.0.0.1"))
  3. );

Reserved word

ALTER, TRANSACTION, RULE, DEFAULT, TYPE, NAME, PROPERTIES