Thanks a lot Perrin, i will follow your recomendations... i've used the global
variable for the database handler for simplicity and to avoid the local
declaration and the method call, but i see the point in your advice.
I will debug the code with more detail.
Hans
On Fri, 07 May 2004 18:16:48 -0
On Fri, 2004-05-07 at 17:03, Hans Poo R. wrote:
> Fosis::handler is the main Dispatcher of the dynamic content. It can use the
> database handler via a Global variable $dbh
It's not a good practice to put a database handle in a global.
Apache::DBI does it, but it also pings the handle before usin
Perrin
I have an InitHandler in a Files section (in order to promote perl i put this
extension to the files).
PerlInitHandler General::init_dbk
SetHandler perl-script
PerlHandler Fosis
Fosis::handler is the main Dispatcher of the dynamic content. It can use the
database handler
On Thu, 2004-05-06 at 12:42, Hans Poo R. wrote:
> I removed the manual rollback and let the job to Apache::DBI, the problem is
> that after the change, the message about the handle destroyed still appears in
> the log. I activated the $Apache::DBI::DEBUG variable, but the message persist
> (now wit
Hi Perrin
I removed the manual rollback and let the job to Apache::DBI, the problem is
that after the change, the message about the handle destroyed still appears in
the log. I activated the $Apache::DBI::DEBUG variable, but the message persist
(now with the DEBUG information).
Issuing rollback()
On Wed, 2004-05-05 at 13:01, Hans Poo R. wrote:
> I want to know, if it's necessary to rollback database connections on each
> request arrive with a PerlInitHandler, when using persistent database connections.
Apache::DBI already does that for you in a cleanup handler. You are
using Apache::DBI,
Hi all
I'am using mod_perl-1.27, apache 1.3.28, Linux RedHat 9 and postgresql 7.4.2.
I want to know, if it's necessary to rollback database connections on each
request arrive with a PerlInitHandler, when using persistent database connections.
This is the way i'am doing now (rolling back manually
