Apache::DBI questions

["Kelvin Wu" <suppressed>]

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.