Commit Status After Failure

From: Joseph Berkley <joseph_berkley_at_yahoo.com>
Date: 24 Jul 2003 16:05:31 -0700
Message-ID: <d857a6c7.0307241505.b21abde@posting.google.com>

Hi!

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 Thu Jul 24 2003 - 18:05:31 CDT