Perrin Harkins <[EMAIL PROTECTED]> wrote: > The prepare_cached() method he's using will check the statement handle > and prepare it again on the new connection if necessary.
Not with Apache::DBI, though. The reconnect happens underneath DBI, and you end up with the same $dbh, which thinks the prepared statement is still valid. It looks like it would work perfectly with connect_cached, which I hadn't known about, but now that I do, I'm all excited to change my code to use it instead of Apache::DBI. -- Jeremy | [EMAIL PROTECTED]