[Mono-dev] Mono.Data.Sqlite

[Ķaмȋļ ๏ Şκaļşκȋ]

Still, you need to use separate connection for each thread - it should
be a perfect use of
http://en.wikipedia.org/wiki/Thread-local_storage#C.23_and_other_.NET_languages

On Sat, Jul 5, 2008 at 12:34 PM, Angel Marin <anmar at anmar.eu.org> wrote:
> 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.
>
> Regards,
> --
> Angel Marin
> http://anmar.eu.org/
>
> _______________________________________________
> Mono-devel-list mailing list
> Mono-devel-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-devel-list
>



-- 
Kamil Skalski
http://nazgul.omega.pl