Re: [sqlite] about journal file
On 29/08/2009, at 06:25, Zhanjun You wrote: > I finally understand do not need to deal with journal file. > But I do not know what circumstances led to the journal file, this > time to > read the database file will fail.What may cause such a thing happen? Google is your friend: typing 'sqlite journal' shows the following link as the first match: http://www.sqlite.org/lockingv3.html -- Tito ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] about journal file
> > 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. I finally understand do not need to deal with journal file. But I do not know what circumstances led to the journal file, this time to read the database file will fail.What may cause such a thing happen? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] about journal file
On Aug 28, 2009, at 11:30 AM, Zhanjun You wrote: > Date: Thu, 27 Aug 2009 21:50:15 -0400 > From: "Igor Tandetnik" > Subject: Re: [sqlite] about journal file > To: sqlite-users@sqlite.org > Message-ID: > > 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
Re: [sqlite] about journal file
Date: Thu, 27 Aug 2009 21:50:15 -0400 From: "Igor Tandetnik" Subject: Re: [sqlite] about journal file To: sqlite-users@sqlite.org Message-ID: 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? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] about journal file
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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] about journal file
I can not find how to implement the method to deal with journal files, and I also found that no one to discuss this issue that do not need to work with these? Or say that this issue is too simple do not need to ask. I am dumb, I hope someone can help me ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users