Re: Persistent Database connections

2001-09-14 Thread Perrin Harkins
> 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

Persistent Database connections

2001-09-14 Thread Flavio D' Amore
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. T

Re: Persistent Database connections to Oracle

2001-09-14 Thread Stas Bekman
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

Re: Persistent Database connections to Oracle

2001-09-13 Thread Medi Montaseri
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) (R

Re: Persistent Database connections to Oracle

2001-09-13 Thread Stas Bekman
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? http://perl.apache.org

Persistent Database connections to Oracle

2001-09-13 Thread Flavio D' Amore
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' Amor

Re: Persistent database connections

2000-07-10 Thread Richard Dice
> 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 pe

Persistent database connections

2000-07-10 Thread Brian Leech
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 refere