Re: [sqlite] why SQLITE_BUSY when read the database
>Do The words mean that while one process is writing the database other >processes could not read the database at the same time? The reader fails since it cannot obtain SHARED lock required for reading. It cannot obtain that lock since the writer already managed to obtain PENDING or EXCLUSIVE lock. __ The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yahoo! Get it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] why SQLITE_BUSY when read the database
>Do The words mean that while one process is writing the database other >processes could not read the database at the same time? In short:: YES __ Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail. Click on Options in Mail and switch to New Mail today or register for free at http://mail.yahoo.ca ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] why SQLITE_BUSY when read the database
why SQLITE_BUSY when read the database My application suffered a problem that sqlite3_step(*) of SELECT returns SQLITE_BUSY. I know "Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however." from the sqlite3's faq in the link http://www.sqlite.org/faq.html#q5;. Do The words mean that while one process is writing the database other processes could not read the database at the same time? -- View this message in context: http://old.nabble.com/why-SQLITE_BUSY-when-read-the-database-tp27848863p27848863.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
