How to define transaction isolation level during connection

OCTweak writes “procedure TForm1.ConnectBtnClick(Sender: TObject);
begin
ZConnection.Properties.Clear;
ZConnection.HostName := ‘192.168.0.1’; // ip where Firebird is installed or leave blank if embed;
ZConnection.Database := ‘c:fibdatabasesTEST.FDB’;
ZConnection.User := ‘sysdba’;
ZConnection.Password := ‘masterkey’;
ZConnection.Properties.Add(‘codepage=ISO8859_1’);
ZConnection.TransactIsolationLevel := tiNone; // use ZDbcIntfs
// ==============================
// IMPORTANT
//The first element in every TPB must be the isc_tpb_version3 constant.
ZConnection.Properties.Add(‘isc_tpb_version3’);
// ==============================
ZConnection.Properties.Add(‘isc_tpb_concurrency’);
ZConnection.Properties.Add(‘isc_tpb_wait’);
ZConnection.Connect;
end;

This entry was posted in Code Hacks. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *