On Sep 14, 2009, at 1:35 PM, <purushotham.kotapa...@nokia.com> wrote:
> Hi, > Any help to the below problem is of great help. Please check if this happens with 3.6.18. I think these issues may be fixed now. Dan. > Regards, > Reddy > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org > ] On Behalf Of Kotapalle Purushotham (Nokia-D/Bangalore) > Sent: Tuesday, September 08, 2009 12:57 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] First "SELECT" query fails > > Hi, > I am using SqLite DB as a message Queue for data share between 2 > process. > I create a table in one process(say A) and then subcribe another > process(say B) to extract data from the table everytime entry is > added. > Creating the table and subcribing is successful. > However, there is a problem when trying to extract the an entry for > the very first time form the table. Complete problem is as described > below: > > - process A creates the table T, process B subcribes to entry > events(like add) of table T. > - process A adds an entry to table T, using "INSERT INTO..." command > - process B catches this event and tries to extract the data from > table T, using "SELECT *..." query. But the command fails with > following error : > "no such table: responseQ Unable to execute statement" > - however, subsequent entries added by process A are handled > successfully by process B. > > Since, I am simulating a "message queue" model, with this issue, one > of the messages will remain in the queue(table) unused. > I tried to execute commit db and finish the sql query after creating > table, but was not helpful to solve this issue. > > Pls help me to find a solution to this problem. > > Regards, > Reddy > > > _______________________________________________ > 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
