On 2002.12.13 08:08:53 -0500 carlosga01 <carlosga@...> wrote:

> Hello:
>
>
> I see the last changes on isc_rollback_transaction for make a better
> handling of exceptions and transaction state, i applied it to the gds
> implementation of the .net provider, and i think this can be applied
> to isc_commit_transaction too, i´m rigth??.
>

I don't think so. Can you be more specific about what you are proposing?

Once we try to rollback once, there is nothing more we can do with the
transaction, ever, no matter if we got an exception or not. But if we try
to commit and fail, there are several possibilities:

connection has failed, we can't do anything more.

Work done at commit time (DDL) failed, we should roll back the transaction
(maybe)

Something else went wrong and we want to try to fix it.

I dont' think it is the responsibility of the gds layer to decide what to
do to try to recover from an exception during commit. The code I just
added puts the logic for this in ManagedConnection and
ManagedConnectionFactory. In particular, it tries to figure out if the
connection is still usable, and closes it if not.

So, please explain what you are proposing in more detail.

thanks
david jencks

>
>
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>