CODEWITHSUNDEEP
androidsqlitecrash
Harsha M V
Harsha M V

Reputation: 54949

App Crashes due to Db creation on every launch

I have an application in which i am trying to create a Database. On the first run the application works properly. Subsequent launch of the application it crashes. The error is because the application is trying to create the db again.

So i want to know how to create a database or tables only if they dont exists or only if the application is run the first time.

Upvotes: 1

Views: 276

Answers (2)

Phyrum Tea
Phyrum Tea

Reputation: 2653

You can extend the class SQLiteOpenHelper to handle different versions of your database. Here is an example:

public class MyDbOpenHelper extends **SQLiteOpenHelper** {
    final static int VERSION = 2;

    public MyDbOpenHelper(Context context, String dbname) {
        super(context, dbname, null, VERSION);
    }

    @Override
    public void **onCreate**(SQLiteDatabase db) {
        /* TODO SQL-Queries for new Database */
    }

    @Override
    public void **onUpgrade**(SQLiteDatabase db, int oldVersion, int newVersion) {
        /* SQL-Queries t*/
        if (oldVersion < 2) {
            db.execSQL("ALTER TABLE my_table ADD COLUMN new_attrubte INTEGER");
        }
    }
}

Handle of database is new in onCreate and if it exist, onUpgrade is called with existing version number in oldVersion parameter.

Upvotes: 4

Thilo
Thilo

Reputation: 262714

SQLite has a CREATE TABLE IF NOT EXISTS command. You could try that.

It is usually an error to attempt to create a new table in a database that already contains a table, index or view of the same name. However, if the "IF NOT EXISTS" clause is specified as part of the CREATE TABLE statement and a table or view of the same name already exists, the CREATE TABLE command simply has no effect (and no error message is returned). An error is still returned if the table cannot be created because of an existing index, even if the "IF NOT EXISTS" clause is specified.

Upvotes: 4

Related Questions