On Tue, 13 Dec 2005, Kevin A. McGrail wrote:
I'm having problems setting up the apache + mod_perl + Apache::DBI in order
to get persistent db connections.
I've added the following line in my httpd.conf:
PerlRequire /home/xxx/startup.pl
The persistent connection is one per child process so I don't know if your
test is correct. Try instead to write a quick perl script that connects to
the database, disconnects and connects/disconnects again.
That should definitely result in a persistent connection being used again.
Make sense?
I'm shocked that nobody mentioned Apache::DBI->connect_on_init()
See the Apache-DBI documentation.