Android database recreates everytime application is launched

Answer 1

Try this

public class DataBaseHelper extends SQLiteOpenHelper { private static final String DATENBANK_NAME = "yourdatabase.db"; private static final int DATENBANK_VERSION = 1;

public DataBaseHelper(Context context) {
    super(context, DATENBANK_NAME, null, DATENBANK_VERSION);
}

public void onCreate(SQLiteDatabase db) {
    db.execSQL(PartialTripTbl.SQL_CREATE);
}

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP TABLE IF EXISTS " + PartialTripTbl.TABLE_NAME);
    onCreate(db);
}

}

Answer 2

Look at your DBWrapper constructor,

you're calling

context.deleteDatabase(DATABASE_NAME);

This will delete the database file every time you call it. Forcing the SQLHelper to recreate the database.

Answer 3

The link below hopefully helps.

stackoverflow.com -> Query if Adroid DB exists!

Hope that helps

The poster above also mentioned you are deleting the database

content.deleteDabase(DATABASE_NAME)

in you DBWrapper() constructor