Re: One more error with Apache::DBI

[Kevin A. McGrail]

I believe I had the same problem. 

It was related to my upgrade of mysql without recompiling a few things:
"After much research, I believe I have the problem fixed and I found the
problem to be two-fold:

First, I had a mysql_config for v3.23.57 in the path

Second, I had not updated by DBD for mySQL. Fixing the first allowed me to
compile and install the second."


Regards,
KAM

On Sat, Dec 17, 2005 at 04:00:40AM +0200, Nikolay Ananiev wrote:
This is a rare situation I accidentally ran across.
This is the test script:

#!perl -w
use strict;
use CGI;
use Apache::DBI;

my $q = CGI->new;
print $q->header();

my $dsn = 'dbi:mysql:test';

Apache::DBI->setPingTimeOut($dsn, 100);

my $dbh = DBI->connect($dsn, 'root', '',
  {
   AutoCommit=>1,
   PrintError=>0,
   RaiseError=>1
  });

print 'connected';

1;


Start it in your browser and right after that stop the Mysql server
and refresh your browser again. You'll get

[Sat Dec 17 03:56:05 2005] [error] DBD driver has not implemented the
AutoCommit attribute at C:/Sites/Perl/site/lib/Apache/DBI.pm line 250.\n

but DBD::mysql does implement AutoCommit.
go figure :)