Android error – close() was never explicitly called on database

by

I think the problem is that you need to close the db when your activity is destroyed. Try adding this to your activity:

@Override
protected void onDestroy() {
    super.onDestroy();
    if (openHelper != null) {
        openHelper.close();
    }
    if (cdh != null) {
        cdh.close();
    }
}

and add this to your CallDataHelper class:

public void close() {
    // NOTE: openHelper must now be a member of CallDataHelper;
    // you currently have it as a local in your constructor
    if (openHelper != null) {
        openHelper.close();
    }
}

EDIT 2: Also change the CallDataHelper constructor to:

// Declare openHelper as a member variable
OpenHelper openHelper = null;

public CallDataHelper(Context context) {
    this.context = context;
    openHelper = new OpenHelper(this.context);
    this.db = openHelper.getWritableDatabase();
}

This should successfully close the database connection that was created by both of your OpenHelper instances.

( EDITED to reflect the fact that you use two OpenHelper instances.)

More Related Contents:

  1. Closing the database in a ContentProvider
  2. How to check database on not rooted android device
  3. Android SQLite data display to ListView
  4. Android :: SQLIte Db don't insert the datas
  5. IN clause and placeholders
  6. Android Database Transaction
  7. About “_id” field in Android SQLite
  8. Best place to close database connection
  9. Backup and restore SQLite database to sdcard
  10. Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL
  11. How to split comma-separated value in SQLite?
  12. Cursor adapter and sqlite example [closed]
  13. How to retrieve data from sqlite database in android and display it in TextView
  14. When to use a Content Provider
  15. Bulk Insertion on Android device
  16. Android Sqlite selection args[] with int values
  17. problem about sqlite database, no such table:
  18. SQLite simultaneous reading and writing
  19. update sql database with ContentValues and the update-method
  20. SQLiteDatabase close() function causing NullPointerException when multiple threads
  21. Android quotes within an sql query string
  22. Retrieve large blob from Android sqlite database
  23. Android SQLite rawquery parameters
  24. Saving ArrayLists in SQLite databases
  25. What are the semantics of withValueBackReference?
  26. How to convert milliseconds to date in SQLite
  27. Backup/restore sqlite db in android [duplicate]
  28. how to get contact photo URI
  29. Compare dates (stored as string) in android sqlite database?
  30. Backup Room database

Leave a Comment