SQLite returned an error code of 14

by

This may be a little late, but hope this helps for whoever gets this problem (since I can’t find a definitive solution around).

I think I know the reason for this cause (at least for my case). Looking in the DDMS –> File Explorer, you’d realize that the Database Folder (/data/data//databases/) does not exist, which is why the application cannot create the database file in that non-existent folder. If you can create a databases folder in some manner, you can avoid this problem.

Because I’m lazy, I just used the /data/data//files/ folder when I’m in Emulator mode. You can get the files dir using this:

context.getFilesDir().getPath()

This worked beautifully for me in the Emulator.

Hope this helps someone.

In case you want to see some code: 

String dbFilename = "example.db";
try
{       
    File databaseFile = getDatabasePath(dbFilename);        
        SQLiteDatabase _db = SQLiteDatabase.openOrCreateDatabase(databaseFile);
} catch (Exception e)
{
    String databasePath =  getFilesDir().getPath() +  "https://stackoverflow.com/" + dbFilename;
    File databaseFile = new File(databasePath); 
    _db = SQLiteDatabase.openOrCreateDatabase(databaseFile);
}

EDIT: I tried logging into Facebook (my app has FB integration) on the Emulator and /databases folder appeared after that (and persisted). Not sure what happened, but it’s possible to create that folder somehow. Something for another expert around here to shed light on.

More Related Contents:

  1. Retrieve database or any other file from the Internal Storage using run-as
  2. Android SQLite data display to ListView
  3. Android :: SQLIte Db don't insert the datas
  4. Need a bit of assistance [closed]
  5. sample code for using mongoDB for storing user information and comments in an android application [closed]
  6. Save data in a SQLite database with the original format and view those data again with that form format
  7. How can I avoid concurrency problems when using SQLite on Android?
  8. How to access data/data folder in Android device?
  9. View contents of database file in Android Studio
  10. Best way to work with dates in Android SQLite [closed]
  11. Best place to close database connection
  12. Import .csv file to Sqlite in Android
  13. Cursor adapter and sqlite example [closed]
  14. How to sync SQLite database on Android phone with MySQL database on server?
  15. How to retrieve data from sqlite database in android and display it in TextView
  16. copy database from assets to databases folder [duplicate]
  17. How do I create a database in android? [closed]
  18. How to use Room Persistence Library with pre-populated database?
  19. Android: column ‘_id’ does not exist
  20. Best way to save large amount of data locally in unity3D android? [closed]
  21. SQLite simultaneous reading and writing
  22. update sql database with ContentValues and the update-method
  23. Attempt to reopen an already-closed object sqlitedatabase
  24. Saving ArrayLists in SQLite databases
  25. How insert image in room persistence library?
  26. How to convert milliseconds to date in SQLite
  27. SQLite android column not found
  28. How to store JSON object in SQLite database
  29. How to update the Android media database
  30. SQLiteOpenHelper onUpgrade() Confusion Android

Leave a Comment