Hi Mateusz Be sure I've tried to execute `SET TRANSACTION...ISOLATION LEVEL...;`. It was the first thing I've done:))))))))) But the result is:
terminate called after throwing an instance of 'soci::firebird_soci_error' what(): invalid transaction handle (expecting explicit transaction start) Aborted (core dumped) Code fragment here: session sql(firebird, "service=/opt/firebird/examples/empbuild/employee.fdb user=SYSDBA password=masterkey"); sql.once << "SET TRANSACTION READ ONLY ISOLATION LEVEL SNAPSHOT NO WAIT"; <<<<<< Core dump on this line exactly. Maybe I'm doing smth wrong?.. Regards Yuri -----Original Message----- From: Mateusz Loskot [mailto:mate...@loskot.net] Sent: Friday, August 02, 2019 3:27 PM To: soci-users@lists.sourceforge.net Subject: [suspicious mail]Re: [soci-users] transaction isolation level On 19-08-02 11:57:47, Yuriy Nikolaev wrote: > >Can you please tell me if it's possible to set transaction isolation >level & maybe some other transaction properties like RW/RO etc. in SOCI? There is no dedicated database-agnostic interface, AFAIK. >I'm using FB backend if it makes any sense. Perhaps executing SQL command `SET TRANSACTION...ISOLATION LEVEL...;` will do the job, you'd have to try. Best regards, -- Mateusz Loskot, http://mateusz.loskot.net Fingerprint=C081 EA1B 4AFB 7C19 38BA 9C88 928D 7C2A BB2A C1F2 _______________________________________________ soci-users mailing list soci-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/soci-users _______________________________________________ soci-users mailing list soci-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/soci-users
