2009/3/19 marcos rebelo <ole...@gmail.com>: > Hi all > > I'm a Perl programmer (not a complete beginer) using SQLite. > > I want to retry to execute every command automatically, until the DB > is not locked. In C seems that I need to set the busy_handler. > > How do I do this with DBD in Perl? > > Thanks for any help > > Best Regards > Marcos Rebelo >
There is a private function with DBD::SQLite to set the timeout. I know that's not the same thing but it might help. See here for details: http://search.cpan.org/~msergeant/DBD-SQLite-1.14/lib/DBD/SQLite.pm#$dbh-%3Efunc(_$ms,_%27busy_timeout%27_) Failing that, I imagine you will have to put the command within a loop and sleep if it's un-successful. Good luck, Dp. -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/