Page 1 of 1

LAZARUS FIREBIRD REFRSH PROBLEM

Posted: 03.06.2013, 17:58
by k1attila1
I have the same problem but with ZEOS :

http://80.123.225.56/index.php?topic=17110.0

An another concurent user can't see my changes if i use REPEATABLE
READ isolaion level.

He push the refresh button and can't see my changes.

(don't work sqlquery.refresh and close and open)

Maybe this isn't ZEOS problem.
I don't know.

Sorry, if it isn't ZEOS problem.

Thanks, in advance.

Posted: 04.06.2013, 18:19
by marsupilami
Hello k1attila1,

please try to set the isolation level to read committed.
Best regards,

Jan

Posted: 04.06.2013, 20:22
by k1attila1
Thanks Marsupilami !

But then i have an another problem. (refresh is OK !)

I have "lost update" problem :


T1 start

T2 start
T2 commit
T1 commit


T1 transaction overwrite T2, and T2 update lost. (This is not problem with higher isolation level : REPEATABLE READ - I get an POST ERROR error message. )

What can i do, how can i detect it.

Maybe with ZIBEVENTALERTER component ?

Thanks

Attila Kov?cs