On Jul 28, 2008, at 10:58 PM, Sébastien Escudier wrote: > Quoting Dan : >> Post the test program and somebody will tell you. > > ok, you can find my test source here : > http://cjoint.com/data/hCr0WHZYHf.htm > and create test.bdd with : CREATE TABLE test(test INTEGER); > > I have this output : > ./base_test > sqlite version : 3.5.9 > threadsafe = 1 > DEBUG : sleep after begin exclusive > R thread ok > > W thread ok > write done > DEBUG : end sleep after begin exclusive > > But I expected to have "write done" after "end sleep"
Both of your threads are using the same database handle, no? Executing a "BEGIN EXCLUSIVE" would lock out a second database handle. The database lock is a property of the database handle, not the thread from which the "BEGIN EXCLUSIVE" happened to be executed. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
