Getting CursorIndexOutOfBoundsException while using Sqlite DB

Question

I'm using this code to get the count from the cursor. On executing the Select query in SQLite Manager I am getting count as 6.

public int getCount(String name){           
        Cursor cursor;
        cursor = myDataBase.rawQuery(
                "select count(*) as _count from tProviderNode where parentId IN(select identifier from tProviderNode where name='"
                        + name + "');", null);
        return cursor.getInt(cursor.getColumnIndex("_count"));
    }

On execution of this function I'm getting the following error:-

android.database.CursorIndexOutOfBoundsException: Index -1 requested, with a size of 1

Why I'm getting this error? Am I missing anything.

may be your name is not matching with the db-column's value, it may be possible that your db-col contains white space. — Lucifer
– Lucifer, Commented Oct 4, 2012 at 10:00
a little search before asking the question would have given you the answer in no time — njzk2
– njzk2, Commented Oct 4, 2012 at 10:04

user · Accepted Answer · 2012-10-04 10:00:49Z

3

Call cursor.moveToFirst() before you use the Cursor:

// ...
cursor.moveToFirst();
return cursor.getInt(cursor.getColumnIndex("_count"));

answered Oct 4, 2012 at 10:00

user

87.1k18 gold badges200 silver badges190 bronze badges

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

Comments

Rajeev N B · Accepted Answer · 2012-10-04 10:03:25Z

0

Call cursor.moveToFirst() to fix the issue.

answered Oct 4, 2012 at 10:03

Rajeev N B

1,3632 gold badges12 silver badges24 bronze badges

Collectives™ on Stack Overflow

Getting CursorIndexOutOfBoundsException while using Sqlite DB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related