SQLiteDatabase close() function causing NullPointerException when multiple threads

by

I have your answers!

Never close the db. It is that simple.

Make sure you only have one, repeat, *one Helper instance per application. Share it with all threads.

http://www.touchlab.co/blog/single-sqlite-connection/

Here’s some more info on the internals of sqlite and locking:

http://www.touchlab.co/blog/android-sqlite-locking/

More Related Contents:

  1. get Feature item to list View
  2. When does SQLiteOpenHelper onCreate() / onUpgrade() run?
  3. How do I use prepared statements in SQlite in Android?
  4. Where does Android emulator store SQLite database?
  5. Android SQLite Example [closed]
  6. Android database encryption
  7. Android. Fragment getActivity() sometimes returns null
  8. Android SQLite issue – table … has no column named
  9. How to add new Column to Android SQLite Database?
  10. Android error – close() was never explicitly called on database
  11. Exporting SQLite Database to csv file in android
  12. What is a maximum size of SQLite database on Android?
  13. How to save images into Database
  14. Full text search example in Android
  15. rawQuery(query, selectionArgs)
  16. App Crashes On Startup Due To java.lang.IllegalArgumentException: column ‘_id’ does not exist
  17. A pre-populated database does not work at API 28 throws “no such table” exception
  18. Get last inserted value from sqlite database Android
  19. Could not allocate CursorWindow
  20. When should I do certain SQLite operations on another thread(not the main thread)?
  21. Android Api 23 Change Navigation View headerLayout textview
  22. Changing values from Cursor using SimpleCursorAdapter
  23. SQLite exception: Database is locked issue
  24. How can I reset a autoincrement sequence number in sqlite
  25. Sqlite issues with HTC Desire HD
  26. How to store JSON object in SQLite database
  27. NullPointer on toLowerCase but I don’t use that method anywhere
  28. How to add a SearchWidget to the ActionBar?
  29. Android SQLiteOpenHelper cannot open database file
  30. Android table creation Failure (near “autoincrement”: syntax error)?

Leave a Comment