Version: 23.2.6
Hello,
I have a page that connects to a BYOD (Bring Your Own Database) that is used to connect to Dynamics 365 (D365) for Financial reporting. It was found out that the connection to BYOD is not getting terminated when the transaction is completed. This is causing ORDS to hang.
After many days of troubleshooting the DBA found that if an explicit COMMIT was used to ensure the database transaction was terminated along with a custom Procedure to terminate the connection to BYOD all was good.
I thought that adding a Dynamic Action on Page Unload with the COMMIT and the Procedure would solve the issue. It didn't. There is a Dynamic Action event called ‘Page Unload’ that seemed to be exactly what I needed. Unfortunately, it's deprecated. I see that the replacement is ‘Window: beforeunload event’.
Would someone be able to help me with how to set up a PAGE UNLOAD process (Dynamic Action) or is there another way to do this?
Thanks,
Joe