PERL Programming - DBI not disconnecting

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DBI not disconnecting

rafgar

2005-05-17, 1:22 am

I'm building a chat room and having a problem with the MySQL interface not letting go of a connection no matter how many disconnect instructions we give it. The DBI connection line looks like this:

$dbh = DBI->connect($dbi_dsn, $dbi_user, $dbi_password, { AutoCommit => 1, RaiseError => 1, PrintError => 1 });

I've tried setting the AutoCommit to 0, but that just broke everything. I'm not real great with Perl and I haven't been able to figure out which of the hundreds of DBI connections is refusing to close, though I think I've narrowed it down to just over a dozen. Can anyone give me some advice on how to fix this?

Sponsored Links