CODEWITHSUNDEEP
androiddatabase
shvivek
shvivek

Reputation: 328

I am getting error while Version creating my database

I am getting following error while Version Creating My Database.

01-18 12:08:01.157: ERROR/AndroidRuntime(3079): Caused by: java.lang.IllegalArgumentException: Version must be >= 1, was 0

Please Help me regarding this.

Upvotes: 0

Views: 740

Answers (2)

AAnkit
AAnkit

Reputation: 27549

it seems you have set previous version as 0, remove your app from phone, reinstall it, make sure new version is greater then previous one.

Upvotes: -1

DanielS
DanielS

Reputation: 555

Each database you create has a version number. That way you can keep track of them if you upgrade the application (perform necessary database changes for the upgrade on existing data). The version number must start from 1.

If you look at the following code:

private static class OpenHelper extends SQLiteOpenHelper {

  OpenHelper(Context context) {
     super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }

  @Override
  public void onCreate(SQLiteDatabase db) {
     db.execSQL("CREATE TABLE " + TABLE_NAME + " 
      (id INTEGER PRIMARY KEY, name TEXT)");
  }

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
     Log.w("Example", "Upgrading database, this will drop tables and recreate.");
     db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
     onCreate(db);
  }

onUpgrade will handle all necessary database upgrades. Sometimes you'll opt to just destroy (drop) the current database and create a new one.

Upvotes: 3

Related Questions