Sqlite issues with HTC Desire HD

by

Short answer: try removing SQLiteDatabase.OPEN_READONLY.

Longer answer:

The “WAL” is the write-ahead log, a relatively new feature in SQLite as I understand it. The SQLite docs on WAL say “It is not possible to open read-only WAL databases.” Now, that appears to be more in the context of read-only media, but it might hold true for OPEN_READONLY.

I’d be somewhat surprised if this helps, as it presumes that:

  • WAL is not used in standard Android
  • HTC enabled WAL in those two devices
  • Something special about your environment (e.g., the binary database you’re schlepping out of assets) is causing this problem where an ordinary read-only database still works fine, as I cannot imagine that those devices would have passed compatibility tests with broken read-only database support

But, I would think it is at least worth a shot.

You might also consider switching from packaging the binary database to packaging the SQL statements to build/populate the database and executing them. While this will be slower (much slower if you don’t use transactions), it might be less prone to database file-specific issues.

More Related Contents:

  1. Android SQLite data display to ListView
  2. How to retrieve and display data from a database to TextView
  3. IN clause and placeholders
  4. Android Database Transaction
  5. SQLiteDatabase.query method
  6. Best place to close database connection
  7. Backup and restore SQLite database to sdcard
  8. Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL
  9. How to split comma-separated value in SQLite?
  10. Import .csv file to Sqlite in Android
  11. Debugging sqlite database on the device
  12. Cursor adapter and sqlite example [closed]
  13. How to insert a SQLite record with a datetime set to ‘now’ in Android application?
  14. How to retrieve data from sqlite database in android and display it in TextView
  15. Bulk Insertion on Android device
  16. Android: column ‘_id’ does not exist
  17. Android Save images to SQLite or SDCard or memory
  18. Android Cursor with ORMLite to use in CursorAdapter
  19. SQLite simultaneous reading and writing
  20. Is it possible to apply primary key on the text fields in android database
  21. SQLiteDatabase close() function causing NullPointerException when multiple threads
  22. How to store sqlite database directly on sdcard
  23. sqlite example program in android [closed]
  24. Create SQLite database in android
  25. Android SQLite rawquery parameters
  26. Android SQLite auto increment
  27. Android Device Monitor “data” folder is empty
  28. Backup/restore sqlite db in android [duplicate]
  29. Compare dates (stored as string) in android sqlite database?
  30. Backup Room database

Leave a Comment