How to check existing database before creating new database on android 2.2?

Question

I need to check existing database before creating new database on android 2.2. How to check it?

Sarwar Erfan · Accepted Answer · 2011-01-10T13:42:21.670

1

use openOrCreateDatabase method

----- EDIT ------

public boolean checkDataBase(){

    SQLiteDatabase checkDB = null;

    try{
        String myPath = DB_PATH + DB_NAME;
        checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY | SQLiteDatabase.NO_LOCALIZED_COLLATORS);

    }catch(SQLiteException e){

        //database does't exist yet.
    }

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

    return checkDB != null ? true : false;
}

edited Jan 10 '11 at 13:42

answered Jan 10 '11 at 11:36

Sarwar Erfan

18,034
5
46
57

But got exception if database is not exist means. How to resolve this issue? – bharath Jan 10 '11 at 12:21
I have edited the answer and added the method I use to check existence. – Sarwar Erfan Jan 10 '11 at 13:44

score 1 · Answer 2 · edited May 23 '17 at 12:11

1

Doesn't it work with the DatabaseHelper ? If you haven't tried here is code I posted before...

Android - Sqlite database method undefined fot type

edited May 23 '17 at 12:11

Community

1
1

answered Jan 10 '11 at 12:46

Beasly

1,517
4
20
30

http://mfarhan133.wordpress.com/2010/10/24/database-crud-tutorial-for-android/ I used this sample. Its working fine. But At begining i got the exception if database is not exist means. see the DBAdapter.java class – bharath Jan 10 '11 at 12:55
Are you getting an IOException? Maybe you can post some code to look at. Because for me it is working fine if no DB is available. – Beasly Jan 10 '11 at 12:58

score 0 · Answer 3 · answered Mar 16 '18 at 05:55

0

You should need to check database already exists or not, if not than create database else not create database. Please you can use below query.

CREATE TABLE if not exists TABLE_NAME (key data_type);

Call this query inside onCreate method.

answered Mar 16 '18 at 05:55

Hkh

357
1
10

Tony Barajas · Answer 4 · 2017-09-12T17:07:07.787

-1

To check if your database was created you can use the following code and it will not be recreated every time you open the application. dbName = is the name of you DB

public static boolean doesDatabaseExist(Context context, String dbName) {
        File dbFile = context.getDatabasePath(dbName);
        return dbFile.exists();
    }

edited Sep 12 '17 at 17:07

answered Sep 12 '17 at 13:50

Tony Barajas

124
2
12

How to check existing database before creating new database on android 2.2?

4 Answers4

Linked

Related