On Mon, Apr 24, 2023 at 8:37 AM Siddharth Jain <siddhsql@xxxxxxxxx> wrote:
Hi All,i understand when writing application code, we should rollback a transaction that fails to commit. this is typically done in the catch block of a try-catch exception handler. but what if the developer does not rollback the transaction? what happens in that case?note that i am not asking: what happens if a transaction is not rolled back?i am asking: what happens if a failed transaction is not rolled back?failed transaction = you try to commit it but get an exception back from the database.
There isn't anything special about a failed transaction compared to any other transaction that you leave open.
Might help to describe what the application does with the connection subsequent to the point of attempted commit.
David J.
