I'd like to discourage you from using ServerAutoCommit with the datapump. No
concrete reason, it just seems like overkill to force the end of a
transaction on the server for each item it processes.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <lester@...>
To: "IBO" <IBObjects@yahoogroups.com>
Sent: Wednesday, November 14, 2001 8:24 AM
Subject: [IBO] Transaction on a Datapump


> I'm definitly getting near the bottom of problems on my
> remote systems.
>
> One of the rare problems I am getting is to do with a
> Datapump operation not completing. It is set up with
> ServerAutoCommit, but if the connection hickups during the
> transfer, it 'hangs'. I call Close() in a timeout, but it
> seems to need a Rollback() to allow the Close() to take
> place ( some of the time ). I should add that this appears
> to be IB version sensitive, as I have yet to see it on sites
> that now have FB running.
>
> So the questions:-
>
> 1/ Does the Datapump take control of the transaction with a
> StartTransaction and so would need a specific RollBack?
>
> 2/ What would cause the Close() to hang rather than dropping
> the connection to allow a reconnect if 1 is not the case?
>
>
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services