Re: Commit Status After Failure

You would have to check the change and see if it occurred. I've never heard of what you are trying to do.(pretty rare) Some products allow you to look in their logs and see if the transaction committed. (eg Oracle's log miner) Jim

"Joseph Berkley" <joseph_berkley_at_yahoo.com> wrote in message news:d857a6c7.0307241505.b21abde_at_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 Fri Jul 25 2003 - 03:41:12 CEST