skip to main content
Configuring Hybrid Data Pipeline for JDBC : Connection properties reference : TransactionMode
  

Try Now

TransactionMode

Purpose

Specifies how the driver handles manual transactions.

Valid Values

ignore | noTransactions | transactions

Behavior

If set to ignore, the driver always operates in auto-commit mode. Calls to set the driver to manual commit mode and to commit transactions are ignored. Calls to rollback a transaction cause the driver to throw an exception indicating that no transaction is started. Metadata indicates that the driver supports transactions and the ReadUncommitted transaction isolation level.
If set to noTransactions, the driver does not support transactions. Metadata indicates that the driver does not support transactions. Calls to set the driver to manual commit mode, or to commit or rollback transactions, generates an exception.
If set to transactions, the data source and driver support manual transactions for supported data stores. Support for isolation levels depends on which backend data store is being used. If the data store does not support transactions (for example, Salesforce), then TransactionMode is switched to noTransactions.

Default

transactions

Data Type

String