skip to main content
Reference : Connection Property Descriptions : TransactionErrorBehavior
  

TransactionErrorBehavior

Purpose

Determines how the driver handles errors that occur within a transaction. When an error occurs in a transaction, the Amazon Redshift server does not allow any operations on the connection except for rolling back the transaction.

Valid Values

none | RollbackTransaction

Behavior

If set to none, the driver does not roll back the transaction when an error occurs. The application must handle the error and roll back the transaction. Any operation on the statement other than a rollback results in an error.
If set to RollbackTransaction, the driver rolls back the transaction when an error occurs. In addition to the original error message, the driver posts an error message indicating that the transaction has been rolled back.

Default

RollbackTransaction

Data Type

String