What does CursorIndexOutOfBoundsException mean?

Question

InfoAPI.java

When I click Save button, it crashed. How can I fix this?

public long insertTimeSheet(String name,String weather,String date,String status)
    {
        database=dbHelper.getWritableDatabase();
        ContentValues values=new ContentValues();
        values.put(MyDatabaseHelper.Name,name);
        values.put(MyDatabaseHelper.Weather,weather);
        values.put(MyDatabaseHelper.Date,date);
        values.put(MyDatabaseHelper.Status, status);
        Cursor cursor = database.rawQuery("SELECT MAX(ID) FROM "+ MyDatabaseHelper.TABLE_INFO, null);
        database.insert(MyDatabaseHelper.TABLE_INFO, null, values);
        return cursor.getLong(0);

    }

LogCat

android.database.CursorIndexOutOfBoundsException: Index -1 requested, with a size of 1
            at android.database.AbstractCursor.checkPosition(AbstractCursor.java:460)
            at android.database.AbstractWindowedCursor.checkPosition(AbstractWindowedCursor.java:136)
            at android.database.AbstractWindowedCursor.getLong(AbstractWindowedCursor.java:74)
            at com.example.project.project.API.InfoAPI.insertTimeSheet(InfoAPI.java:42)

I have posted a question regarding to Foreign Key.

Getting NULL value in foreign key column

what do you need `cursor` for? why dont you return `database.insert()` return value ? — pskink, Oct 07 '15 at 17:19
`insert()` returns the count of inserted rows. Then, simply use `return database.insert(MyDatabaseHelper.TABLE_INFO, null, values);`. For your reference: http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#insert(java.lang.String,%20java.lang.String,%20android.content.ContentValues) — Phantômaxx, Oct 07 '15 at 17:25
ok i dont get your logic, if you need your `Cursor` call `moveToFirst()` — pskink, Oct 07 '15 at 17:26
NO. I updated my comment. Same goes for `update()` and `delete()`. — Phantômaxx, Oct 07 '15 at 17:27
The one I have shown in my previous comment. The instruction in `grey`. — Phantômaxx, Oct 07 '15 at 17:30

score 1 · Answer 1 · answered Oct 07 '15 at 17:28

A CursorIndexOutOfBoundsException means that the Cursor by which you are trying to obtain or write data is not currently positioned at a valid result row. Note in particular that the Cursor obtained from rawQuery() is initially positioned just before the first row. This is sensible in part because it's the only place the Cursor can be positioned in the event that the query returns zero rows.

You would ordinarily use the cursor's positioning methods to move it to the row you want to access. For processing all rows in order, that would typically be moveToNext(). There is also moveToFirst(), moveToLast(), moveToPrevious(), moveToPosition(), and move().

Deepak Goyal · Accepted Answer · 2015-10-07T18:09:19.320

0

public long insertTimeSheet(String name,String weather,String date,String status){
  database=dbHelper.getWritableDatabase();
  ContentValues values=new ContentValues();
  values.put(MyDatabaseHelper.Name,name);
  values.put(MyDatabaseHelper.Weather,weather);
  values.put(MyDatabaseHelper.Date,date);
  values.put(MyDatabaseHelper.Status, status);
  database.insert(MyDatabaseHelper.TABLE_INFO, null, values);
  Cursor cursor = database.rawQuery("SELECT MAX(ID) FROM "+ MyDatabaseHelper.TABLE_INFO, null);
  if(cursor.getCount()>0){
    cursor.moveToFirst();
    return cursor.getLong(0);
  }

  return 0;
}

edited Oct 07 '15 at 18:09

answered Oct 07 '15 at 17:45

Deepak Goyal

4,747
2
21
46

on what line you are getting the exception. – Deepak Goyal Oct 07 '15 at 18:01
CursorIndexOutOfBoundsException – Deepak Goyal Oct 07 '15 at 18:02
You can see my previous post, I follow user Randyka Yudhistira's method but get 'CursorIndexOutOfBoundsException' error. You can refer here http://stackoverflow.com/questions/32986635/getting-null-value-in-foreign-key-column – John Oct 07 '15 at 18:04

What does CursorIndexOutOfBoundsException mean?

2 Answers2