> How to write and read the same sqlite3 DB in memory concurrently in two
> thread?
You need to use one connection (sqlite3 object) and not to use
SQLITE_OPEN_NOMUTEX flag (assuming you used default SQLite compilation
options) or protect access to sqlite3 object with your own mutex.
Pavel
On Fri, May 25, 2012 at 4:51 AM, 吴 毅 <wuyiy...@yahoo.com.cn> wrote:
> Now I am writing datas to sqlite3 DB in memory(":memory:") in a thread .
> And concurrently I want to read the datas of the same DB in memory too.
> but While i used the same object of sqlite3 to write and read, i had got the
> error:SQLITE_MISUSE.
> If i use the different objects of sqlite3 to write and read
> concurrently,these objects get the different DB in memory.This is not I want
> to do.I want to get datas of the same database.
> Moreover, I don't plan to write and read the database in disks too.Becase I
> thick it's more faster to operate in memory.
> I open the database in the way of "m_sqliteDB.open(":memory:");" now.
>
> How to write and read the same sqlite3 DB in memory concurrently in two
> thread?
>
> That might be?
>
> thank you.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
