Re: Error handling for auto-reconnect?



Are you talking about $dbh->{Statement} ?
If you want full transactional integrity and you've been sending multiple statements within the transaction, you could overload execute() and track every time there's an "open tran" or "commit" in the statement. Anything in between, you store in an array of statements so when there's an error you rerun all of them.


Steven Lembark wrote:

Is there any way to restart the failed transaction from
within the HandleError sub? I cannot find anything in the DBI doc's that allows me to tell what the last op
on the dbh was.


thanx


.