I have CGI script which uses normal DBI mysql calls(DBD, DBI::Mysql), I am tryint to port it to mod_perl2 and Apache::DBI.
1. Do I still need to use 'use Apache::DBI;' in my script (or in startup.pl) if I already set 'PerlModule Apache::DBI' in httpd.conf? 2. Will Apache::DBI work (caches and manages connections etc) if I dont change my CGI script DB calls but simply adding one line "use Apache::DBI"? 3. How to limit DB connections from script? Or number of connections simply equals to number of HTTPd? 4. By setting $Apache::DBI::DEBUG = 2; Where output goes to? 5. How many DB connections will be established by using Apache::DBI->connect_on_init()? 6. If I use Apache::DBI->connect_on_init() in startup.pl, will it take care of DBI->connect() in my script? eg, DBI->connect() wont actually create a new connection. 7. If I do NOT use Apache::DBI->connect_on_init() in startup.pl, will Apache::DBI still manage DBI->connect() in my script? eg, wont actually create a new connection if there is a free connection created by ex-DBI->connect() call. 8. Will $dbh->disconnect() simply be ignored by using Apache::DBI or, it will kill DB connection? Thanks for your help. -- Sent from my BlackBerry. Ignore the typos unless they're funny.
