On Friday 04 November 2005 12:14 pm, Perrin Harkins wrote: > Apache::DBI checks the handle to make sure it is still connected before > handing it back to you. If it has been disconnected, a new connection > will be made.
Not always though. Something I've run into (but had problems tracking down the cause) is that if the db server is rebooted between requests, Apache::DBI can think it's still got a valid handle and the db doesn't. That's with DBD::Sybase, freetds and an MS-SQL server. The errors are about reusing a handle with pending results, but it only happens if the db server is rebooted (and this is MS-SQL so that happens fairly often). I'd expect MySQL to be saner, but I haven't tried it. -- "Ironically, Microsoft's efforts to deny interoperability of Windows with legitimate non-Microsoft applications have created an environment in which Microsoft's program interoperate efficiently only with Internet viruses," - Dan Geer, the CTO of @Stake
