sqlite database hardcode /data/ db_path android

Question

Cannot retrieve database, and shows a lint warning that says:

Do not hardcode "/data/"; use Context.getFilesDir().getPath() instead

Have tried searching for related errors but nothing helps. Here's the code

private static String DB_PATH = "/data/data/mlearning.fundprog/databases/";
private static String DB_NAME = "questionsDb";
private SQLiteDatabase myDataBase; 
private final Context myContext;

public DBHelper(Context context) {
    super(context, DB_NAME, null, 1);
    this.myContext = context;
    DB_PATH = context.getFilesDir().getPath() + context.getPackageName() + DB_NAME;
}   

private boolean checkDataBase(){
    SQLiteDatabase checkDB = null;
    try{
        String myPath = DB_PATH + DB_NAME;
        checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
    }catch(SQLiteException e){

    }
    if(checkDB != null){
        checkDB.close();
    }

    return checkDB != null ? true : false;
}

private void copyDataBase() throws IOException{
    InputStream myInput = myContext.getAssets().open(DB_NAME);
    String outFileName = DB_PATH + DB_NAME;
    OutputStream myOutput = new FileOutputStream(outFileName);

    byte[] buffer = new byte[1024];
    int length;
    while ((length = myInput.read(buffer))>0){
        myOutput.write(buffer, 0, length);
    }

    myOutput.flush();
    myOutput.close();
    myInput.close();
}

public void openDataBase() throws SQLException{
    String myPath = DB_PATH + DB_NAME;
    myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);
}

I really dont get what's wrong with this. It was working before, but i'm thinking it's because i have moved to API 14 from API 8. I guess this higher API has another rule for codings. Is that so?

Not in the code you've shown. (The SQLiteOpenHelper constructor sees only DB_NAME.) — CL.
– CL., Commented Aug 30, 2014 at 15:15
Where did you get this code from? Better use SQLiteAssetHelper. — CL.
– CL., Commented Aug 30, 2014 at 17:48

CommonsWare · Accepted Answer · 2014-08-30 14:33:14Z

3

To get the path to a database, use getDatabasePath().

answered Aug 30, 2014 at 14:33

CommonsWare

1.0m195 gold badges2.4k silver badges2.7k bronze badges

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

Comments

Vivek Warde · Accepted Answer · 2014-08-30 15:34:27Z

1

You can use any of the below 2 methods to get the path of your database:

DB_PATH = "/data/data/" + context.getApplicationContext().getPackageName() + "/databases";

or use this

DB_PATH = context.getDatabasePath(DB_NAME).getParent();

edited Aug 30, 2014 at 15:34

answered Aug 30, 2014 at 15:15

Vivek Warde

1,5148 gold badges49 silver badges77 bronze badges

3 Comments

Kaitlin Reyes Over a year ago

What does v in v.getDatabasePath stands for?

Kaitlin Reyes Over a year ago

That should be placed inside the DBHelper constructor right? I've tried it and still doesn't work

Vivek Warde Over a year ago

Yes. Try debugfing ur app and see waht contains DB PATH

Collectives™ on Stack Overflow

sqlite database hardcode /data/ db_path android

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related