Skip to content

Starts a SQL transaction

Description

Starts a SQL transaction.

A transaction can run for a maximum of 24 hours. A transaction is terminated and rolled back automatically after 24 hours.

A transaction times out if no calls use its transaction ID in three minutes. If a transaction times out before it's committed, it's rolled back automatically.

For Aurora MySQL, DDL statements inside a transaction cause an implicit commit. We recommend that you run each MySQL DDL statement in a separate execute_statement call with continueAfterTimeout enabled.

Usage

rdsdataservice_begin_transaction(resourceArn, secretArn, database,
  schema)

Arguments

  • resourceArn

    [required] The Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.

  • secretArn

    [required] The name or ARN of the secret that enables access to the DB cluster.

  • database

    The name of the database.

  • schema

    The name of the database schema.

Value

A list with the following syntax:

list(
  transactionId = "string"
)

Request syntax

svc$begin_transaction(
  resourceArn = "string",
  secretArn = "string",
  database = "string",
  schema = "string"
)