On Mon, Apr 24, 2023 at 8:37 AM Siddharth Jain <siddhsql@gmail.com> 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.