So it means we can have mor than one valid db handle? Thanks, Lloyd
----- Original Message ----- From: "Pavel Ivanov" <paiva...@gmail.com> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday, July 07, 2010 6:40 PM Subject: Re: [sqlite] sqlite3_step returns sqlite_busy >> one thread is preparing an "INSERT" statement (It returns SQLITE_OK), >> then it is executed using sqlite3_step. sqlite3_step returns an >> SQLITE_BUSY! Is there any possibility for this? > > Sure. Preparing INSERT statement doesn't acquire any "write" locks on > the database. It's executing the INSERT statement that acquires locks. > So if while executing statement finds that it can't get the locks then > sqlite3_step returns SQLITE_BUSY. And thread-safety is irrelevant > here. > > > Pavel > ______________________________________ Scanned and protected by Email scanner _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users