Attempt to reopen an already-closed object sqlitedatabase

by

It happens because of the:

db.close();

in the methods:

void addContact(Contact contact)

public void deleteContact(Contact contact)

You should not close the connection to the underlying database unless you really do not intend to work with it anymore.
Use SQLiteOpenHelper:close, when you’ve finished your work.

Moreover, calls to getReadableDatabase() and getWriteableDatabase() return the same database object 99% of a time, and they do not reinitialize database connection closed manually by you.

Don’t get fooled by these method names.

More Related Contents:

  1. How to add multiple edit text and spinner data into SQLite database?
  2. Why does the application crash when I press the button to insert the values in the table? [duplicate]
  3. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  4. Android SQLite issue – table … has no column named
  5. How to perform an SQLite query within an Android application?
  6. Android: column ‘_id’ does not exist
  7. How can I insert image in a sqlite database
  8. How to store and retrieve a byte array (image data) to and from a SQLite database?
  9. A pre-populated database does not work at API 28 throws “no such table” exception
  10. How to store sqlite database directly on sdcard
  11. How insert image in room persistence library?
  12. How to convert milliseconds to date in SQLite
  13. How to check database on not rooted android device
  14. Where does Android emulator store SQLite database?
  15. Android SQLite Example [closed]
  16. Android error – close() was never explicitly called on database
  17. What is a maximum size of SQLite database on Android?
  18. How to save images into Database
  19. Full text search example in Android
  20. rawQuery(query, selectionArgs)
  21. App Crashes On Startup Due To java.lang.IllegalArgumentException: column ‘_id’ does not exist
  22. How does one check if a table exists in an Android SQLite database?
  23. Could not allocate CursorWindow
  24. When should I do certain SQLite operations on another thread(not the main thread)?
  25. Changing values from Cursor using SimpleCursorAdapter
  26. SQLite exception: Database is locked issue
  27. How can I reset a autoincrement sequence number in sqlite
  28. PowerManager.PARTIAL_WAKE_LOCK android
  29. difference between rawquery and execSQL in android sqlite database
  30. Get SQLite database from Android app

Leave a Comment