Android - SQLite Cursor getColumnIndex() is case sensitive?

android sqlite cursor illegalstateexception
Yaqub Ahmad picture Yaqub Ahmad · Jan 27, 2012 · Viewed 8.3k times · Source

While working with SQLiteCursor in Android i came to know that the getColumnIndex() is behaving case sensitive for example:

Example:

Column Name in DB was: Rules
cursor.getColumnIndex("Rules")  //workes fine
cursor.getColumnIndex("rules")  //throws error, see the error detail

The documentation says nothing about that, for detail please see this.

LogCat says:

java.lang.IllegalStateException: Couldn't read row 0, col -1 from CursorWindow. Make sure the Cursor is initialized correctly before accessing data from it

I am confused by this behavior of SQLiteCursor, can someone help me that this is true OR i am doing something wrong? I can provide the code if required.

Thanks.

Answer

Yaqub Ahmad picture Yaqub Ahmad · Mar 7, 2012

getColumnIndex() is case sensitive:

Column Name in DB was: Rules

cursor.getColumnIndex("Rules") //workes fine

cursor.getColumnIndex("rules") //throws error, see the error detail

Related questions

Iterate through rows from Sqlite-query

I have a table layout that I want to populate with the result from a database query. I use a select all and the query returns four rows of data. I use this code to populate the TextViews inside the …

Read More
SQLite Android Database Cursor window allocation of 2048 kb failed

I have a routine that runs different queries against an SQLite database many times per second. After a while I would get the error "android.database.CursorWindowAllocationException: - Cursor window allocation of 2048 kb failed. # Open Cursors = " appear in LogCat. I …

Read More
Android SimpleCursorAdapter doesn't update when database changes

I have an Android ListActivity that is backed by a database Cursor through a SimpleCursorAdapter. When the items are clicked, a flag field in the coresponding row in the database is toggled and the view in the list needs to …

Read More