[ aws . rds-data ]

commit-transaction

Description

Ends a SQL transaction started with the BeginTransaction operation and commits the changes.

See also: AWS API Documentation

See ‘aws help’ for descriptions of global parameters.

Synopsis

  commit-transaction
--resource-arn <value>
--secret-arn <value>
--transaction-id <value>
[--cli-input-json | --cli-input-yaml]
[--generate-cli-skeleton <value>]
[--cli-auto-prompt <value>]

Options

--resource-arn (string)

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

--secret-arn (string)

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

--transaction-id (string)

The identifier of the transaction to end and commit.

--cli-input-json | --cli-input-yaml (string) Reads arguments from the JSON string provided. The JSON string follows the format provided by --generate-cli-skeleton. If other arguments are provided on the command line, those values will override the JSON-provided values. It is not possible to pass arbitrary binary values using a JSON-provided value as the string will be taken literally. This may not be specified along with --cli-input-yaml.

--generate-cli-skeleton (string) Prints a JSON skeleton to standard output without sending an API request. If provided with no value or the value input, prints a sample input JSON that can be used as an argument for --cli-input-json. Similarly, if provided yaml-input it will print a sample input YAML that can be used with --cli-input-yaml. If provided with the value output, it validates the command inputs and returns a sample output JSON for that command.

--cli-auto-prompt (boolean) Automatically prompt for CLI input parameters.

See ‘aws help’ for descriptions of global parameters.

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"

Output:

{
    "transactionStatus": "Transaction Committed"
}

For more information, see Using the Data API for Aurora Serverless in the Amazon RDS User Guide.

Output

transactionStatus -> (string)

The status of the commit operation.