Does anyone know of any database product or an API which supports the
concept of an asynchronous commit status reporting? What I mean by
this is an ability to easily figure out whether or not the commit
acutally succeeded in spite of some failure.
For example, I have transaction I identified as X somehow. I go to
commit it. And before commit returned, I had a network outage or
server/client crash. Does any database support a way for me to then
come and efficiently ask the database if transaction X indeed
committed.
Obviously, if I know what was inside of transaction, I can go and
query the data. But I want to avoid this.
This does not sound like a difficult feature to implement, but I
wonder if anybody did.
Thanks,
Joseph