[Melbourne-pm] DBI don't start transaction
scottp at dd.com.au
scottp at dd.com.au
Mon Jun 8 21:04:31 PDT 2009
Hey Guys
I have a basic database ($dbh) like this:
my $dbh = DBI->connect("dbi:SQLite:dbname=list.db',"","", { RaiseError => 1, AutoCommit => 0 });
I want to do an SQLite attach, which requires no transaction. But DBI automatically does a begin on a do or prepare if no begin was run. I can reconnect to the database withou AutoCommit => 1, do the attach, disconnect, reconnect with AutoCommit => 0, but that is a slow process.
Example of the error:
$dbh->do('ATTACH DATABASE "/path/to/other.db" as other');
error = "cannot ATTACH database within transaction(1) at dbdimp.c line 403 ..."
Does anyone know how I can do a "do" without a begin if AutoCommit is off?
Ta
Scott
--
http://scott.dd.com.au/
scottp at dd.com.au
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/melbourne-pm/attachments/20090608/a8c5e121/attachment.html>
More information about the Melbourne-pm
mailing list