Android SQLite Aggregate Function Error

Question

I'm running the following query:

String q = "select " + MySQLiteHelper.COLUMN_ID + ", "
        + MySQLiteHelper.COLUMN_TASK + ", "
        + MySQLiteHelper.COLUMN_PARENT + ", count(*) from "
        + MySQLiteHelper.TABLE_TASKS + " where "
        + MySQLiteHelper.COLUMN_ID + " = " + insertId + " group by "
        + MySQLiteHelper.COLUMN_ID + ", " + MySQLiteHelper.COLUMN_TASK
        + ", " + MySQLiteHelper.COLUMN_PARENT;
Cursor cursor = database.rawQuery(q, null);

When I read the retrieved data like so:

task.setId(cursor.getLong(0));
task.setTask(cursor.getString(1));
task.setParent(cursor.getLong(2));
task.setChildren(cursor.getInt(3));

I get the following error:

03-15 22:15:06.078: E/AndroidRuntime(31426):
    java.lang.IllegalStateException:
    Couldn't read row 0, col 3 from CursorWindow.
    Make sure the Cursor is initialized correctly before accessing data from it.

If I remove the line

task.setChildren(cursor.getInt(3));

It works fine.

Can anyone tell me what is wrong here and how to fix it?

Sorry about this. I just found the error. I had that query in two places and was editing the wrong one. (I left the count(*) off the other one.) Thanks for all your help. All the suggestions worked fine once I realized my mistake. — Ruckus T-Boom
– Ruckus T-Boom, Commented Mar 16, 2013 at 5:32

appsroxcom · Accepted Answer · 2013-03-16 05:09:33Z

3

Try replacing this line

+ MySQLiteHelper.COLUMN_PARENT + ", count(*) from "

by

+ MySQLiteHelper.COLUMN_PARENT + ", count(*) as total from "

Edit: Also try replacing

task.setChildren(cursor.getInt(3));

by

task.setChildren((int)cursor.getLong(3));

or may be

task.setChildren(Integer.parseInt(cursor.getString(3)));

edited Mar 16, 2013 at 5:09

answered Mar 16, 2013 at 4:44

appsroxcom

2,82115 silver badges17 bronze badges

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

1 Comment

Ruckus T-Boom Over a year ago

I tried changing the query to say '...", count(*) as children from "...' and using 'n = cursor.getColumnIndex("children");', but I still get the same error.

GrIsHu · Accepted Answer · 2013-03-16 04:49:14Z

1

You are directly trying to access the 3 column from the cursor but your third column is the count and you didn't specified the alias for that column that is why you are getting this error. Just try to put the alias of the column name and then try to access it as below:

Replace this line

   + MySQLiteHelper.COLUMN_PARENT + ", count(*) from "

by

    + MySQLiteHelper.COLUMN_PARENT + ", count(*) as total from "

answered Mar 16, 2013 at 4:49

GrIsHu

23.6k9 gold badges62 silver badges96 bronze badges

1 Comment

Ruckus T-Boom Over a year ago

See what I said in response to @appsroxcom

Collectives™ on Stack Overflow

Android SQLite Aggregate Function Error

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related