All,
Sorry if this question sounds stupid.. but I am new to mod_perl and
Apache::DBI.. I have successfully installed Apache Server 1.3.12 and
mod_perl 1.24 and Apache::DBI 0.87 on Solaris 2.7.
And I have tested all successfully... But confusion arised when I
created a startup.pl file and tried to initiate DB connection in
startup.pl file using 'connect_on_init' from Apache::DBI
As I understood, if you have 'connect_on_init' in startup file, you have
preloaded DB handle when first request comes in. And you don't need to
open new db connection... But if I check the error_log file, I still
have entry saying something like following:
10803 Apache::DBI need ping: yes
10803 Apache::DBI new connect to
'DatabaseNameUsernamePasswordAutoCommit=1PrintError=1'
10803 Apache::DBI disconnect (overloaded)
And I will get this for first 4-5 request but after that each time I am
getting
10803 Apache::DBI need ping: yes
10803 Apache::DBI already connected to
'DatabaseNameUsernamePasswordAutoCommit=1PrintError=1'
10803 Apache::DBI disconnect (overloaded)
Why is that??? Shouldn't I supposed to get 'already connected to'
statement right from the first request????
And how many open connection can I have at the same time?? As per my
understood, for Apache::DBI connection pooling is based per server
process. So, I guess as many server process you have, you can have db
connection handle open at the same time.. AM I RIGHT HERE?
Please clear my doubts on this...
And thanks for your help ...
Niral
