Are there DBD drivers for mysql with transactions (4.0.1)?

[svar]

.... here is what I get:
...
DBD driver has not implemented the AutoCommit attribute at perlscript.pl line 1064, <IN> line 12911.
Issuing rollback() for database handle being DESTROY'd without explicit disconnect(), <IN> line 12911

Thanks,
svar

 

[tviman]

Have you looked in CPAN? There's always a better way...

 

[svar]

I tried on a simpler piece of code and looks like this
is not the problem(or rather the problem may be a misleading diagnostic from DBI). I mean I get the simpler script to run fine, for instance

foreach my $i(@array){
$dbh->{AutoCommit}=0;
eval{
$dbh->insert($i);
$dbh->commit();
};
$dbh->{AutoCommit}=1;
}

this runs fine, so the diagnostic message is wrong

svar