Unable to save and retrieve String data using Sqlite in android

by

You need to move the Cursor to a valid row before trying to access column values with get...().

Add

if (cursor.moveToFirst()) {
    // cursor.get...()
}

around the cursor access.

In case you want all result rows, add a loop, too:

if (cursor.moveToFirst()) {
    do {
        // cursor.get...()
    } while (cursor.moveToNext());
}

This specific stacktrace is from getAllContacts() but getContact() has similar problem – you have moveToFirst() but fail to check if it succeeds.

Additionally getContactsCount() is broken, too. You shouldn’t access the count of a closed cursor.

More Related Contents:

  1. Android SQLite data display to ListView
  2. How to retrieve and display data from a database to TextView
  3. Sqlite for Android
  4. Best way to work with dates in Android SQLite [closed]
  5. How can I create a user-defined function in SQLite?
  6. SQLiteDatabase.query method
  7. About “_id” field in Android SQLite
  8. Import .csv file to Sqlite in Android
  9. Debugging sqlite database on the device
  10. How to insert a SQLite record with a datetime set to ‘now’ in Android application?
  11. Android SQLite: Update Statement
  12. How to delete SQLite database from Android programmatically
  13. Bulk Insertion on Android device
  14. Android Sqlite selection args[] with int values
  15. problem about sqlite database, no such table:
  16. SQLite simultaneous reading and writing
  17. update sql database with ContentValues and the update-method
  18. SQLiteDatabase close() function causing NullPointerException when multiple threads
  19. sqlite encryption for android
  20. Android quotes within an sql query string
  21. Android SQLite rawquery parameters
  22. Saving ArrayLists in SQLite databases
  23. How to access an existing sqlite database in Android?
  24. How to convert milliseconds to date in SQLite
  25. DB File in Assets Folder. Will it be Updated?
  26. Backup/restore sqlite db in android [duplicate]
  27. difference between rawquery and execSQL in android sqlite database
  28. Get SQLite database from Android app
  29. Does Android SQLite cursor load all records into memory at once?
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment