On Aug 28, 2009, at 11:30 AM, Zhanjun You wrote: > Date: Thu, 27 Aug 2009 21:50:15 -0400 > From: "Igor Tandetnik" <itandet...@mvps.org> > Subject: Re: [sqlite] about journal file > To: sqlite-users@sqlite.org > Message-ID: <h77d4o$ka...@ger.gmane.org> > > Zhanjun You wrote: >> I can not find how to implement the method to deal with journal >> files > > What do you mean by "deal" here? What exactly are you trying to do > with > them, that you cannot achieve simply by beginning and then > committing a > transaction? > > Igor Tandetnik > > My app meet power fail,so sqlite generate a journal file, like > mydb.db.journal, then my app con not connect sqlite datebase, I want > to know > how to do?
Why not? What happens when your app tries to open the database after the system is rebooted? SQLite is supposed to detect the journal file and automatically roll it back when you open the database. Your program doesn't have to do anything special to deal with the journal file. The document you posted a link to in an earlier mail describing the journal file format is a design document, intended for people working on the SQLite core (or compatible systems). If you are programming an application that uses SQLite, you should not need to worry about any of these details. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
