Sqlite Query produce Nullpointer Exception?

Question

why SqlLite query in android produce Nullpointer exception I am using this code

public void onCreate(SQLiteDatabase db)
    {
   String newTableQueryString = "create table " +TABLE_NAME +" (" +
                                    TABLE_ROW_ID + " integer primary key autoincrement not null," +
                                    TABLE_ROW_ONE + " text," +
                                    TABLE_ROW_TWO + " text" +
                                    ");";
Log.e("check","table have been created"+newTableQueryString);
        try{

            mdb.execSQL(newTableQueryString);//it produce exce[ption
        }catch(Exception e)
        {
            Log.e("Exception"," "+ e.getMessage());
             e.printStackTrace();
            }
    }

mdb is reference of DataBaseManager class which contains code of table creation.. — Sandeep Tiwari
– Sandeep Tiwari, Commented Feb 22, 2012 at 8:05

Mike Bockus · Accepted Answer · 2012-02-22 03:07:36Z

1

My guess is mdb is null when you call:

 mdb.execSQL(newTableQueryString);

Did you mean to invoke the execSQL method on the db method parameter that you're passing into the onCreate method?

answered Feb 22, 2012 at 3:07

Mike Bockus

2,07918 silver badges23 bronze badges

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

2 Comments

Sandeep Tiwari Over a year ago

this method is present in class DataBaseManager and I am making object of This class in Resume Method of launching Activity.

Mike Bockus Over a year ago

Take a look at the Activity Lifecycle. The onResume() method is not invoked until after onCreate(), so that is why mdb is null in the onCreate method.

Collectives™ on Stack Overflow

Sqlite Query produce Nullpointer Exception?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related