SQLite database ..onCreate() is not being called

Question

Kohli.java

package com.kohli;

import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.content.Context;

public class KohlifActivity extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);

          Log.i("KOHLIActivity", "qwert11111111");   

          setContentView(R.layout.main);
          Log.i("KOHILActivity", "qwert22222222222"); 

        DbHelper1 DbHelper=new DbHelper1(this) ;

        Log.i("KOHLIfActivity", "qwert3333333333");



    }
}



DbHelper1.java
package com.kohli;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.provider.BaseColumns;
import android.util.Log;

public class DbHelper1 extends SQLiteOpenHelper 
{

    static final String TAG = "DbHelper1";
    static final String DB_NAME = "timeline.db"; 
    static final int DB_VERSION = 1;
    static final String TABLE = "timeline"; 
    static final String C_ID = BaseColumns._ID;
    static final String C_CREATED_AT = "created_at";
    static final String C_SOURCE = "source";
    static final String C_TEXT = "txt";
    static final String C_USER = "user";
    Context context;

    public DbHelper1(Context context) { 
        super(context, DB_NAME, null, DB_VERSION);
        this.context = context;
        Log.d(TAG, "constructor111111");
        //System.out.println("dbhelper constructor");
    }

    // Called only once, first time the DB is created

    public void onCreate(SQLiteDatabase db) {
    String sql = "create table " + TABLE + " (" + C_ID + " int primary key, "
    + C_CREATED_AT + " int, " + C_USER + " text, " + C_TEXT + " text)"; 

    db.execSQL(sql); 
    Log.d(TAG, "onCreated sql:22222222 ");
    //System.out.println("dbhelper oncreate");
    }

    // Called whenever newVersion != oldVersion
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { 
    // Typically do ALTER TABLE statements, but...we're just in development,
    // so:
    db.execSQL("drop table if exists " + TABLE); // drops the old database
    Log.d(TAG, "onUpdated 33333333");
    //System.out.println("dbhelper onupgrade");
    onCreate(db); // run onCreate to get new database
    }


}

i wrote the following code to make a database with a table... the output at logcat is :: qwert111111 qwert22222 constructor111111 qwert3333 .. that is the oncreate function is not being called so the database is also not created...

user · Accepted Answer · 2012-02-14 18:26:03Z

20

The database isn't actually created until you call getWritableDatabase() on the dbHelper object.

answered Feb 14, 2012 at 18:26

user

87.1k18 gold badges200 silver badges190 bronze badges

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

3 Comments

Daniel Over a year ago

But even when calling getWritableDatabase() the onCreate(SQLiteDatabase a) isn't called. Please any tips?

user Over a year ago

@Daniel The onCreate method will be called when you call getWritableDatabase/getReadableDatabase only when the database doesn't exist yet on the emulator/device(so it can be created). If you have problems regarding this, you should post a question providing additional details.

Awi Over a year ago

Make sure you increase the version. Database are not re-created if the version does not increase its number.

Collectives™ on Stack Overflow

SQLite database ..onCreate() is not being called

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related