Cursor finalized without prior close() Android

android sqlite sqliteopenhelper
Timon Devos picture Timon Devos · May 3, 2012 · Viewed 29.5k times · Source

In my application I have a listview. I get my data with a query from a SQLiteDatabase. When I get the data from the db I get this error: error

It occurs when I go from line 20 to 21. occur

I tried placing cursor.deactivate() and cursor.close() on regel 50. But with no result. Anyone knows why I get this error and how to solve it? Thanks :)

Answer

Ali Behzadian Nejad picture Ali Behzadian Nejad · May 3, 2012

You have to close the cursor before the database. Put your code in a try / catch block and in a finally block, close the cursor and then close the database:

try {
    db = ...
} catch(Exception ex) { 
    // Log the exception's message or whatever you like
} finally {
    try {
      if( cursor != null && !cursor.isClosed())
        cursor.close();
       if( db.isOpen() )
        db.close();
    } catch(Exception ex) {}
}

Closing sequence matters a lot while doing IO with DB or Content Providers. For more information refer this link

Related questions

When is SQLiteOpenHelper onCreate() / onUpgrade() run?

I have created my tables in my SQLiteOpenHelper onCreate() but receive SQLiteException: no such table or SQLiteException: no such column errors. Why? NOTE: (This is the amalgamated summary of tens of similar questions every week. Attempting to provide a "canonical" …

Read More
Android SQLite Example

I am new to Android and I have to create an application where I need to use a SQLite database. I am not so well equipped with the SQLite. Could you tell me what the purpose and use of the …

Read More
Insert JSON data into the SQLite database in android

I want to insert the data from JSON array into the SQLite database. I have created two classes CategoryHelper.java and AndroidJSONParsingActivity.java to get the java response. When I run the code got the exception in databaseHelper.saveCategoryRecord(id,…

Read More