Dear sqlite family

hi, how are you~??

 

I want to set up a table locing mode.

 

So.. I put sqlite3_enable_shared_cache(1) on main function code of shell.c ,
then compiled , then excuted two sqlite shell processor.

 

First shell processor set write_transaction

(ex, begin; insert into table1 values('1','2'); .... no commit, continuous
transaction statt)

 

and then one other shell processor tried write_transaction.

(ex, insert into table2 values('1','2'); )

 

However, result is error massage "database is locked".

 

Exactly, table locking mode is usable in shared cache mode, with sqlite
document ( http://www.sqlite.org/sharedcache.html )

 

What is the problem??

 

What i'm not enough for setting locking mode??

 

Please, answer my question.

 

Thanks~ be happy!!

 

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to