I have a program that uses Firebird 2.1. Most installation use the
embedded version so I prefer to stick with 2.1 since it does all I need.

I have a question about transactions: if I start a transaction, I add or
modify some data, then the program gets an exception and it crashes,
what happens to the transaction?

I was believing that if the program terminates without calling commit or
rollback, then the transaction is automatically rolled back.

Now a customer had a problem that can be explained if the transaction is
not rolled back, but the data changes remained in the database even if
commit was not called because the program crashed before calling it.

Can anybody explain if changed data in this situation remains in the
database of is it rolled back?

Thanks in advance

Fulvio Senore