|
FW: DBI/DBD won't recognize transaction support: msg#00001db.mysql.perl
> 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> |
|---|---|---|
| Previous by Date: | DBD::mysql failing commit test for transactions: 00001, Michael Muratet US-Huntsville |
|---|---|
| Next by Date: | Re: FW: DBI/DBD won't recognize transaction support: 00001, Patrick Galbraith |
| Previous by Thread: | DBD::mysql failing commit test for transactionsi: 00001, Michael Muratet US-Huntsville |
| Next by Thread: | Re: FW: DBI/DBD won't recognize transaction support: 00001, Patrick Galbraith |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |