Getting null pointer exception at sqlite query

Question

Getting a null pointer exception at squlite query.

Following is my code snippet

String myPath = DB_PATH + DATABASE_NAME;
    SQLiteDatabase checkDB = null;     
    checkDB = SQLiteDatabase.openDatabase(myPath, null,SQLiteDatabase.OPEN_READONLY);
    if(checkDB != null){
    Cursor  cursor = database.rawQuery("SELECT Id, UserName FROM Login Where status="+ 1, null);
        if(cursor != null ) {
            if  (cursor.moveToFirst()){
                String UserName = cursor.getString(cursor.getColumnIndex("UserName"));
                String mail_id = cursor.getString(cursor.getColumnIndex("status"));
                Intent intent = new Intent(MainActivity.this, UserAccount.class);

                /*Sending some arguments*/ 
              Bundle bundle = new Bundle();

                  bundle.putString("UserName",UserName);
                  bundle.putString("Id", mail_id);
                  intent.putExtras(bundle);
                  startActivity(intent);

When I debugged the code, I have got a path value in checkDB variable but cursor value is null. So that I have getting null pointer exception at the line

        Cursor  cursor = database.rawQuery("SELECT Id, UserName FROM Login Where status="+ 1, null);

I couldn't find the source of reason, Please help me...

If you change to Cursor cursor = database.rawQuery("SELECT Id, UserName FROM Login Where status=1", null); does it works? — mt0s
– mt0s, Commented Jan 30, 2014 at 1:10

Martin Cazares · Accepted Answer · 2014-01-30 01:18:01Z

1

Where is the "database" variable initialized, because seems like what you should be using is "checkDB", maybe database variable is null by the time you are doing the rawQuery, didn't you want to go for checkDB.rawQuery(... instead?

Regards!

answered Jan 30, 2014 at 1:18

Martin Cazares

13.7k10 gold badges49 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Getting null pointer exception at sqlite query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related