CmdID / aws / aws rds-data
aws rds-data commit-transaction
Ends a SQL transaction started with the BeginTransaction operation and commits the changes. AWS CLI reference
1 example 3 options Its page in the AWS CLI reference
Examples
To commit a SQL transaction
The following commit-transaction example ends the specified SQL transaction and commits the changes that you made as part of it.
aws rds-data commit-transaction --resource-arn "arn:aws:rds:us-west-2:123456789012:cluster:mydbcluster" --secret-arn "arn:aws:secretsmanager:us-west-2:123456789012:secret:mysecret" --transaction-id "ABC1234567890xyz"Identify--resource-arnThe Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.--secret-arnThe name or ARN of the secret that enables access to the DB cluster.--transaction-idThe identifier of the transaction to end and commit.Its output
{
"transactionStatus": "Transaction Committed"
}For more information, see Using the Data API for Aurora Serverless in the Amazon RDS User Guide.
Options
--resource-arnThe Amazon Resource Name (ARN) of the Aurora Serverless DB cluster.--secret-arnThe name or ARN of the secret that enables access to the DB cluster.--transaction-idThe identifier of the transaction to end and commit.