Zeoslib Portal

perhaps tiserializable is very strict but I only have 2 instances and the operation is quite fast so that the other user does not notice anything.
tiReadCommitted should be sufficiently insulated in many other cases, right?

I was waiting to see the effects in production but now I can write it. The problem was solved by setting the ZConnection in autocommit true and transactionisolationlevel to tiSerializable, then you call explicitly StartTransaction and its commit or rollback. First however the connection was set to a...

Ok I tried the Zeos 7.2.1 rc, the problem remains. I tracked the sequence of transactions but I did not notice anything strange. I also tried, with the already open connection, to change from tiNone to tiSerializable and autocommit true and, after the transaction, to return to tiNone and autocommit ...

First, thank you. I try first with monitoring through TZSQLMonitor to try to understand what happens. Secondly, depending on what I find, I see code written with Zeos 6.6. I have a little 'afraid to upgrade to 7.2 at this time because I do not find different behaviors from the 6.6 that force me to t...

The situation is this. I have two client programs that connect to the same mysql db on a server. When I run an operation on a table in the following way ZCon.TransactIsolationlevel := tiSerializable; ZCon.AutoCommit := true; ZCon.StartTransaction; try ZQGeneral.Close; ZQGeneral.SQL.Clear; ZQGeneral....