Purpose

Specifies how the driver handles manual transactions.

Valid Values

ignore | noTransactions

Behavior

If set to ignore, the data source does not support transactions and 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 READ UNCOMMITTED transaction isolation level.

If set to noTransactions, the data source and the driver do not support transactions. Metadata indicates that the driver does not support transactions.

Notes

Spark SQL does not support transactions, and by default, the driver reports that transactions are not supported. However, some applications will not operate with a driver that reports transactions are not supported. The TransactionMode connection property allows you to configure the driver to report that it supports transactions. In this mode, the driver ignores requests to enter manual commit mode, start a transaction, or commit a transaction. Requests to rollback a transaction return an error regardless of the transaction mode specified.

Default

noTransactions

Data Type

String