[Mono-dev] Mono.Data.Sqlite

Angel Marin anmar at anmar.eu.org
Sat Jul 5 06:34:58 EDT 2008

Anders Aagaard wrote:
> Every thread has it's own cloned SqliteConnection (during the creation of
> the thread I call MasterConnection.Clone (), and only use the referenced
> connection).  The exception happens instantly when two threads begin a
> transaction to the same database.

Last time I had to use sqlite on a multi-threaded environment tweaking
the busy_timeout connection string parameter did the trick. From mono docs:

'The busy_timeout parameter is implemented as a call to
sqlite(3)_busy_timeout. The default value is 0, which means to throw a
SqliteBusyException immediately if the database is locked.'

Though sadly there doesn't seem to be a similar parameter on 2.0 profile
sqlite assembly.

Angel Marin

More information about the Mono-devel-list mailing list