Good morning!
Where is mistake?
my $dbh=DBI->connect("DBI:$driver:$database:$hostname",$user,$pass,{AutoCommit=>0});
my $sth=$dbh->prepare(q{
insert into
test.Pokus
(a,b)
values
(?,?)
});
foreach my $a ("a","b","c","d") {
$sth->execute($a,$a);
}
$dbh->commit;
$dbh->disconnect;
Perl error:
Transactions not supported by database at /usr/lib/perl5/5.6/i386-linux/DBI.pm line 433
I use:
Debian GNU/Linux sid (i386)
MySQL 3.23.31
DBI 1.14
BDB::mysql 1.2215
table Pokus is BerkeleyDB type
Thanks for your answer.
Bye
Marek
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php