Mailing-List: contact modperl-help@apache.org; run by ezmlm
Precedence: bulk
Message-Id: <5.0.2.1.2.20010405132306.021f4ca0@bugs.home.shadowstar.net>
Date: Thu, 05 Apr 2001 13:27:13 -0400
To: Tim Bunce <Tim.Bunce@ig.co.uk>
From: Alec Smith <alec@shadowstar.net>
Subject: Re: Problem with Apache::DBI
In-Reply-To: <20010405092440.E6109@ig.co.uk>
References: <5.0.2.1.2.20010404234516.022da700@bugs.home.shadowstar.net>
 <5.0.2.1.2.20010404234516.022da700@bugs.home.shadowstar.net>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

In my module I've got:

use DBI;
use Apache::DBI;
$db = DBI->connect('DBI:mysql:dbname', 'username', 'password', {RaiseError 
=> 1, AutoCommit => 1});

and in startup.pl:

use DBI;
use Apache::DBI;
Apache::DBI->connect_on_init('DBI:mysql:dbname', 'username', 
'password',{RaiseError => 1, AutoCommit => 1});

yet I'm still seeing the  error

Issuing rollback() for database handle being DESTROY'd without explicit 
disconnect() at /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 139.

in the logs.

Still lost,
Alec


At 09:24 AM 4/5/01 +0100, you wrote:
>You would only get that message if AutoCommit was off.
>It should not be off for DBD::mysql (since it doesn't yet support
>the transaction features of newer versions).
>
>Plus, disconnect doesn't do anything when using Apache::DBI
>(by design).
>
>Tim.
>
>On Wed, Apr 04, 2001 at 11:49:17PM -0400, Alec Smith wrote:
> > Issuing rollback() for database handle being DESTROY'd without explicit
> > disconnect() at /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm line 139.
> >
> > Using Apache::DBI 0.88+DBI 1.14+mod_perl 1.25+MySQL 3.23.36 I'm getting 
> the
> > above in my error_log and am not sure why. Any ideas? I do have a
> > $db->disconnect; line in my modules.
> >
> > Just a tad lost,
> > Alec