how to save image taken from camera and show it to listview – crashes with “IllegalStateException”

by

As per you create database statement

 private static final String SCRIPT_CREATE_DATABASE = "create table "
 + DATABASE_TABLE + " (" + KEY_ROWID
 + " integer primary key autoincrement, " + KEY_TITLE
 + " text not null, ......+KEY_COMMENTS+" text not null,"+KEY_IMAGE+"  imageblob BLOB);";

you are mentioned that 

 "+KEY_IMAGE+"  imageblob BLOB

so the column value is “imageblob imageblol BLOB” syntax wise it is not a correct sql statement.
so just remove the “imageblob” from there and try that, it may be solve your problem….

More Related Contents:

  1. get Feature item to list View
  2. Android SQLite data display to ListView
  3. Android column ‘_id’ does not exist?
  4. How to implement Android Pull-to-Refresh
  5. Android: upgrading DB version and adding new table
  6. Should we use RecyclerView to replace ListView? [closed]
  7. How to disable the Clear Data button in Application info of Manage application
  8. Listview Scroll to the end of the list after updating the list
  9. Android Recyclerview vs ListView with Viewholder
  10. How to convert image file data in a byte array to a Bitmap?
  11. Populate Listview from JSON
  12. Android: wrap_content is not working with ListView
  13. Does Android Support JDBC
  14. Lazy Load images on Listview in android(Beginner Level)? [duplicate]
  15. How to perform an SQLite query within an Android application?
  16. How do I order my SQLITE database in descending order, for an android app?
  17. android nested listview
  18. How to change color of ListView items on focus and on click
  19. Android ExpandableListView and SQLite Database
  20. Multiple Table SQLite DB Adapter(s) in Android?
  21. Refreshing activity on receiving gcm push notification
  22. Closing the database in a ContentProvider
  23. Sort listview with array adapter
  24. How to Overlap items in LinearLayoutManager – RecyclerView (like stacking cards)
  25. How to check database on not rooted android device
  26. Android ListView with delete button
  27. SQLite android column not found
  28. SQlite – Android – Foreign key syntax
  29. Inserting values to SQLite table in Android
  30. SQLiteOpenHelper onUpgrade() Confusion Android

Leave a Comment