RobertoN

Well, this is the problem. I want it not try do commit it anyway, if I do not commit, so when close I need it try rollback. Note that because this, when admin shutdown the server it try commit on all connections inTrasaction, but imagine one accounting aplication... it will try commit when must be rollback. I resolved it using MyDAC, but if is possible one solution with FireDAC I would like to know. Very thanks all.

The problem is FireDAC with the config NOT in auto-commit mode, it is doing commit when close... I dont work with autocommit = true, it is always autommit = false.

Hello ppl ! I changed from FireDAC to DEVART MyDAC because this problem I didin't find solution... Ex.: (TFDConnection X MySQL) UniMainModule.FDConnection.Open; UniMainModule.FDConnection.StartTransaction; UniMainModule.FDConnection.ExecSQL('INSERT INTO test(mystr) VALUES (''xxxxxx'');'); UniMainModule.FDConnection.ExecSQL('INSERT INTO test(mystr) VALUES (''yyyyy'');'); UniMainModule.FDConnection.Close; //I closed without do the commit, but at this moment commit occurs on database !??? //I think if FDConnection.inTransaction so onClose must be Rollback, but Commit happens !? With TMyConnection all works fine... Well, but what is the solution to FireDAC ? The commit occurs when shutdown too, but this is very wrong .... Roberto