skip to main content
Connection Option Descriptions : Transaction Error Behavior
  

Try DataDirect Drivers Now

Transaction Error Behavior

Attribute

TransactionErrorBehavior (TEB)

Purpose

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

Valid Values

0 | 1

Behavior

If set to 0 (Do Nothing), 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 1 (Rollback), 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

1 (Rollback)

GUI Tab

Advanced tab