SQLite - 'database is locked'

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
yeohray
Posts: 56
Joined: Mon 26 Mar 2007 01:25

SQLite - 'database is locked'

Post by yeohray » Fri 28 Jan 2011 17:16

I have 2 apps that access the same SQLite database. If only 1 app is running, there are no problems reading and updating data. If both apps are running, there are no problems reading data, but neither app can update data. Unidac simply reports that the 'database is locked'.

I understand that SQLite would serialize the update requests, so that both updates should succeed. Are there any special settings to enable this?

Thanks in advance.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Mon 31 Jan 2011 08:31

Hello,

Thank you for the information.
We know about this problem.
We plan to resolve it in the next version.

yeohray
Posts: 56
Joined: Mon 26 Mar 2007 01:25

Post by yeohray » Mon 31 Jan 2011 11:50

Thanks for the info.

Any rough estimate on when the next version will be released? I need to know this to decide if I should look at using another database engine.

Thanks.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Mon 31 Jan 2011 12:08

Hello,

We plan to release the next version next month.

Post Reply