11 Replies Latest reply on Apr 16, 2015 11:34 AM by Steve Sommers

    How can I manage CF hanging when waiting for release of a lock held by 2nd Application on same datasource?


      My CF application links to the MS SQL database of my accounting application.


      If a specific record is being edited in the accounting application and I try to update that specific record using the coldfusion application, the coldfusion system hangs until the accounting application releases the record.


      This is fine except the user in the accounting application may have left the editing screen open and the record may not be released for minutes or longer. Once this is the case the hanging coldfusion request creates further locks.


      How can I manage the situation so that I can send a message to the user that they cannot gain exclusive access to the record and so cannot update it until the record is free thus preventing the hanging situation which escalates the problem?