I have two connections with isolation level = 0. In the two connection I will update the same table row. The first connection with Transaction T1 update the table row and after of execute the update statement assign an EXCLUSIVE lock to this row. The second connection with Transaction T2 tried to update this table row, but when I execute the update satement it has to wait that T1 make a rollback or a commit.
Why is this behavior, if isolation level 0 is able to READ and MODIFY data no matter if it is committed/rollbacked/locked/not locked?
Am I in the correct way?
thanks
Jos� R�mulo El�as Contreras Ingeniero en Sistemas Computacionales Guadalajara, Jalisco Tel: (33) 3126-47-81 y 3126-48-13 Cel: (311) 910-50-59
_________________________________________________________________
�nete al mayor servicio mundial de correo electr�nico: http://www.hotmail.com
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
