Android - CursorIndexOutOfBoundsExpection d'une table de base de données SQLite existante - Stack Overflow

I am having an error with calling from one of my tables in my database.

Using:

public Cursor getTable(String table, String where) {

        SQLiteDatabase db = getReadableDatabase();
        SQLiteQueryBuilder qb = new SQLiteQueryBuilder();


        qb.setTables(table);
        Cursor c = qb.query(db, null, where, null,
                null, null, null);

        c.moveToFirst();
        return c;

    }

And:

public Armor(Cursor generalItems, Cursor armorItems){
        id = generalItems.getInt(0);
        name = generalItems.getString(1);
        armor = armorItems.getInt(2);
        slot = armorItems.getInt(3);
        bonusStat = armorItems.getInt(4);
        bonusAmount = armorItems.getInt(5);
    }

This works:

currentZone.c1.setChest(new Armor(db.getTable("items", "_id = 2"), db.getTable("armor", "itemid = 2")));

I am doing basically the exact same thing with my Weapon class, but I get this error:

03-29 00:50:08.426: E/AndroidRuntime(14696): FATAL EXCEPTION: main
03-29 00:50:08.426: E/AndroidRuntime(14696): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.rpgengine/com.example.rpgengine.MainActivity}: android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2059)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2084)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.access$600(ActivityThread.java:130)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1195)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.os.Handler.dispatchMessage(Handler.java:99)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.os.Looper.loop(Looper.java:137)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.main(ActivityThread.java:4745)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at java.lang.reflect.Method.invokeNative(Native Method)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at java.lang.reflect.Method.invoke(Method.java:511)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at dalvik.system.NativeStart.main(Native Method)
03-29 00:50:08.426: E/AndroidRuntime(14696): Caused by: android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.database.AbstractCursor.checkPosition(AbstractCursor.java:418)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.database.AbstractWindowedCursor.checkPosition(AbstractWindowedCursor.java:136)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.database.AbstractWindowedCursor.getInt(AbstractWindowedCursor.java:68)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at com.example.rpgengine.Weapon.<init>(Weapon.java:16)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at com.example.rpgengine.MainActivity.onCreate(MainActivity.java:81)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.Activity.performCreate(Activity.java:5008)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1079)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2023)
03-29 00:50:08.426: E/AndroidRuntime(14696):    ... 11 more

I assumed there was an error in my database, and I checked the table - it seems correct to me. Here is a screenshot:

Here is the suspect call, and the function itself:

currentZone.c1.setWeapon(new Weapon(db.getTable("items", "_id = 1"), db.getTable("weapons", "itemid = 1")));

and

public Weapon(Cursor generalItems, Cursor weaponItems){
        id = generalItems.getInt(0);
        name = generalItems.getString(1);
        hand = weaponItems.getInt(2);
        damage = weaponItems.getInt(3);
        bonusStat = weaponItems.getInt(4);
        bonusAmount = weaponItems.getInt(5);
    }

The error is in the weaponItems cursor.

Any help would be greatly appreciated.

I am having an error with calling from one of my tables in my database.

Using:

public Cursor getTable(String table, String where) {

        SQLiteDatabase db = getReadableDatabase();
        SQLiteQueryBuilder qb = new SQLiteQueryBuilder();


        qb.setTables(table);
        Cursor c = qb.query(db, null, where, null,
                null, null, null);

        c.moveToFirst();
        return c;

    }

And:

public Armor(Cursor generalItems, Cursor armorItems){
        id = generalItems.getInt(0);
        name = generalItems.getString(1);
        armor = armorItems.getInt(2);
        slot = armorItems.getInt(3);
        bonusStat = armorItems.getInt(4);
        bonusAmount = armorItems.getInt(5);
    }

This works:

currentZone.c1.setChest(new Armor(db.getTable("items", "_id = 2"), db.getTable("armor", "itemid = 2")));

I am doing basically the exact same thing with my Weapon class, but I get this error:

03-29 00:50:08.426: E/AndroidRuntime(14696): FATAL EXCEPTION: main
03-29 00:50:08.426: E/AndroidRuntime(14696): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.rpgengine/com.example.rpgengine.MainActivity}: android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2059)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2084)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.access$600(ActivityThread.java:130)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1195)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.os.Handler.dispatchMessage(Handler.java:99)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.os.Looper.loop(Looper.java:137)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.main(ActivityThread.java:4745)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at java.lang.reflect.Method.invokeNative(Native Method)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at java.lang.reflect.Method.invoke(Method.java:511)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:786)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at dalvik.system.NativeStart.main(Native Method)
03-29 00:50:08.426: E/AndroidRuntime(14696): Caused by: android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.database.AbstractCursor.checkPosition(AbstractCursor.java:418)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.database.AbstractWindowedCursor.checkPosition(AbstractWindowedCursor.java:136)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.database.AbstractWindowedCursor.getInt(AbstractWindowedCursor.java:68)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at com.example.rpgengine.Weapon.<init>(Weapon.java:16)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at com.example.rpgengine.MainActivity.onCreate(MainActivity.java:81)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.Activity.performCreate(Activity.java:5008)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1079)
03-29 00:50:08.426: E/AndroidRuntime(14696):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2023)
03-29 00:50:08.426: E/AndroidRuntime(14696):    ... 11 more

I assumed there was an error in my database, and I checked the table - it seems correct to me. Here is a screenshot:

Here is the suspect call, and the function itself:

currentZone.c1.setWeapon(new Weapon(db.getTable("items", "_id = 1"), db.getTable("weapons", "itemid = 1")));

and

public Weapon(Cursor generalItems, Cursor weaponItems){
        id = generalItems.getInt(0);
        name = generalItems.getString(1);
        hand = weaponItems.getInt(2);
        damage = weaponItems.getInt(3);
        bonusStat = weaponItems.getInt(4);
        bonusAmount = weaponItems.getInt(5);
    }

The error is in the weaponItems cursor.

Any help would be greatly appreciated.

Source