On Wed, 2004-12-15 at 14:14 -0500, [EMAIL PROTECTED] wrote: > I use Class::DBI to connect to several databases from within mod_perl. > Occasionally a request will hang and there will be a slew of "attempt > to free unreferenced scalar" messages in the error_log. I am assuming > this is because of multiple processes connecting to multiple databases > at the same time via a single database handle.
No, you can't actually connect to multiple databases with one handle. This message might be caused by forking with an open database connection. > I think that part works properly, but the server will not start. I > think what is blowing up is when Class::DBI::mysql goes to load the > table info. Here is the error I get: > > configuring DB interface at /usr/local/app/Application/Data.pm line > 13. > in my db_Main at /usr/local/app/Application/DBI.pm line 9. > Syntax error on line 1230 of /usr/local/app/apache/conf/httpd.conf: > Can't locate object method "fetch_hash" via package "DBI::st" > at /usr/lib/perl5/site_perl/5.8.0/Class/DBI/mysql.pm line 65. This means that you are not supplying a database handle blessed into DBIx::ContextualFetch. Note this line in my example: RootClass => 'DBIx::ContextualFetch' You need the rest of the %db_options stuff from my example as well. - Perrin -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html