best you can hope for is nice panic message and application termination.
I don't think so. The user can decide after an error to switch to a second database or store all values in an emergency file for later restore into database.
I think it would not be amiss if Commit, Rollback and ... has a return value.