By "breakdown in communications" you must mean lost data or incomplete results. That's probably the SQLITE_BUSY error you're probably running into and not handling. You'll stil hit the problem opening the database as read-only in the other cases. You can't do a query or a join when the database is busy. It could be busy writing or reading, either way. If you've got multiple clients hitting the database at the same time you need to handle all the error returns that can occur at every step of the way. If you could show us some of your code we'll be glad to point it out to you. See this thread where it was discussed quite a bit http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/2010-May/021263.html Michael D. Black Senior Scientist Northrop Grumman Mission Systems
________________________________ From: sqlite-users-boun...@sqlite.org on behalf of Sam Carleton Sent: Mon 5/17/2010 9:04 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] read only databases and in-memory databases On Mon, May 17, 2010 at 9:32 AM, Black, Michael (IS) <michael.bla...@ngc.com > wrote: > Well...you don't say what "problem" your customers are having. Would be > nice to know for us to help you. > At this point in time I am purely theorizing, the client is seeing a break down in communications between the Silverlight application and the Axis2/C Web Service. I am mentally going through things looking for wholes in my code. It dawned on me that there is this one case which is really a read-only call, but because of the temp table I open the DB as read/write. My goal is to only open the DB as read/write when I REALLY need to open it as read/write. In the case I described in the original post, I am hoping to find a solution to open the DB as read only. Sam _______________________________________________ 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
