DatabaseObjectNotClosedException in android?

Question

Am using database in my application when i execute my application i shows following error

android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here

pls help me how to solve this error

score 0 · Answer 1 · answered Oct 11 '12 at 07:31

0

You didn't close your database after using it. So you must close your database using below statement.

db.close();

answered Oct 11 '12 at 07:31

selva_pollachi

4,147
4
29
42

where in helperclass or mainclass – Vicky Oct 11 '12 at 07:32
String cur="SELECT * FROM Category"; Cursor c=helperdb.rawQuery(cur, null); return c; am write this code in helperclass method , i just call this method from mainactivity db.methodname – Vicky Oct 11 '12 at 07:42
you write db.close below the db.methodname. – selva_pollachi Oct 11 '12 at 07:52

score 0 · Answer 2 · answered Oct 11 '12 at 07:31

You should always close the cursor & Db after doing a transaction..
And remember to close it also in case of exceptions..

you have to implement like this in your class which is extending SQLite Helper class:

@Override
    public synchronized void close() {
        if(db != null){
            db.close();
        super.close();
        }   
    }

Sardor Dushamov · Answer 3 · 2012-10-11T07:46:33.163

0

in your mainclass call this method

db.close();

add this method to your helperclass

@Override
    public synchronized void close() {
        if(db != null){
            db.close();
        super.close();
        }   
    }

More information about Andorid Sqlite Database

edited Oct 11 '12 at 07:46

answered Oct 11 '12 at 07:36

Sardor Dushamov

1,665
3
17
44

score 0 · Answer 4 · edited May 23 '17 at 11:44

You can completely avoid opening/closing the database by making your database a singleton, which is the recommended approach in Android.

The problem only gets worse when you want to access the database across multiple threads.

Check out this question for examples of how to keep a single open database Android SQLite DB When to Close

Although this solves the problem you still need to make sure you close your cursors when done, unless your using the Loader API which will handle this for you.

DatabaseObjectNotClosedException in android?

4 Answers4