Hello,
I continue to have database is locked errors when running an application
which accesses a SQLite dabase on a network.
I have tried many of the connection string options: pooling, changing default
time out.
I just recently tried a block of code which does a BeginTransaction and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/10/2014 09:41 AM, Mike McWhinney wrote:
Please let know if there are any other solutions to this database
locking problem as used on a network.
Yes. Do not do it. See the FAQ:
https://www.sqlite.org/faq.html#q5
Roger
-BEGIN PGP
So SQLite shouldn't be used at all on a network? Aren't there any other
provisions to handled the locking errors if/when
they occur?
On Monday, November 10, 2014 12:10 PM, Roger Binns rog...@rogerbinns.com
wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/10/2014 09:41 AM,
On 2014/11/10 20:22, Mike McWhinney wrote:
So SQLite shouldn't be used at all on a network? Aren't there any other
provisions to handled the locking errors if/when
they occur?
It is not about SQLite, it is about the Networking systems lying about whether a file is locked or not. No RDBMS
On 10 Nov 2014, at 6:22pm, Mike McWhinney elja...@sbcglobal.net wrote:
So SQLite shouldn't be used at all on a network?
SQLite is not designed for hosting a database on a server for access by lots of
different computers at the same time. To do that efficiently you need a
client/server
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/10/2014 10:22 AM, Mike McWhinney wrote:
So SQLite shouldn't be used at all on a network? Aren't there any
other provisions to handled the locking errors if/when they occur?
Network filesystems do not implement locking and other operations
On 10 Nov 2014 at 18:22, Mike McWhinney elja...@sbcglobal.net wrote:
So SQLite shouldn't be used at all on a network? Aren't there any other
provisions to handled the locking errors if/when
they occur?
You tried setting a timeout as pointed to here?
https://www.sqlite.org/faq.html#q5
I am using Sqlite.NET client in C#. How would I go about defining a sqlite busy
timeout handler?
Thanks
Mike
On Monday, November 10, 2014 1:35 PM, Tim Streater t...@clothears.org.uk
wrote:
On 10 Nov 2014 at 18:22, Mike McWhinney elja...@sbcglobal.net wrote:
So SQLite shouldn't be
On 2014-11-10 18:33, RSmith wrote:
snip
There is one Client-Server implementation of SQLite (SQLightening I
think) but it is neither free nor easy to convert to.
Doing some Googling, this looks like the thing:
http://sqlitening.com
They don't seem to sell it any more (last version was
On Mon, Nov 10, 2014 at 12:56 PM, jus...@postgresql.org wrote:
On 2014-11-10 18:33, RSmith wrote:
snip
There is one Client-Server implementation of SQLite (SQLightening I
think) but it is neither free nor easy to convert to.
Doing some Googling, this looks like the thing:
On 10 Nov 2014 at 19:38, Mike McWhinney elja...@sbcglobal.net wrote:
I am using Sqlite.NET client in C#. How would I go about defining a sqlite
busy timeout handler?
Is the API not documented somewhere (I don't know what Sqlite.NET client or C#
are, so can't help)? Surely you must have some
On Mon, Nov 10, 2014 at 12:56 PM, jus...@postgresql.org wrote:
On 2014-11-10 18:33, RSmith wrote:
snip
There is one Client-Server implementation of SQLite (SQLightening I
think) but it is neither free nor easy to convert to.
Doing some Googling, this looks like the thing:
On Mon, 10 Nov 2014 20:33:04 +0200
RSmith rsm...@rsweb.co.za wrote:
On 2014/11/10 20:22, Mike McWhinney wrote:
So SQLite shouldn't be used at all on a network? Aren't there any
other provisions to handled the locking errors if/when they occur?
It is not about SQLite, it is about the
13 matches
Mail list logo