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

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

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

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

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related