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 Sep 13

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.

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 you

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' Amore

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?

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)

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

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 persistent database