Re: [sqlite] Android database corruption

2010-12-02 Thread Simon Slavin
On 3 Dec 2010, at 4:08am, jtdrexel wrote: > Some people say that the "dialer > storage" is related to sms and mms because the file size of the 'dialer > storage' file changes accordingly with the deletion and addition of > messages. Is the sms database and SQLite database? and is it located in th

Re: [sqlite] Android database corruption

2010-12-02 Thread Simon Slavin
On 3 Dec 2010, at 4:08am, jtdrexel wrote: >> It works perfectly 99% of the time, but every now and again, we get >> database corruption appear randomly. We have not changed any pragmas, so >> synchronous is set to full and journal_mode delete. It does not correspond >> to any power failures, or a

Re: [sqlite] Android database corruption

2010-12-02 Thread jtdrexel
Hello Cliff 2, I am not as profficient as you in android programming of SQLite but i am willing to help solve this problem. The reason why i am coming forward to help is because of comment # 451 on the following fourm: http://code.google.com/p/android/issues/detail?id=5669. There are a countl

Re: [sqlite] Android database corruption

2010-04-06 Thread D. Richard Hipp
On Apr 6, 2010, at 9:15 AM, cliff 2 wrote: > > > cliff 2 wrote: >> >> >> Thanks very much for the quick response! Unfortunately, the android >> SQLiteDatabase class deletes the database when it hits this, so it >> doesn't >> give me a chance to do that. However I do have a channel to the >> a

Re: [sqlite] Android database corruption

2010-04-06 Thread cliff 2
cliff 2 wrote: > > > Thanks very much for the quick response! Unfortunately, the android > SQLiteDatabase class deletes the database when it hits this, so it doesn't > give me a chance to do that. However I do have a channel to the android db > developers, so I will forward this onto them, and

Re: [sqlite] Android database corruption

2010-03-26 Thread cliff 2
Thanks very much for the quick response! Unfortunately, the android SQLiteDatabase class deletes the database when it hits this, so it doesn't give me a chance to do that. However I do have a channel to the android db developers, so I will forward this onto them, and hopefully they can do somethin

Re: [sqlite] Android database corruption

2010-03-26 Thread D. Richard Hipp
On Mar 26, 2010, at 12:10 PM, Shane Harrelson wrote: > On Fri, Mar 26, 2010 at 11:38 AM, cliff 2 > wrote: > >> >> Hi, >> >> Hopefully someone here can help where the android guys haven't been >> able >> to. >> We are having an issue with our sqlite database running on the >> android >> pla

Re: [sqlite] Android database corruption

2010-03-26 Thread Shane Harrelson
On Fri, Mar 26, 2010 at 11:38 AM, cliff 2 wrote: > > Hi, > > Hopefully someone here can help where the android guys haven't been able > to. > We are having an issue with our sqlite database running on the android > platform. We are accessing the db from the sdcard on an android phone > running an

[sqlite] Android database corruption

2010-03-26 Thread cliff 2
Hi, Hopefully someone here can help where the android guys haven't been able to. We are having an issue with our sqlite database running on the android platform. We are accessing the db from the sdcard on an android phone running android 2.1. It works perfectly 99% of the time, but every now an