MySQL connection read remote commit
lazarus / 16-Databases

----------------------------------------------------------------------
xinyiman · 2019-11-29 07:28

Hello everybody. I have a small problem with the standard components
of lazarus for connecting to MySQL. Example of the problem:
I have two clients (client A and client B) that access the same table
on the database.
If I make a change to "Client A" then I do Query.ApplyUdates; and
Transaction.CommitRetaing; and then on the "Client B" I close and
reopen the query I don't see the updated result. I think it's an
isolation level problem so I don't read remote commits. But how do I
fix it?

----------------------------------------------------------------------
valdir.marcos · 2019-11-30 07:29

Quote from: xinyiman on November 29, 2019, 08:28:58 amHello everybody.
I have a small problem with the standard components of lazarus for
connecting to MySQL. Example of the problem:
I have two clients (client A and client B) that access the same table
on the database.
If I make a change to "Client A" then I do Query.ApplyUdates; and
Transaction.CommitRetaing;Use Commit instead of CommitRetaing.
Quoteand then on the "Client B" I close and reopen the query I don't
see the updated result.On "Client B", try commit [close] and reopen.
QuoteI think it's an isolation level problem so I don't read remote
commits. But how do I fix it?Transactions have numbers.
B must have a bigger number than A, so B can see what A did before,
that's why you must commit B and reopen to see what A did before.

----------------------------------------------------------------------
dogriz · 2019-12-01 11:12

Quote from: xinyiman on November 29, 2019, 08:28:58 amIf I make a
change to "Client A" then I do Query.ApplyUdates; and
Transaction.CommitRetaing; and then on the "Client B" I close and
reopen the query I don't see the updated result.
Closing and opening Client B Query is not enough. Close and open B
transaction too.