Databases
StackOverflow2013
Postsdbo
POAndroid JsonReader can't iterate json array
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAndroid JsonReader can't iterate json array
    primarykey
    data
    text
    <p>I'm playing with <code>JsonReader</code> which is a streaming JSON parser in Android, and I met a problem that the parser won't go over all the items in an json array, it will only return me the first item.</p> <p>Here's the code I use to do the parsing:</p> <pre><code>private ArrayList&lt;Result&gt; readResultsArray(JsonReader reader) throws IOException { ArrayList&lt;Result&gt; results = new ArrayList&lt;Result&gt;(); reader.beginObject(); while (reader.hasNext()) { String name = reader.nextName(); if (name.equals("results")){ reader.beginArray(); while (reader.hasNext()) { results.add(readResult(reader)); } reader.endArray(); } else { reader.skipValue(); } } reader.endObject(); return results; } </code></pre> <p>I'm sure that the method <code>readResult(reader)</code> would parse and return the first object in the array without any problem.</p> <p>But the reader seemed just "ignore" the second object in the array.</p> <p>Here's the <code>readResult(reader)</code> method:</p> <pre><code> private Result readResult(JsonReader reader) throws IOException { String from_user = null, from_user_id_str = null, from_user_name = null, text = null; Geo geo = null; URL profile_image_url = null; reader.beginObject(); while (reader.hasNext()) { String name = reader.nextName(); if (name.equals("from_user")){ from_user = reader.nextString(); Log.i(TAG, from_user); } else if (name.equals("from_user_id_str")) { from_user_id_str = reader.nextString(); Log.i(TAG, from_user_id_str); } else if (name.equals("from_user_name")) { from_user_name = reader.nextString(); Log.i(TAG, from_user_name); } else if (name.equals("geo")) { reader.beginObject(); while(reader.hasNext()) { // String s = reader.nextName(); if (name.equals("coordinates")) { reader.beginArray(); double latitude = 0; double longitude = 0; while (reader.hasNext()) { latitude = reader.nextDouble(); longitude = reader.nextDouble(); Log.i(TAG, latitude + ", " + longitude); geo = new Geo(latitude, longitude); } reader.endArray(); } else { reader.skipValue(); } } reader.endObject(); } else if (name.equals("profile_image_url")) { profile_image_url = new URL(reader.nextString()); } else if (name.equals("text")) { text = reader.nextString(); Log.i(TAG, text); } else { reader.skipValue(); } } reader.endObject(); return new Result(from_user, from_user_id_str, from_user_name, text, geo, profile_image_url); } } </code></pre> <p>Here's the JSON I tried to parse:</p> <p>(It is a Twitter search response, the original response is presented like below, <a href="http://search.twitter.com/search.json?q=%E5%90%83&amp;geocode=51.483372,-3.190826,200mi" rel="nofollow">Link</a>)</p> <pre><code>{ "completed_in": 0.067, "max_id": 320160565840457730, "max_id_str": "320160565840457730", "page": 1, "query": "%E5%90%83", "refresh_url": "?since_id=320160565840457730&amp;q=%E5%90%83&amp;geocode=51.483372%2C-3.190826%2C200mi", "results": [ { "created_at": "Fri, 05 Apr 2013 13:06:41 +0000", "from_user": "missmanchu", "from_user_id": 359296258, "from_user_id_str": "359296258", "from_user_name": "miss manchu ", "geo": null, "location": "London, United Kingdom", "id": 320160565840457730, "id_str": "320160565840457730", "iso_language_code": "ja", "metadata": { "result_type": "recent" }, "profile_image_url": "http://a0.twimg.com/profile_images/3470783234/6ae4049d90a052c7a9c7f86ec804e523_normal.jpeg", "profile_image_url_https": "https://si0.twimg.com/profile_images/3470783234/6ae4049d90a052c7a9c7f86ec804e523_normal.jpeg", "source": "&amp;lt;a href=&amp;quot;http://twitter.com/download/iphone&amp;quot;&amp;gt;Twitter for iPhone&amp;lt;/a&amp;gt;", "text": "RT @lougirlie: Delish Taiwanese-style bao by @missmanchu for lunch. 好吃！ http://t.co/clRznskvqe" }, { "created_at": "Fri, 05 Apr 2013 11:45:09 +0000", "from_user": "lougirlie", "from_user_id": 154974289, "from_user_id_str": "154974289", "from_user_name": "Louise Chow", "geo": { "coordinates": [ 51.5216788595, -0.1420583511 ], "type": "Point" }, "id": 320140044142772224, "id_str": "320140044142772224", "iso_language_code": "ja", "metadata": { "result_type": "recent" }, "place": { "full_name": "Westminster", "id": "548c2b8e3921a85a", "type": "CITY" }, "profile_image_url": "http://a0.twimg.com/profile_images/1750994903/photo_3__4__normal.JPG", "profile_image_url_https": "https://si0.twimg.com/profile_images/1750994903/photo_3__4__normal.JPG", "source": "&amp;lt;a href=&amp;quot;http://twitter.com&amp;quot;&amp;gt;Twitter for iPhone&amp;lt;/a&amp;gt;", "text": "Delish Taiwanese-style bao by @missmanchu for lunch. 好吃！ http://t.co/clRznskvqe" }, { "created_at": "Fri, 05 Apr 2013 10:09:25 +0000", "from_user": "geleikai", "from_user_id": 351512769, "from_user_id_str": "351512769", "from_user_name": "geleikai", "geo": null, "location": "53.762824,-2.707418", "id": 320115951339200512, "id_str": "320115951339200512", "iso_language_code": "zh", "metadata": { "result_type": "recent" }, "profile_image_url": "http://a0.twimg.com/profile_images/3110335584/545b94d39e1628d747428c73a8052bf8_normal.jpeg", "profile_image_url_https": "https://si0.twimg.com/profile_images/3110335584/545b94d39e1628d747428c73a8052bf8_normal.jpeg", "source": "&amp;lt;a href=&amp;quot;http://www.wechatapp.com&amp;quot;&amp;gt;WeChat App&amp;lt;/a&amp;gt;", "text": "吃过午饭，前往阿姆斯特丹 http://t.co/LbQ0Jh7Mfp" }, { "created_at": "Thu, 04 Apr 2013 10:15:05 +0000", "from_user": "hpfly", "from_user_id": 60939059, "from_user_id_str": "60939059", "from_user_name": "0C哈根达斯", "geo": null, "location": "53.805042,-1.544011", "id": 319754991692824576, "id_str": "319754991692824576", "iso_language_code": "zh", "metadata": { "result_type": "recent" }, "profile_image_url": "http://a0.twimg.com/profile_images/3251267049/c56ca4cb888736299548e5454a9d923b_normal.jpeg", "profile_image_url_https": "https://si0.twimg.com/profile_images/3251267049/c56ca4cb888736299548e5454a9d923b_normal.jpeg", "source": "&amp;lt;a href=&amp;quot;http://fanfou.com&amp;quot;&amp;gt;fanfou2.0&amp;lt;/a&amp;gt;", "text": "现在对谈恋爱一点欲望都没有，更多的欲望是告诉我，我内心希望独享一个人的时光。现在特别希望晚睡，而且是晚上一个人吃着宵夜，看着电视。#如果生活可以这么单纯就好了##当然这也是晚睡的牵强理由#" }, { "created_at": "Wed, 03 Apr 2013 15:47:50 +0000", "from_user": "cushingliu", "from_user_id": 87816289, "from_user_id_str": "87816289", "from_user_name": "Cushing", "geo": { "coordinates": [ 0.0, 0.0 ], "type": "Point" }, "id": 319476345325359104, "id_str": "319476345325359104", "iso_language_code": "zh", "metadata": { "result_type": "recent" }, "place": { "full_name": "Batu Ampar", "id": "ddc693317ed3f226", "type": "CITY" }, "profile_image_url": "http://a0.twimg.com/profile_images/3269471232/f89db3764b70bada908ab340a9fb9c85_normal.jpeg", "profile_image_url_https": "https://si0.twimg.com/profile_images/3269471232/f89db3764b70bada908ab340a9fb9c85_normal.jpeg", "source": "&amp;lt;a href=&amp;quot;http://tapbots.com/tweetbot&amp;quot;&amp;gt;Tweetbot for iOS&amp;lt;/a&amp;gt;", "text": "有妈妈做饭吃的感觉真好" } ], "results_per_page": 15, "since_id": 0, "since_id_str": "0" } </code></pre> <p>The only part I'm interested in is <code>"results"</code>, which is an array of two objects.</p> <p>After took a close look at the example in <a href="http://developer.android.com/reference/android/util/JsonReader.html" rel="nofollow">Android Developers - JsonReader</a> as well as this <a href="http://tech.xtremelabs.com/parsing-json-data-efficiently-on-android-jsonreader/" rel="nofollow">nice tutorial</a>, I found mine is basically no difference with theirs.</p> <p>So what's wrong with my code? Why it cannot itinerate the json array?</p> <h1>UPDATE</h1> <p>Pasted the code of <code>readResult(reader)</code></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USdumbfingers
    1. USdumbfingers
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI believe the term you want is iterate, not itinerate.
      singulars
      1. POAndroid JsonReader can't iterate json array
      1. USHalR
    2. COEven though you're sure that *"`readResult(reader)` would parse and return the first object in the array without any problem"*, is there any chance you may not be closing the object properly? I.e. perhaps there's a call to `reader.endObject()` missing in there? It'd be good to share the code for `readResult(reader)` too.
      singulars
      1. POAndroid JsonReader can't iterate json array
      1. USMH.
    3. COI, too, suspect that readResult is being too hungry and eating up more of the json than you suspect. It really looks like the most likely culprit, even though we don't have the source. You're other stuff looks really straightforward.
      singulars
      1. POAndroid JsonReader can't iterate json array
      1. USHalR
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload