SQLite Android . unable to open database file

Question

I found a lot of question about this problem, but i can't fix it. I have a sqlite db in assets folder:

assets/data/data/{package_name}/databases/mydb.db

I can open database and read data before change one table structure. I try to uninstall the app and reinstall again, but i get the same exception.

What can i do now?

Thanks in advance

EDIT

// The Android's default system path of your application database.
private static String DB_PATH = "/data/data/{mypagackename}/databases/";

private static String DB_NAME = "mydb.db";

Open database (Before change table structure, adding some fields, it doesn't work)

public void openDataBase() throws SQLException {

    // Open the database
    String myPath = DB_PATH + DB_NAME;
    myDataBase = SQLiteDatabase.openDatabase(myPath, null,
            SQLiteDatabase.OPEN_READONLY);

}

You are modifying the table structure within program or before and save new configuration to the assets folder? — cosmincalistru
– cosmincalistru, Commented Jul 26, 2012 at 14:13
I'm modifying table structure with sourceforge.net/projects/sqlitebrowser/files/latest/download I save the file and replace it in assets folder. what i'm doing wrong? — jzafrilla
– jzafrilla, Commented Jul 26, 2012 at 14:14
Please consider using SQLiteAssetHelper as a debugged solution for packaging a database with your app and unpacking it on first use: github.com/jgilfelt/android-sqlite-asset-helper — CommonsWare
– CommonsWare, Commented Jul 26, 2012 at 14:16
No it's not gonna work this way, db should be in internal device memory. data/data/your.package.name/your.db not in assets. — Maxim
– Maxim, Commented Jul 26, 2012 at 14:24

Dharman · Accepted Answer · 2022-06-21 17:53:14Z

12

Basically, you can't use database right from the assets, you have to copy it over into internal data storage first and open it from there

edited Jun 21, 2022 at 17:53

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Jul 26, 2012 at 14:16

Maxim

4,2448 gold badges53 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RootCode · Accepted Answer · 2013-10-14 05:25:53Z

3

Instead of hard coded DB_PATH (no longer work in JB), I would recommend always go with Android inbuilt API method,

mContext.getDatabasePath(DATABASE_NAME).getPath();

answered Oct 14, 2013 at 5:25

RootCode

5797 silver badges13 bronze badges

Collectives™ on Stack Overflow

SQLite Android . unable to open database file

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related