logo       

FW: DBI/DBD won't recognize transaction support: msg#00001

db.mysql.perl

Subject: FW: DBI/DBD won't recognize transaction support


> Greetings
>
> I am trying to get the perl interface to work for InnoDB tables on mysql v
> 5.0.21, perl 5.8.5, dbi 1.51, dbd 3.0004_1 on a Dell PowerEdge with quad
> dual-core Xeons running Redhat Enterprise v4. I can create an InnoDB table
> from the mysql command line, insert a row, see it's there, rollback, see the
> row is gone. But the simple script below fails:
>
> use DBI;
> my $user = 'root';
> my $pw = ;
> my $dbh = DBI->connect("DBI:mysql:database=test;host=127.0.0.1", $user, $pw,
> { AutoCommit => 0, RaiseError => 0 });
> die DBI::errstr unless $dbh;
> $dbh->disconnect;
>
> The DBI/DBD interface is working OK for other (non-InnoDB) scripts.
>
> DBI passes all it's tests except for those that complain about DBI::PurePerl.
> DBD passes all of its tests except the one that deals with transactions. Can
> anyone offer a suggestion how to isolate the problem? SHOW ENGINES indicates
> that InnoDB is indeed enabled and actions with InnoDB from the mysql command
> line work OK. Should I make InnoDB the default table type when I start the
> server? Am I simply hosed because of multi-threading?
>
> Thanks
>
> Mike
>
<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise