Hi, Basically I am doing the same query i.e. int ret = sqlite3_exec(m_ppDb, "begin transaction", &hwLMsqlite3TableCallback, &rs, &zErr);
int ret = sqlite3_exec(m_ppDb, "update users set name=\"something\"", &hwLMsqlite3TableCallback, &rs, &zErr); The second one return SQLITE_BUSY as expected (since begin transaction does no locking as per documentation of sqlite) Regards, Prakash Bande Altair Engg. Inc. Troy MI Ph: 248-614-2400 ext 489 Cell: 248-404-0292 -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Friday, November 12, 2010 4:57 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Busy handler not called > int ret = sqlite3_exec(m_ppDb, query.c_str(), &hwLMsqlite3TableCallback, &rs, > &zErr); > > I get SQLITE_BUSY and hwLMsqlite3BusyHandler is not getting called. What query do you use? Pavel On Fri, Nov 12, 2010 at 4:51 PM, Prakash Reddy Bande <praka...@altair.com> wrote: > Hi, > > I have set a busy handler. > > int ret = sqlite3_open(dbname.c_str(), &m_ppDb); > sqlite3_busy_handler(m_ppDb, &hwLMsqlite3BusyHandler, 0); > > However it is not getting called. Here is what I am doing: > 1. Using the sqlite3.exe run the following commands > begin transaction; > update users set name="hello" > > 2. Note I have not yet commited. > > From my program I call > > int ret = sqlite3_exec(m_ppDb, query.c_str(), &hwLMsqlite3TableCallback, &rs, > &zErr); > > I get SQLITE_BUSY and hwLMsqlite3BusyHandler is not getting called. > > I am using is 3.7.2 > > Regards, > > Prakash Bande > Altair Engg. Inc. > Troy MI > Ph: 248-614-2400 ext 489 > Cell: 248-404-0292 > > _______________________________________________ > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
