> Hello,
>
> If the client application abnormally disconnected (crashed), what
> happened to the app's open transaction?

this will result in a transaction in limbo - it has the same effect as a
rollback but it leaves more garbage for you to clean up.

>
> The same question also applies to a bad designed application, i.e.
> the application terminates normally but the app doesn't properly
> close the transaction with commit or rollback.
>
> Will the server automatically rollback the transaction in both
> scenario?
>

this depends on what component layer you use in your application. Most have
a default close action - and you can set it to either commit or rollback -
whichever suits your applciatopin best.

Alan

> Thanks,
> --
> Bambang