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

Michael Muratet US-Huntsville wrote:

Michael,

I can't get this to fail. What sort of error does this throw?

Thanks!

Patrick
>> 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
>>
>>     
>
>   


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]