Re: what happens if a failed transaction is not rolled back?

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

David J.