Android Database Locked

by

I think you have forgotten to close the database, or another thread is writing to the database when you are trying to write to it. SQLite locks the database when it is writing to it to avoid corruption if another entity tries to write to the same database at the same time. Android, will only show a error in log cat, and the query you supplied will be just forgotten…

So, I recommend:

  • You only access the database from one SQLOpenHelper
  • You make sure you close all instances of database helpers once you have finished with them
  • You make sure you always end transactions with endTransaction() also if you do not set them successful (i.e. if you want to roll ’em back), in case you use transactions
  • You could try using OrmLite, I’ve not used it, but I’ve heard others here rave about it.

More Related Contents:

  1. How to handle notification when app in background in Firebase
  2. How to simulate a touch event in Android?
  3. Android ImageButton with a selected state?
  4. Creating temporary files in Android
  5. How to keep/exclude a particular package path when using proguard?
  6. notifyDataSetChange not working from custom adapter
  7. ffmpeg for a android (using tutorial: “ffmpeg and Android.mk”)
  8. Android get image from gallery into ImageView
  9. Starting an activity from a service after HOME button pressed without the 5 seconds delay
  10. Android: Activity getting Destroyed after calling Camera Intent
  11. How to get available wifi networks and display them in a list in android
  12. Display badge on top of bottom navigation bar’s icon
  13. Programmatic Views how to set unique id’s?
  14. Detecting which selected item (in a ListView) spawned the ContextMenu (Android)
  15. Error broadcast intent callback: result=CANCELLED forIntent { act=com.google.android.c2dm.intent.RECEIVE pkg=com.flagg327.guicomaipu (has extras) }
  16. How do I get a jacoco coverage report using Android gradle plugin 0.10.0 or higher?
  17. How to play .mp4 video in videoview in android?
  18. How to store image retrieved from url in a SQLite database?
  19. Android Sqlite selection args[] with int values
  20. Usage of android:process
  21. Get a list of available Content Providers
  22. How to use textview.getLayout()? It returns null
  23. How do you get the RGB values from a Bitmap on Android?
  24. Clojure on Android [closed]
  25. Android Studio 1.2 – Project encoding mismatches by default
  26. The easiest way to play an audio RTMP stream in Android
  27. Bottom button bar in android
  28. ListView with alphabets on the right, like the iPhone. Is it possible?
  29. Opening a File from assets folder in android
  30. Pause GC Error post android 4.4.2 upgrade

Leave a Comment