MySQL Forums :: Transactions :: CR: add support of interactive transactions for webclients

The proposal would solve the following problem:

Each web-session should match to one MySQL Process/Thread/Connection.
The MySQL Process should be active until web-session is closed.
This behaviour is not supported by MySQL up to now.
Therefore at the moment the following scenario occurs:
-----------------------------------
first access from webclient to webserver and MySQL:
start transaction
select row for update
display data of row on webclient for interactive (manual) modification

:( webserver disconnects from MySQL -> MySQL Process terminates -> Transaction is rolled back :(

second access from webclient to webserver and MySQL:
update row
commit transaction
------------------------------------

With the CR it would be possible to change to the following scenario:
-----------------------------------
first access from webclient to webserver and MySQL:
start transaction
select row for update
display data of row on webclient for interactive (manual) modification

webserver disconnects from MySQL
-> MySQL Process does NOT terminate
-> Transaction is kept open

second access from webclient to webserver and MySQL:
connect to original MySQL Process (containing the open transaction)
update row
commit transaction
------------------------------------


Regards,
Herbert