Learn R Programming

paws.database (version 0.1.5)

rdsdataservice_begin_transaction: Starts a SQL transaction

Description

Starts a SQL transaction.

Usage

rdsdataservice_begin_transaction(database, resourceArn, schema,
  secretArn)

Arguments

database

The name of the database.

resourceArn

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

schema

The name of the database schema.

secretArn

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

Request syntax

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

Details

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.

DDL statements inside a transaction cause an implicit commit. We recommend that you run each DDL statement in a separate ExecuteStatement call with continueAfterTimeout enabled.