Commit Status After Failure

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 Received on Fri Jul 25 2003 - 01:05:31 CEST