tags:

views:

28

answers:

1
Q: 

How to selectively start and end a persistent Apache::DBI for perl from the client/browser?

This question is related to our web-based application, which uses perl, apache, Apache::DBI and a database (MySQL, SQLite, or anything).

We know that Apache::DBI is used to create persistent db connections. These connections live in memory from the time the Apache web server starts to the time it shuts down.

My Question is: Is it possible to create persistent db connections at any arbitrary time between the start and end of Apache process? We don't want to have persistent connections throughout the life of the Apache web server process.

We need to create persistent connections any time after the Apache web server is started. And we need to end persistent connections any time before the Apache web server is shut down.

A: 
benzebuth  2010-07-29 07:28:38
Hi Benzebuth, I think your solution will not create a persistent connection that can be available for few requests and responses between server and client. I think the solution should involve Apache::DBI.
Vijey  2010-07-29 07:46:49
well... i think it does, if you use mod_perl and load the module at apache startup.but i might be wrong
benzebuth  2010-07-29 07:50:06
i'll run some test on my side. Tell you later how it works
benzebuth  2010-07-29 07:56:46
after investigating a bit, i found out that in the "solution" i gave, the db connection lives not throught the whole srever life, but through threads life. ie : some users may share some apache threads, thus sharing db connection. but where the thread is down (off), so is the db connection.
benzebuth  2010-07-29 11:05:59

related questions

Regex to replace Boolean with bool
How do I lock a file in Perl?
How do you use XML::Parser with Style => 'Objects'
Parsing XML Elements & Attributes with Perl
Regex to match all HTML tags except <p> and </p>
Best way to extract data from a FileMaker Pro database in a script?
What's the fastest way to determine a full URL from a relative URL (given a base URL).
Why can't I connect to my CAS server with Perl's AuthCAS?
Why can't I fetch wikipedia pages with LWP::Simple?
How do I perform a Perl substitution on a string while keeping the original?
How do I read in the contents of a directory in Perl?
How can Perl's system() print the command that it's running?
How can I test STDIN without blocking in Perl?
How do I tell if a variable has a numeric value in Perl?
Why doesn't my Perl map return anything?
How can I determine the type of a blessed reference in Perl?
Parsing attributes with regex in Perl
How do you retrieve selected text using Regex in C#?
Why does the Perl conditional operator not do what I expect?
Class::DBI-like library for php?
How do you create objects in Perl?
How do I remove duplicate items from an array in Perl?
Is The Perl Journal available online?
Can you force either a scalar or array ref to be an array in Perl?
What's the safest way to iterate through the keys of a Perl hash?