Hello,

I am developing an app. It is working fine but if i left the app open for
few hours the database gets blank sometimes(1 out of 5). I tried hard to
track the issue but couldn't found any. I am using Sqlite database. Please
help me as soon as possible.

Thanks
Abhi

Did you close de SQLiteDatabase db? Sometimes in my app when i didnt close
my db, my app gave me some exception.
I put this funcion on my activities

@Override
protected void onDestroy() {
super.onDestroy();
dao.cleanup();

public void cleanup() {
       if (this.db != null) {
           this.db.close();
           this.db = null;
       }
 }

I hope i could help u

On Wed, Aug 8, 2012 at 7:44 AM, Abhi <

--
att,
Pedro Cortez

Database corruption can also happen when you open the same database file
multiple times simultaneously. When the database is broken SQLiteDatabase
simply re-creates the database file by default. I think that is largely
fixed in newer Android versions and you would get a DatabaseLockedException
if you try to open it multiple times.

Make sure to:

   1. Only use a single SQLiteDatabase connection / SQliteOpenHelper per
   database file
   2. Open / close that connection at appropriate times in your activity
   life cycle.

About 2.:

If you create the connection in onCreate / onResume and close it in onStop
or onDestroy for example it is very likely that you'll end up with two open
SQLiteDatabase connection objects simultaneously because two activities are
likely to intersect in that case. You could probably get around that by
opening the connection object in onResume and closing it in onPause.

Alternatively you can keep your database connection object as a singleton
in your application object for example. Keep a reference counter there too.
Every time when your activity starts it can request the db connection and
increment the reference counter by one. When your activity is done
(onDestroy) it can decrement the counter. If the counter hits zero you can
close the db connection.

Thanks Pedro for your reply.
 I had already put all the checks to open or close the database . The thing
is that this issue is occuring not so often and also it is occuring in
Samsung gi5800 phone. If i intentionally left the app opened for few hours
then it won't come. I just want to confirm that whether this error is in my
code or it is the issue with this phone.