[SOLVED] MySQL Isolation Levels
lazarus / 16-Databases

----------------------------------------------------------------------
Pascal · 2021-03-08 08:10

How do i set the MySQL isolation level to "READ COMMITTED"?

I tried Code: Pascal  [Select][+][-]window.onload = function(){var x1
= document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
ExecuteDirect('SET SESSION TRANSACTION ISOLATION LEVEL READ
COMMITTED;');with no luck.

What is the correct way to do this?

Pascal

----------------------------------------------------------------------
Pascal · 2021-03-08 08:15

I know, that i can use Code: Pascal  [Select][+][-]window.onload =
function(){var x1 = document.getElementById("main_content_section");
if (x1) { var x = document.getElementsByClassName("geshi");for (var i
= 0; i Transaction.Active := False; But i would like to not use this.

----------------------------------------------------------------------
Pascal · 2021-03-08 15:15

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
ExecuteDirect('SET SESSION TRANSACTION ISOLATION LEVEL READ
COMMITTED;');Transaction.Commit;
Commit was missing!