Page 1 of 1

Autocommit in UniConnection

Posted: Thu 23 Mar 2017 13:05
by MrBlues
Hallo,
we are using MariaDB with Unidac Components 6.4.14 with Delphi 10 Seattle. The database option Autocommit is set to off. Now I want to set the Auticommit to ON for my Application. So I set the Option Autocommit in the UniConnection to true. But if I try to update a table the changes don't take place. I thought this option overides the autocommit setting for this Connection?
How it is possible to set the autocommit for a defined Connection.

Re: Autocommit in UniConnection

Posted: Mon 03 Apr 2017 10:25
by ViktorV
When working with MariaDB (MySQL) server the TUniConnection.AutoCommit property is not used. To solve the issue you can execute the following code:

Code: Select all

  UniConnection.ExecSQL('SET autocommit = 1');