SQLite returned an error code of 14

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() +  "/" + 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.

Today this issue cost me 3 hours. What I tried:

• Rewriting the copy database code.
• Deleting the app from the emulator / device
• Wiping emulator(s)
• Cleaning eclipse
• Changing file permissions

I solved the problem by copying the code from a shared Dropbox account to another location and refactoring the code in the Android Manifest and java files with another package name.

The application runs beautifully now.

I had the same problem.

What solved it, was replacing

private static String DB_PATH = "/data/data/YOUR_PACKAGE/databases/";

with

String myPath = myContext.getFilesDir().getAbsolutePath().replace("files",
"databases")+File.separator + DB_NAME;

I had the same error code on logcat:

sqlite returned: error code = 14, msg = cannot open file at source line

The app would run fine (I actually didn't notice any issues until I looked at logcat!). Logcat informed me of this error so I thought it would be best to get this resolved now.

It turns out that if I edited the manifest file it got rid of the error! Within my manifest I had typed in the incorrect min sdk version. I discovered this because within the manifest file there was an exclamation indicator along the left column of the code informing me of my mistake.

To be thorough, I would recommend that you should make sure all errors/exclamations have been fixed so you can at least rule them out.

It seems this error (and many more in eclipse) can occur depending on a vast number of factors! Oh the joys!

Or, another easy solution that worked for me is as follows :

1. In emulator's settings option, click Application
2. Go to Manage Applications
3. Find your App, and click Uninstall
4. Then run your App again from the Eclipse.

My reason was different: I've accessed online version of the app, which created the database. The PhoneGap application then couldn't access the file created by different app. Clearing browser cache solved my problem.

The enigma is solved, tested in the emulator without the DB and mark them wrong, so you must first create the DB

    InputStream myInput = myContext.getAssets().open(DB_NAME);

    //Destination folder (where we created the DB empty)
    String outFileName = DB_PATH + DB_NAME;

    //We opened it BBDD Vacia as OutputStream
    OutputStream myOutput = new FileOutputStream(outFileName);

    //Transfers Bytes between input and output Stream
    byte[] buffer = new byte[1024];
    int length;
    while ((length = myInput.read(buffer))>0){
        myOutput.write(buffer, 0, length);
    }

    //Close the open files
    myOutput.flush();
    myOutput.close();
    myInput.close();
}

After that, do your operations. Good luck!

I managed to solve this by realizing that the documentation is slightly misleading. You need to have a file name for your zipped asset that is related to the name of your database. For instance, if your database is called someData.db, your zip file must be someData.zip.

Also, there seems to be a bit better diagnostics if you try opening a writable db. I did in the constructor, as follows, which was what ultimately helped me to figure out the solution.

SQLiteDatabase db=getWritableDatabase();
db.close();

Make sure you are closing all your cursor and db instances. I had this error due to making multiple inserts and updates and not closing the cursors, causing cursor leaks, and unable to open the db.

The database directory is not created automatically on some devices. You just need to detect missing databases directory and create it:

File databaseFile = getDatabasePath("my.db");

// Create directory when needed
File databaseDir = databaseFile.getParentFile();
if(!databaseDir.exists()) {
    databaseDir.mkdirs();
}

SQLiteDatabase database = SQLiteDatabase.openOrCreateDatabase(databaseFile);