Yes this is possible. But it can not be conncurrent! The db connection must be prevented from being acted upon concurrently by your application. In other words it should be treated as a critical resource not for sharing. Access should be mutually exclusive amounst threads.
Shailesh Birari <[EMAIL PROTECTED]> wrote: Can some one tell me if the sharing of connection is possible even when the shared cache mode is disabled? -Shailersh > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shailesh Birari > Sent: Monday, April 14, 2008 11:24 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Connection Sharing across threads > > In one of the wiki entries, > http://www.sqlite.org/cvstrac/wiki?p=MultiThreading > , I > read that application cannot share the sqlite connection > across threads. However in another posting at > http://www.sqlite.org/sharedcache.html > I read that with > 3.5.0 update, the connection can be shared. > > >>>>>>> > > In version 3.5.0, shared-cache mode was modified so that the > same cache can be shared across an entire process rather than > just within a single thread. Prior to this change, there were > restrictions on passing database connections between threads. > Those restrictions were dropped in 3.5.0 update. This > document describes shared-cache mode as of version 3.5.0. > > >>>>>>> > > Is the sharing of connection possible even when the shared > cache mode is disabled? or is it possible only when shared > cache is enablesd? > > > > Kindly let me know > > > > regards > > Shailesh > > _______________________________________________ > 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
