CommitTransaction - RDS Data API

CommitTransaction

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

Request Syntax

POST /CommitTransaction HTTP/1.1 Content-type: application/json { "resourceArn": "string", "secretArn": "string", "transactionId": "string" }

URI Request Parameters

The request does not use any URI parameters.

Request Body

The request accepts the following data in JSON format.

resourceArn

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

Type: String

Length Constraints: Minimum length of 11. Maximum length of 100.

Required: Yes

secretArn

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

Type: String

Length Constraints: Minimum length of 11. Maximum length of 100.

Required: Yes

transactionId

The identifier of the transaction to end and commit.

Type: String

Length Constraints: Minimum length of 0. Maximum length of 192.

Required: Yes

Response Syntax

HTTP/1.1 200 Content-type: application/json { "transactionStatus": "string" }

Response Elements

If the action is successful, the service sends back an HTTP 200 response.

The following data is returned in JSON format by the service.

transactionStatus

The status of the commit operation.

Type: String

Length Constraints: Minimum length of 0. Maximum length of 128.

Errors

AccessDeniedException

You don't have sufficient access to perform this action.

HTTP Status Code: 403

BadRequestException

There is an error in the call or in a SQL statement. (This error only appears in calls from Aurora Serverless v1 databases.)

HTTP Status Code: 400

DatabaseErrorException

There was an error in processing the SQL statement.

HTTP Status Code: 400

DatabaseNotFoundException

The DB cluster doesn't have a DB instance.

HTTP Status Code: 404

DatabaseUnavailableException

The writer instance in the DB cluster isn't available.

HTTP Status Code: 504

ForbiddenException

There are insufficient privileges to make the call.

HTTP Status Code: 403

HttpEndpointNotEnabledException

The HTTP endpoint for using RDS Data API isn't enabled for the DB cluster.

HTTP Status Code: 400

InternalServerErrorException

An internal error occurred.

HTTP Status Code: 500

InvalidSecretException

The Secrets Manager secret used with the request isn't valid.

HTTP Status Code: 400

NotFoundException

The resourceArn, secretArn, or transactionId value can't be found.

HTTP Status Code: 404

SecretsErrorException

There was a problem with the Secrets Manager secret used with the request, caused by one of the following conditions:

  • RDS Data API timed out retrieving the secret.

  • The secret provided wasn't found.

  • The secret couldn't be decrypted.

HTTP Status Code: 400

ServiceUnavailableError

The service specified by the resourceArn parameter isn't available.

HTTP Status Code: 503

StatementTimeoutException

The execution of the SQL statement timed out.

HTTP Status Code: 400

TransactionNotFoundException

The transaction ID wasn't found.

HTTP Status Code: 404

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: