Purpose

Controls how the driver delimits the start of a local transaction.

Valid Values

implicit | explicit

Behavior

If set to implicit, the driver uses implicit transaction mode. This means that the database, not the driver, automatically starts a transaction when a transactionable statement is executed. Typically, implicit transaction mode is more efficient than explicit transaction mode because the driver does not have to send commands to start a transaction and a transaction is not started until it is needed. When TRUNCATE TABLE statements are used with implicit transaction mode, the database may roll back the transaction if an error occurs. If this occurs, use the explicit value for this property.

If set to explicit, the driver uses explicit transaction mode. This means that the driver, not the database starts a new transaction if the previous transaction was committed or rolled back.

Default

implicit

Data Type

String