Opppsssss. Apologies for my mistake. My test is working correctly now.
Thanks a lot. >You only have to do this once, e.g. at database creation. >Journal mode WAL is a persistent property of the database file. >Every connection will respect it. All PRAGMA Option is attached to database as a persistent property? Is their any issue if we set all option again with every new connection to same file? On Mon, Aug 26, 2013 at 2:40 PM, Kees Nuyt <k.n...@zonnet.nl> wrote: > On Mon, 26 Aug 2013 13:32:42 +0530, techi eth <techi...@gmail.com> > wrote: > > >PRAGMA jouranl_mode = WAL > > That's misspelled, both in your text and in your code. > > Try: > PRAGMA journal_mode=WAL; > > You only have to do this once, e.g. at database creation. > Journal mode WAL is a persistent property of the database file. > Every connection will respect it. > > -- > Groet, Cordialement, Pozdrawiam, Regards, > > Kees Nuyt > > _______________________________________________ > 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