Exception when request an image from database

Question

My Cursor is always -1 when i send a request to my database (sqlite) to load an image.

public Cursor getData(int id){

        SQLiteDatabase db = this.getWritableDatabase();
        String query = "SELECT * FROM " + TABLE_NAME + " WHERE ID = " + id;
        Log.d(TAG, query);
        Cursor data = db.rawQuery(query, null);
        return data;
}

The result is an app crash and this log in the logcat:

FATAL EXCEPTION: main Process: com.master.tobias.phono, PID: 10721 android.database.CursorIndexOutOfBoundsException: Index -1 requested, with a size of 1

Edit: The query works fine with the DB Browser for SQLite.

Here is nice explanation https://stackoverflow.com/a/12445030/1854103. Basically you should call data.moveToFirst() (in your case is cursor named data) — Tijkijiki, Dec 28 '18 at 13:14

score 1 · Accepted Answer · answered Dec 28 '18 at 13:10

1

Try cursor.moveToFirst() before accessing the cursor data

answered Dec 28 '18 at 13:10

touhid udoy

4,005
2
18
31

Rahul Chokshi · Answer 2 · 2018-12-28T13:22:26.807

0

try this one

public Cursor getData(int id){

        SQLiteDatabase db = this.getWritableDatabase();
        String query = "SELECT * FROM " + TABLE_NAME + " WHERE ID = " + id;
        Log.d(TAG, query);
        Cursor cursor= db.rawQuery(query, null);
        while(cursor.moveToFirst()){
          //get your value over here
        }
        return data;
}

edited Dec 28 '18 at 13:22

answered Dec 28 '18 at 13:13

Rahul Chokshi

670
4
18

score 0 · Answer 3 · answered Dec 28 '18 at 13:23

It's also beneficial to look at the Android documentation of methods as it provides more information as to what the method if expecting as parameters and will be returning. Firstly, the db.rawQuery

Runs the provided SQL and returns a Cursor over the result set.
SQLiteDatabase

As for the cursor, you need to check the existence of an object with the Cursor variable. This can be done via using the following method:

cursor.moveToFirst();

Move the cursor to the next row.
This method will return false if the cursor is already past the last entry in the result set.
Cursor

This method will return a boolean which you can use for further validation. If the boolean is false, the cursor doesn't contain any data/objects within. If it's true, you know you have existence of the data.

Therefore, you are missing this functionality where you'll need to move the object to the first row which will allow you to determine if the query was empty or not.

Exception when request an image from database

3 Answers3