Begin Transaction

rdsdataservice_begin_transaction

R Documentation

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"
)