Recent

Author Topic: [SOLVED] MySQL Isolation Levels  (Read 1448 times)

Pascal

  • Hero Member
  • *****
  • Posts: 932
[SOLVED] MySQL Isolation Levels
« on: March 08, 2021, 09:10:51 am »
How do i set the MySQL isolation level to "READ COMMITTED"?

I tried
Code: Pascal  [Select][+][-]
  1. ExecuteDirect('SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;');
with no luck.

What is the correct way to do this?

Pascal
« Last Edit: March 08, 2021, 04:15:28 pm by Pascal »
laz trunk x64 - fpc trunk i386 (cross x64) - Windows 10 Pro x64 (21H2)

Pascal

  • Hero Member
  • *****
  • Posts: 932
Re: MySQL Isolation Levels
« Reply #1 on: March 08, 2021, 09:15:03 am »
I know, that i can use
Code: Pascal  [Select][+][-]
  1. Transaction.Active := False;
But i would like to not use this.
laz trunk x64 - fpc trunk i386 (cross x64) - Windows 10 Pro x64 (21H2)

Pascal

  • Hero Member
  • *****
  • Posts: 932
Re: MySQL Isolation Levels
« Reply #2 on: March 08, 2021, 04:15:15 pm »
Code: Pascal  [Select][+][-]
  1. ExecuteDirect('SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;');
  2. Transaction.Commit;

Commit was missing!
laz trunk x64 - fpc trunk i386 (cross x64) - Windows 10 Pro x64 (21H2)

 

TinyPortal © 2005-2018