Re: Error handling for auto-reconnect?

2006-01-26 Thread Steven Lembark
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 -- Steven Lembark [EMAIL PROTECTED] Systems Management Phone:

Re: Error handling for auto-reconnect?

2006-01-26 Thread Henri Asseily
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

Re: Error handling for auto-reconnect?

2006-01-26 Thread Steven Lembark
-- Henri Asseily [EMAIL PROTECTED] 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.