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/


Reply via email to