ansaurus

Question

android database leak found IllegalStateException

Answer 1

+2 A:

The important line is...

... Caused by: java.lang.IllegalStateException: /data/data/com.example.search/databases/rlite.db SQLiteDatabase created and never closed

Chances are you are allowing your activity to be stopped/exited before you are closing the database. (This can happen if you are not implementing all the (onXXX() methods) in the lifecycle. They can be triggered unexpectedly eg if you rotate the device.

Either write your db access routines as

db.open()
db.dosomething()
db.close()

or make sure you close the database when you get an onSuspend() (I think.. possibly one of the others) and re-open it when you are started again.

Hope this helps

Peter

Vagnerr 2010-04-20 12:26:29

k thanks vagnerr. private static class OpenHelper extends SQLiteOpenHelper { OpenHelper(Context context) {super(context, DATABASE_NAME, null, DATABASE_VERSION);}public void onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE " + TABLE_NAME + "(id INTEGER PRIMARY KEY, name TEXT, " +contact TEXT")"); }public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);onCreate(db);} public synchronized void close() {super.close(); }}where i did the mistake

saravanan 2010-04-21 11:23:38

ansaurus

tags:

views:

answers:

android database leak found IllegalStateException

related questions