Databases
StackOverflow2013
Postsdbo
POParsing JSON in Android?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POParsing JSON in Android?
    primarykey
    data
    text
    <p>Hello Android programmers,</p> <p>I am making a currency application and to do this, I am getting my currency rates from the following website (that returns json):</p> <p><a href="https://raw.github.com/currencybot/open-exchange-rates/master/latest.json" rel="nofollow">https://raw.github.com/currencybot/open-exchange-rates/master/latest.json</a></p> <p>Here is the method in my program that gets all of the rates found on the website.</p> <pre><code>public String[] fetchCurrencyRates() { String[] currencyValues = new String[currency_array.length]; //currency_array has the names of all the currencies try { URL currency = new URL("https://raw.github.com/currencybot/open-exchange-rates/master/latest.json"); URLConnection c = currency.openConnection(); BufferedReader in = new BufferedReader(new InputStreamReader(c.getInputStream())); String line; while ((line = in.readLine()) != null) { JSONArray ja = new JSONArray(line); for (int i = 0; i &lt; ja.length(); i++) { JSONObject jo = (JSONObject) ja.get(i); currencyValues[i] = (jo.getString("rates")); } } } catch (MalformedURLException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } catch (JSONException e) { e.printStackTrace(); } return currencyValues; } </code></pre> <p>This method does not work for some reason. I will now post the LogCat in order to help me debug this method.</p> <pre><code>03-29 13:42:21.323: E/AndroidRuntime(678): FATAL EXCEPTION: main 03-29 13:42:21.323: E/AndroidRuntime(678): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.sapra.currency/com.sapra.currency.TheUltimateCurrencyConverterActivity}: android.os.NetworkOnMainThreadException 03-29 13:42:21.323: E/AndroidRuntime(678): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1956) 03-29 13:42:21.323: E/AndroidRuntime(678): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1981) 03-29 13:42:21.323: E/AndroidRuntime(678): at android.app.ActivityThread.access$600(ActivityThread.java:123) 03-29 13:42:21.323: E/AndroidRuntime(678): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147) 03-29 13:42:21.323: E/AndroidRuntime(678): at android.os.Handler.dispatchMessage(Handler.java:99) 03-29 13:42:21.323: E/AndroidRuntime(678): at android.os.Looper.loop(Looper.java:137) 03-29 13:42:21.323: E/AndroidRuntime(678): at android.app.ActivityThread.main(ActivityThread.java:4424) 03-29 13:42:21.323: E/AndroidRuntime(678): at java.lang.reflect.Method.invokeNative(Native Method) 03-29 13:42:21.323: E/AndroidRuntime(678): at java.lang.reflect.Method.invoke(Method.java:511) 03-29 13:42:21.323: E/AndroidRuntime(678): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784) 03-29 13:42:21.323: E/AndroidRuntime(678): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551) 03-29 13:42:21.323: E/AndroidRuntime(678): at dalvik.system.NativeStart.main(Native Method) 03-29 13:42:21.323: E/AndroidRuntime(678): Caused by: android.os.NetworkOnMainThreadException 03-29 13:42:21.323: E/AndroidRuntime(678): at android.os.StrictMode$AndroidBlockGuardPolicy.onNetwork(StrictMode.java:1099) 03-29 13:42:21.323: E/AndroidRuntime(678): at java.net.InetAddress.lookupHostByName(InetAddress.java:391) 03-29 13:42:21.323: E/AndroidRuntime(678): at java.net.InetAddress.getAllByNameImpl(InetAddress.java:242) 03-29 13:42:21.323: E/AndroidRuntime(678): at java.net.InetAddress.getAllByName(InetAddress.java:220) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpConnection.&lt;init&gt;(HttpConnection.java:71) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpConnection.&lt;init&gt;(HttpConnection.java:50) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpConnection$Address.connect(HttpConnection.java:351) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpConnectionPool.get(HttpConnectionPool.java:86) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpConnection.connect(HttpConnection.java:128) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpEngine.openSocketConnection(HttpEngine.java:308) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpsURLConnectionImpl$HttpsEngine.makeSslConnection(HttpsURLConnectionImpl.java:460) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpsURLConnectionImpl$HttpsEngine.connect(HttpsURLConnectionImpl.java:432) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpEngine.sendSocketRequest(HttpEngine.java:282) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpEngine.sendRequest(HttpEngine.java:232) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpURLConnectionImpl.getResponse(HttpURLConnectionImpl.java:273) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpURLConnectionImpl.getInputStream(HttpURLConnectionImpl.java:168) 03-29 13:42:21.323: E/AndroidRuntime(678): at libcore.net.http.HttpsURLConnectionImpl.getInputStream(HttpsURLConnectionImpl.java:270) 03-29 13:42:21.323: E/AndroidRuntime(678): at com.sapra.currency.TheUltimateCurrencyConverterActivity.fetchCurrencyRates(TheUltimateCurrencyConverterActivity.java:60) 03-29 13:42:21.323: E/AndroidRuntime(678): at com.sapra.currency.TheUltimateCurrencyConverterActivity.onCreate(TheUltimateCurrencyConverterActivity.java:51) 03-29 13:42:21.323: E/AndroidRuntime(678): at android.app.Activity.performCreate(Activity.java:4465) 03-29 13:42:21.323: E/AndroidRuntime(678): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049) 03-29 13:42:21.323: E/AndroidRuntime(678): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920) 03-29 13:42:21.323: E/AndroidRuntime(678): ... 11 more </code></pre> <p>I have confirmed that this method is the cause of the problem, as I commented out the call to this method and the program did function as expected.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USWarrenFaith
    1. USsameetandpotatoes
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COCan you address the exception?
      singulars
      1. POParsing JSON in Android?
      1. This table or related slice is empty.
    2. CO[networkOnMainThreadException](http://stackoverflow.com/q/9729825/940096) this can be helps you lot.
      singulars
      1. POParsing JSON in Android?
      1. USPraveenkumar
    3. COWhat do you mean? Sorry, I don't understand. Haven't I already done that by posting the LogCat?
      singulars
      1. POParsing JSON in Android?
      1. USsameetandpotatoes
 

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