java.lang.IllegalArgumentException: Cannot bind argument at index 0 because the index is out of range. The statement has 4 parameters

Question

Android SQLLite gives me the following error:

 SQLiteStatement tgStatement = dbo.compileStatement("INSERT OR REPLACE INTO Game_Team" +
                "(teamId, gameId, pos, score) VALUES (?,?,?,?) ");

Thats why I try to do:

tgStatement.bindLong(0, 1);

I get an error

java.lang.IllegalArgumentException: Cannot bind argument at index 0 because the index is out of range.

The statement has 4 parameters.

So, my question is, if there are 4 parameters, why is it complaining about argument at index 0? how is that out of range?

khelwood · Accepted Answer · 2014-08-31 00:16:55Z

8

The parameters are 1-indexed. The index needs to run from 1 to 4, so 0 is out of range.

answered Aug 31, 2014 at 0:16

khelwood

59.7k14 gold badges91 silver badges116 bronze badges

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

1 Comment

TatiOverflow Over a year ago

Oh wow. just when I didn't expect. I spent countless hours trying to figure this out. Searching left and right, and then I finally broke... thank you very much!

Raf · Accepted Answer · 2014-08-31 00:32:19Z

2

This trick might come handy to some.

SQLiteStatement tgStatement = dbo.compileStatement("INSERT OR REPLACE INTO Game_Team" +
                "(teamId, gameId, pos, score) VALUES (?,?,?,?) ");
    int i = 1;
    tgStatement.bindLong(i++, teamId);
    tgStatement.bindLong(i++, gameId);
    tgStatement.bindString(i++, pos);
    tgStatement.bindLong(i++, score);

Above trick is useful when you have more parameters, it avoid missing on indices as well as numbering them. i variable handles the indice.

answered Aug 31, 2014 at 0:32

Raf

7,6491 gold badge44 silver badges60 bronze badges

Comments

user3970006 · Accepted Answer · 2014-08-31 00:15:46Z

1

Indices start at 1. So it's setLong(1,1)

answered Aug 31, 2014 at 0:15

user3970006

1511 bronze badge

Collectives™ on Stack Overflow

java.lang.IllegalArgumentException: Cannot bind argument at index 0 because the index is out of range. The statement has 4 parameters

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related