checking database in android

Question

I have to check whether a database exists or not in android?? how can i check? It should return a boolean value after checking?plz provide me with the code.

Jeff Gilfelt · Accepted Answer · 2011-02-18 11:17:57Z

1

Something like:

private boolean databaseExists() {
    SQLiteDatabase checkDB = null;
    try {
        String myPath = DB_PATH + DATABASE_NAME;
        checkDB = SQLiteDatabase.openDatabase(myPath, null,
            SQLiteDatabase.OPEN_READONLY);
        if(checkDB != null){
            checkDB.close();
            return true;
        } else {
            //database does not exist
            return false;
        }
    } catch (SQLiteException e) {
        //database does not exist
        return false;
    }
}

answered Feb 18, 2011 at 11:17

Jeff Gilfelt

26.2k7 gold badges50 silver badges47 bronze badges

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

3 Comments

Vikas Patidar Over a year ago

And here DB_PATH should be like this: "/data/data/YOUR_PACKAGE_NAME_IN_MANIFEST/databases/".

Jeff Gilfelt Over a year ago

Yes, and should be constructed from your Context - context.getApplicationInfo().dataDir + "/databases/"

Prachi Over a year ago

thank you!! now i am able to check for the database . the code was really very useful for me.

Collectives™ on Stack Overflow

checking database in android

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related