[yunqa.de] Re: What are the best practices to avoid "SQLite Error 5 - database is locked"
- From: Edwin Yip <edwin.yip@xxxxxxxxxxxxxxxxxx>
- To: yunqa@xxxxxxxxxxxxx
- Date: Wed, 25 Feb 2009 16:01:47 +0800
Thank you Ralf,
I've take advantage of the sqlite3_busy_timeout function with a 10000 ms
parameter, I have done it before sending this question to the list, but I
was not quite sure that will solve the problem completely so I did send this
question here. So it seems that's enough ;-)
Best Regards,
Edwin Yip
Mind Mapping is as Effortless as Typing
http://www.InnovationGear.com
On Wed, Feb 25, 2009 at 3:56 PM, Delphi Inspiration <delphi@xxxxxxxx> wrote:
> Edwin Yip wrote:
>
> >I got an error "SQLite Error 5 - database is locked". Would you advise
> what are the best practice or guideline to avoid this kind of locking error?
> Thank you.
>
> DISQLite3 Help -> SQLite Documentation -> Locking & Concurrency
> DISQLite3 Help -> SQLite Documentation -> Atomic Commit
>
> Please also look up these functions in the help's index:
>
> sqlite3_busy_handler
> sqlite3_busy_timeout
>
> Ralf
>
> _______________________________________________
> Delphi Inspiration mailing list
> yunqa@xxxxxxxxxxxxx
> //www.freelists.org/list/yunqa
>
>
>
>
Other related posts:
