On Thu, 13 Sep 2001, Medi Montaseri wrote:
I have a related question
How do I confirm that I indeed have a persistent database connection...
I have modified my httpd.conf via PerlRequire /path/startup.pl
with debuging at level 2...I see the following in my httpd error_log
[Thu Sep 13
Hi,
Im very near to the solution of my problem, but there's still a
thing
that's not working properly.
Before running my perl script (f1.pl) i see five httpd@hostname sessions
in Oracle V$session but at the moment in which i run f1.pl there appear a
seventh session alone such f1.pl@hostname.
Before running my perl script (f1.pl) i see five httpd@hostname sessions
in
Oracle V$session but at the moment in which i run f1.pl there appear a
seventh session alone such f1.pl@hostname.
The mechanism of persistent connections seems to be not workinkg properly.
What is it that makes you
Hi!
How can i configure the startup.pl in order to use a global symbol such
as
$lda =
Apache::DBI-connect_on_init(... including a persistent
database connection to Oracle that's could be shared by other perl
scripts?
Thanks a lot
best regards
---
Fl@vio D' Amore
On Thu, 13 Sep 2001, Flavio D' Amore wrote:
Hi!
How can i configure the startup.pl in order to use a global symbol such as
$lda = Apache::DBI-connect_on_init(... including a persistent database
connection to Oracle that's could be shared by other perl scripts?
I have a related question
How do I confirm that I indeed have a persistent database connection...
I have modified my httpd.conf via PerlRequire /path/startup.pl
with debuging at level 2...I see the following in my httpd error_log
[Thu Sep 13 22:11:34 2001] [notice] Apache/1.3.12 (Unix)
I'm using Apache::DBI to maintain persistent db connections using
mod_perl. To test this, I'm using a simple script like:
use strict;
print "Content-type: text/html\n\n";
print DBI-connect( ...same connect args as connect_on_init... );
Everytime I reload the script, I get the same hash
Everytime I reload the script, I get the same hash reference (it has the
same address). I turned on DEBUG for Apache::DBI, and the requests are
definitely being served by different children, so shouldn't each one have
its own database handle?
Yes.
The speed gains of persistent database