@ThreadSafe @Generated(value="com.amazonaws:aws-java-sdk-code-generator") public class AWSRDSDataClient extends AmazonWebServiceClient implements AWSRDSData
Amazon RDS provides an HTTP endpoint to run SQL statements on an Amazon Aurora Serverless DB cluster. To run these statements, you work with the Data Service API.
For more information about the Data Service API, see Using the Data API in the Amazon Aurora User Guide.
LOGGING_AWS_REQUEST_METRIC
ENDPOINT_PREFIX
Modifier and Type | Method and Description |
---|---|
BatchExecuteStatementResult |
batchExecuteStatement(BatchExecuteStatementRequest request)
Runs a batch SQL statement over an array of data.
|
BeginTransactionResult |
beginTransaction(BeginTransactionRequest request)
Starts a SQL transaction.
|
static AWSRDSDataClientBuilder |
builder() |
CommitTransactionResult |
commitTransaction(CommitTransactionRequest request)
Ends a SQL transaction started with the
BeginTransaction operation and commits the changes. |
ExecuteSqlResult |
executeSql(ExecuteSqlRequest request)
Deprecated.
|
ExecuteStatementResult |
executeStatement(ExecuteStatementRequest request)
Runs a SQL statement against a database.
|
ResponseMetadata |
getCachedResponseMetadata(AmazonWebServiceRequest request)
Returns additional metadata for a previously executed successful, request, typically used for debugging issues
where a service isn't acting as expected.
|
RollbackTransactionResult |
rollbackTransaction(RollbackTransactionRequest request)
Performs a rollback of a transaction.
|
void |
shutdown()
Shuts down this client object, releasing any resources that might be held
open.
|
addRequestHandler, addRequestHandler, configureRegion, getClientConfiguration, getEndpointPrefix, getMonitoringListeners, getRequestMetricsCollector, getServiceName, getSignerByURI, getSignerOverride, getSignerRegionOverride, getTimeOffset, makeImmutable, removeRequestHandler, removeRequestHandler, setEndpoint, setEndpoint, setRegion, setServiceNameIntern, setSignerRegionOverride, setTimeOffset, withEndpoint, withRegion, withRegion, withTimeOffset
public static AWSRDSDataClientBuilder builder()
public BatchExecuteStatementResult batchExecuteStatement(BatchExecuteStatementRequest request)
Runs a batch SQL statement over an array of data.
You can run bulk update and insert operations for multiple records using a DML statement with different parameter sets. Bulk operations can provide a significant performance improvement over individual insert and update operations.
If a call isn't part of a transaction because it doesn't include the transactionID
parameter,
changes that result from the call are committed automatically.
There isn't a fixed upper limit on the number of parameter sets. However, the maximum size of the HTTP request submitted through the Data API is 4 MiB. If the request exceeds this limit, the Data API returns an error and doesn't process the request. This 4-MiB limit includes the size of the HTTP headers and the JSON notation in the request. Thus, the number of parameter sets that you can include depends on a combination of factors, such as the size of the SQL statement and the size of each parameter set.
The response size limit is 1 MiB. If the call returns more than 1 MiB of response data, the call is terminated.
batchExecuteStatement
in interface AWSRDSData
batchExecuteStatementRequest
- The request parameters represent the input of a SQL statement over an array of data.AccessDeniedException
- You do not have sufficient access to perform this action.BadRequestException
- There is an error in the call or in a SQL statement.StatementTimeoutException
- The execution of the SQL statement timed out.InternalServerErrorException
- An internal error occurred.ForbiddenException
- There are insufficient privileges to make the call.ServiceUnavailableErrorException
- The service specified by the resourceArn
parameter is not available.public BeginTransactionResult beginTransaction(BeginTransactionRequest request)
Starts a SQL transaction.
<important> <p>A transaction can run for a maximum of 24 hours. A transaction is terminated and rolled back automatically after 24 hours.</p> <p>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.</p> <p>DDL statements inside a transaction cause an implicit commit. We recommend that you run each DDL statement in a separate <code>ExecuteStatement</code> call with <code>continueAfterTimeout</code> enabled.</p> </important>
beginTransaction
in interface AWSRDSData
beginTransactionRequest
- The request parameters represent the input of a request to start a SQL transaction.AccessDeniedException
- You do not have sufficient access to perform this action.BadRequestException
- There is an error in the call or in a SQL statement.StatementTimeoutException
- The execution of the SQL statement timed out.InternalServerErrorException
- An internal error occurred.ForbiddenException
- There are insufficient privileges to make the call.ServiceUnavailableErrorException
- The service specified by the resourceArn
parameter is not available.public CommitTransactionResult commitTransaction(CommitTransactionRequest request)
Ends a SQL transaction started with the BeginTransaction
operation and commits the changes.
commitTransaction
in interface AWSRDSData
commitTransactionRequest
- The request parameters represent the input of a commit transaction request.AccessDeniedException
- You do not have sufficient access to perform this action.BadRequestException
- There is an error in the call or in a SQL statement.StatementTimeoutException
- The execution of the SQL statement timed out.InternalServerErrorException
- An internal error occurred.ForbiddenException
- There are insufficient privileges to make the call.ServiceUnavailableErrorException
- The service specified by the resourceArn
parameter is not available.NotFoundException
- The resourceArn
, secretArn
, or transactionId
value can't be found.@Deprecated public ExecuteSqlResult executeSql(ExecuteSqlRequest request)
Runs one or more SQL statements.
This operation is deprecated. Use the BatchExecuteStatement
or ExecuteStatement
operation.
executeSql
in interface AWSRDSData
executeSqlRequest
- The request parameters represent the input of a request to run one or more SQL statements.AccessDeniedException
- You do not have sufficient access to perform this action.BadRequestException
- There is an error in the call or in a SQL statement.InternalServerErrorException
- An internal error occurred.ForbiddenException
- There are insufficient privileges to make the call.ServiceUnavailableErrorException
- The service specified by the resourceArn
parameter is not available.public ExecuteStatementResult executeStatement(ExecuteStatementRequest request)
Runs a SQL statement against a database.
If a call isn't part of a transaction because it doesn't include the transactionID
parameter,
changes that result from the call are committed automatically.
If the binary response data from the database is more than 1 MB, the call is terminated.
executeStatement
in interface AWSRDSData
executeStatementRequest
- The request parameters represent the input of a request to run a SQL statement against a database.AccessDeniedException
- You do not have sufficient access to perform this action.BadRequestException
- There is an error in the call or in a SQL statement.StatementTimeoutException
- The execution of the SQL statement timed out.InternalServerErrorException
- An internal error occurred.ForbiddenException
- There are insufficient privileges to make the call.ServiceUnavailableErrorException
- The service specified by the resourceArn
parameter is not available.public RollbackTransactionResult rollbackTransaction(RollbackTransactionRequest request)
Performs a rollback of a transaction. Rolling back a transaction cancels its changes.
rollbackTransaction
in interface AWSRDSData
rollbackTransactionRequest
- The request parameters represent the input of a request to perform a rollback of a transaction.AccessDeniedException
- You do not have sufficient access to perform this action.BadRequestException
- There is an error in the call or in a SQL statement.StatementTimeoutException
- The execution of the SQL statement timed out.InternalServerErrorException
- An internal error occurred.ForbiddenException
- There are insufficient privileges to make the call.ServiceUnavailableErrorException
- The service specified by the resourceArn
parameter is not available.NotFoundException
- The resourceArn
, secretArn
, or transactionId
value can't be found.public ResponseMetadata getCachedResponseMetadata(AmazonWebServiceRequest request)
Response metadata is only cached for a limited period of time, so if you need to access this extra diagnostic information for an executed request, you should use this method to retrieve it as soon as possible after executing the request.
getCachedResponseMetadata
in interface AWSRDSData
request
- The originally executed requestpublic void shutdown()
AmazonWebServiceClient
shutdown
in interface AWSRDSData
shutdown
in class AmazonWebServiceClient