Fatal exception when reading data from cursor from SQLite

Question

In AsyncTask I read database table (one-by-one) like this:

Cursor result = database.query("country", new String[] { "_id", "name", "var1", "var2", "var3", "var4", "rightanswer", "time1", "time2", "time3" }, "_id=" + id, null, null, null, null);
result.moveToFirst();

Then, I print result.getColumnCount() and receive 10.

But when I trying to print data like this:

 System.out.println(result.getString(result.getColumnIndex("name")));
 System.out.println(result.getString(result.getColumnIndex("var1")));
 System.out.println(result.getString(result.getColumnIndex("var2")));
 System.out.println(result.getString(result.getColumnIndex("var3")));
 System.out.println(result.getString(result.getColumnIndex("var4")));
 System.out.println(result.getString(result.getColumnIndex("rightanswer")));
 System.out.println(result.getString(result.getColumnIndex("time1")));
 System.out.println(result.getString(result.getColumnIndex("time2")));
 System.out.println(result.getString(result.getColumnIndex("time3")));

I receive error AndroidRuntime(8279): FATAL EXCEPTION: AsyncTask #1

AndroidRuntime(8279): Caused by: java.lang.NullPointerException

But, when I print only two first columns,

 System.out.println(result.getString(result.getColumnIndex("name")));
 System.out.println(result.getString(result.getColumnIndex("var1")));

It's fully working.

I have no clue.

UPDATE:

  String createQuery = "CREATE TABLE country (_id integer primary key autoincrement,name, var1, var2,var3,var4,rightanswer, time1,time2,time3);";                 
   db.execSQL(createQuery);

It may the 'var2' is returning null

Pankaj Kumar
– Pankaj Kumar

2013-05-06 09:09:21 +00:00
Commented May 6, 2013 at 9:09 — Pankaj Kumar
– Pankaj Kumar, Commented May 6, 2013 at 9:09
show the db.create query

Blackbelt
– Blackbelt

2013-05-06 09:10:03 +00:00
Commented May 6, 2013 at 9:10 — Blackbelt
– Blackbelt, Commented May 6, 2013 at 9:10
Which line throws the NPE?

BobTheBuilder
– BobTheBuilder

2013-05-06 09:11:35 +00:00
Commented May 6, 2013 at 9:11 — BobTheBuilder
– BobTheBuilder, Commented May 6, 2013 at 9:11
may be there is no string value in "var2" column

Prachi
– Prachi

2013-05-06 10:07:07 +00:00
Commented May 6, 2013 at 10:07 — Prachi
– Prachi, Commented May 6, 2013 at 10:07
Show the entire stack trace!

CL.
– CL.

2013-05-06 11:53:48 +00:00
Commented May 6, 2013 at 11:53 — CL.
– CL., Commented May 6, 2013 at 11:53

Adam Arold · Accepted Answer · 2013-05-06 09:12:12Z

1

It seems that the value

result.getString(result.getColumnIndex("var2"))

returns is null. You can enter debug mode in your IDE and verify that.

Another possibility is that you don't even have a column named var2 in your database. In that case the getColumnIndex will return null.

If you provide us more information like your db schema we can help you more.

answered May 6, 2013 at 9:12

Adam Arold

30.8k25 gold badges123 silver badges226 bronze badges

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

1 Comment

JohnDow Over a year ago

I check columns names of course. Then, I checked data and fill every column.

Collectives™ on Stack Overflow

Fatal exception when reading data from cursor from SQLite

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related