On 11/5/05, Aaron Turner <[EMAIL PROTECTED]> wrote: > So I'm trying to track down a problem with my program which forks > needing both parent and children to have access to the database via > Class::DBI. The basic issue I'm having is that after the first child > exits, the parent's DBI connection seems to get mangled, because it > can no longer find the prepared statements created by Class::DBI. > [...] >
So, the DBI manual says words to the effect of "don't try reusing handles in child processes - it usually won't work", and your code seems to be demonstrating exactly that. Each process that needs to connect to a database needs to connect separately. -- Jonathan Leffler <[EMAIL PROTECTED]> #include <disclaimer.h> Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org "I don't suffer from insanity - I enjoy every minute of it."
