Sorry Stas, here it's.
We are already using Apache::DBI->connect_on_init() and there are not many accesses
to the database at this point that concern more than one connection.
My startup.pl has
use Apache::DBI ();
use DBI ();
Apache::DBI->connect_on_init("DBI:DB2:supwbdev", "wkbtest", "proton", {RaiseError => 0, AutoCommit => 1});
Apache::DBI->connect_on_init("DBI:DB2:supwb", "wkbench", "electron", {RaiseError => 0, AutoCommit => 1});
Apache::DBI->connect_on_init("DBI:DB2:custwbdv", "custwbdv", "skunk18", {RaiseError => 0, AutoCommit => 1});
Apache::DBI->connect_on_init("DBI:DB2:custwb", "custwb", "ferret72", {RaiseError => 0, AutoCommit => 1});
#---------------------------------------------
# For BAP test - 5/8/03
Apache::DBI->connect_on_init("DBI:DB2:EPRODUCT", "db2inst1", "abc123", {RaiseError => 0, AutoCommit => 1});
Apache::DBI->connect_on_init("DBI:DB2:PROD_DEV", "ebtest", "gopher88", {RaiseError => 0, AutoCommit => 1});
Thanks,
Hulya
At 05:31 PM 5/6/2004, Stas Bekman wrote:
Hulya Gurer wrote:
Hello,
I have a new Solaris server that runs on Solaris 8 and has been upgraded to Perl 5.8.3, Apache 2.49,
mod_perl 1.99.13, and DB2 running as Database. When I start the apache server with startup.pl I get,
Database handle destroyed without explicit disconnect at /usr/local/lib/perl5/site_perl/5.8.3/Apache/DBI.pm line 146
error. I have searched on this a little bit and there are several different approaches from mod_perl to module versions.
Looks like the old issue of opening the connection in the parent process:
http://perl.apache.org/docs/1.0/guide/databases.html#Skipping_connection_cache_during_server_startup
Apache::DBI doc doesn't claim to be ported to 2.0, it only suggests that it may work or may not. I suppose that someone needs to port it.
--
__________________________________________________________________
Stas Bekman JAm_pH ------> Just Another mod_perl Hacker
http://stason.org/ mod_perl Guide ---> http://perl.apache.org
mailto:[EMAIL PROTECTED] http://use.perl.org http://apacheweek.com
http://modperlbook.org http://apache.org http://ticketmaster.com
