RE: Class::DBI -- connect_cached?

[prev] [thread] [next] [Date index for 2004/07/23]

Is there any way to get rid of these warnings in my server's error log?

<error>
Issuing rollback() for database handle being DESTROY'd without explicit
disconnect() at
/usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi/DBI.pm line 1322.
</error>

They seem to happen a lot.  I have a test script which makes 561 requests to
a hod_perl handler on the server, requesting the same record over and over.

Is there some way I can call disconnect() on my database connection?


Thanks!
John 

 

-----Original Message-----
From: Edward J. Sabol [mailto:sabol@xxxxxxxx.xxxx.xxxx.xxx] 
Sent: Friday, July 23, 2004 11:34 AM
To: john.drago@xxxxxxxxxx.xxx
Cc: cdbi-talk@xxxxxx.xxxxx.xxx
Subject: Re: Class::DBI -- connect_cached?

> We have 1 server running several websites under 1 instance of Apache,
> each website with its own database. Each website will be using the same
> CDBI classes (Contact, User, Product, etc) to interact with their
> databases.

Class::DBI has always used DBI->connect_cached() for its DBI connections. If
you're using mod_perl though, you really want to use Apache::DBI's
connection
caching instead. Recent versions of DBI use Apache::DBI automatically for
DBI->connect_cached(). So just make sure you have Apache::DBI installed plus
a recent (within ~6 months) version of DBI.