API tools faq
paste
Guest User

Untitled

a guest
Jan 18th, 2019
79
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.89 KB | None | 0 0
raw download clone embed print report
  1. 09-29 12:14:49.485: E/AndroidRuntime(4956): FATAL EXCEPTION: AsyncTask #2
  2. 09-29 12:14:49.485: E/AndroidRuntime(4956): java.lang.RuntimeException: An error occured while executing doInBackground()
  3. 09-29 12:14:49.485: E/AndroidRuntime(4956): at android.os.AsyncTask$3.done(AsyncTask.java:266)
  4. 09-29 12:14:49.485: E/AndroidRuntime(4956): at java.util.concurrent.FutureTask$Sync.innerSetException(FutureTask.java:273)
  5. 09-29 12:14:49.485: E/AndroidRuntime(4956): at java.util.concurrent.FutureTask.setException(FutureTask.java:124)
  6. 09-29 12:14:49.485: E/AndroidRuntime(4956): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:307)
  7. 09-29 12:14:49.485: E/AndroidRuntime(4956): at java.util.concurrent.FutureTask.run(FutureTask.java:137)
  8. 09-29 12:14:49.485: E/AndroidRuntime(4956): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1081)
  9. 09-29 12:14:49.485: E/AndroidRuntime(4956): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:574)
  10. 09-29 12:14:49.485: E/AndroidRuntime(4956): at java.lang.Thread.run(Thread.java:1020)
  11. 09-29 12:14:49.485: E/AndroidRuntime(4956): Caused by: java.lang.IllegalStateException: database /data/data/com.irlsolutions.ittrading/databases/ITTrading.sqlite (conn# 0) already closed
  12. 09-29 12:14:49.485: E/AndroidRuntime(4956): at android.database.sqlite.SQLiteDatabase.verifyDbIsOpen(SQLiteDatabase.java:2134)
  13. 09-29 12:14:49.485: E/AndroidRuntime(4956): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1526)
  14. 09-29 12:14:49.485: E/AndroidRuntime(4956): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1508)
  15. 09-29 12:14:49.485: E/AndroidRuntime(4956): at com.irlsolutions.ittradinglibrary.Query_new.getItemFromEndOfDay(Query_new.java:89)
  16. 09-29 12:14:49.485: E/AndroidRuntime(4956): at com.irlsolutions.ittrading.Symbol_Fetcher.getSymbolFromLocal(Symbol_Fetcher.java:70)
  17. 09-29 12:14:49.485: E/AndroidRuntime(4956): at com.irlsolutions.ittrading.Markets$Markets_Thread.doInBackground(Markets.java:190)
  18. 09-29 12:14:49.485: E/AndroidRuntime(4956): at com.irlsolutions.ittrading.Markets$Markets_Thread.doInBackground(Markets.java:1)
  19. 09-29 12:14:49.485: E/AndroidRuntime(4956): at android.os.AsyncTask$2.call(AsyncTask.java:252)
  20. 09-29 12:14:49.485: E/AndroidRuntime(4956): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)
  21.  
  22. protected Void doInBackground(Void... arg0) {
  23.  
  24. float flt_close1;
  25. float flt_close2;
  26. float variation;
  27.  
  28. // TODO Auto-generated method stub
  29.  
  30. xmlData = XML_Parser_Helper.parseXmlSax(Markets.this, "", R.raw.market_indices_america);
  31. lst_codes = xmlData.getListOfItems();
  32.  
  33. xmlData = XML_Parser_Helper.parseXmlSax(Markets.this, "", R.raw.market_indices_europe);
  34. lst_codes.addAll(xmlData.getListOfItems());
  35.  
  36. xmlData = XML_Parser_Helper.parseXmlSax(Markets.this, "", R.raw.market_indices_asia);
  37. lst_codes.addAll(xmlData.getListOfItems());
  38.  
  39. for(int i = 0; i < lst_codes.size(); i++){
  40. lst_symbols.add(
  41. symbolFetcher.getSymbolFromLocal(
  42. lst_codes.get(i).get("symbol_code").toString(),
  43. lst_codes.get(i).get("market_code").toString(),
  44. xmlData,
  45. "symbols",
  46. lst_codes.get(i).get("chain_code").toString()
  47. )
  48. );
  49. lst_symbols.get(i).put("company_name", lst_codes.get(i).get("company_name").toString());
  50. lst_symbols.get(i).put("symbol_code", lst_codes.get(i).get("symbol_code").toString());
  51. lst_symbols.get(i).put("market_code", lst_codes.get(i).get("market_code").toString());
  52. lst_symbols.get(i).put("chain_code", lst_codes.get(i).get("chain_code").toString());
  53. lst_symbols.get(i).put("flag", lst_codes.get(i).get("flag").toString());
  54.  
  55. flt_close1 = (float)Double.parseDouble((lst_symbols.get(i).get("close_1").toString().equals(""))?"0.0":lst_symbols.get(i).get("close_1").toString());
  56. flt_close2 = (float)Double.parseDouble((lst_symbols.get(i).get("close_2").toString().equals(""))?"0.0":lst_symbols.get(i).get("close_2").toString());
  57. variation = Generic_Functions.getVariation(flt_close1, flt_close2);
  58.  
  59. lst_symbols.get(i).put("variation", variation);
  60.  
  61. if(symbolFetcher.isSymbolAddedToPortfolio(str_username, lst_codes.get(i).get("symbol_code").toString(), lst_codes.get(i).get("market_code").toString())){
  62. lst_symbols.get(i).put("added", true);
  63. }else{
  64. lst_symbols.get(i).put("added", false);
  65. }
  66.  
  67. publishProgress(new Void[]{});
  68. }
  69.  
  70. return null;
  71. }
  72.  
  73. public HashMap<String,Object> getItemFromEndOfDay(String str_symbolCode,String str_marketCode){
  74. HashMap<String,Object> hm = new HashMap<String, Object>();
  75.  
  76. Cursor cursor = database.rawQuery("SELECT * FROM " + Init.TABLE_END_OF_DAY + " WHERE symbol_code='" + str_symbolCode + "' AND market_code='" + str_marketCode + "'", null);
  77.  
  78.  
  79. if(cursor.getCount() > 0){
  80. cursor.moveToFirst();
  81. hm.put("symbol_code", cursor.getString(cursor.getColumnIndex("symbol_code")));
  82. hm.put("market_code", cursor.getString(cursor.getColumnIndex("market_code")));
  83. hm.put("instrument_name", cursor.getString(cursor.getColumnIndex("instrument_name")));
  84. hm.put("company_name", cursor.getString(cursor.getColumnIndex("company_name")));
  85. hm.put("isin", cursor.getString(cursor.getColumnIndex("isin")));
  86. hm.put("interval", cursor.getString(cursor.getColumnIndex("interval")));
  87. hm.put("exchange", cursor.getString(cursor.getColumnIndex("exchange")));
  88. hm.put("ex_open", cursor.getString(cursor.getColumnIndex("ex_open")));
  89. hm.put("ex_close", cursor.getString(cursor.getColumnIndex("ex_close")));
  90. hm.put("currency", cursor.getString(cursor.getColumnIndex("currency")));
  91. hm.put("timezone", cursor.getString(cursor.getColumnIndex("timezone")));
  92.  
  93. hm.put("date_1", cursor.getString(cursor.getColumnIndex("date_1")));
  94. hm.put("hour_1", cursor.getString(cursor.getColumnIndex("hour_1")));
  95. hm.put("open_interest_1", cursor.getString(cursor.getColumnIndex("open_interest_1")));
  96. hm.put("open_1", cursor.getString(cursor.getColumnIndex("open_1")));
  97. hm.put("high_1", cursor.getString(cursor.getColumnIndex("high_1")));
  98. hm.put("low_1", cursor.getString(cursor.getColumnIndex("low_1")));
  99. hm.put("close_1", cursor.getString(cursor.getColumnIndex("close_1")));
  100. hm.put("volume_1", cursor.getString(cursor.getColumnIndex("volume_1")));
  101.  
  102. hm.put("date_2", cursor.getString(cursor.getColumnIndex("date_2")));
  103. hm.put("hour_2", cursor.getString(cursor.getColumnIndex("hour_2")));
  104. hm.put("open_interest_2", cursor.getString(cursor.getColumnIndex("open_interest_2")));
  105. hm.put("open_2", cursor.getString(cursor.getColumnIndex("open_2")));
  106. hm.put("high_2", cursor.getString(cursor.getColumnIndex("high_2")));
  107. hm.put("low_2", cursor.getString(cursor.getColumnIndex("low_2")));
  108. hm.put("close_2", cursor.getString(cursor.getColumnIndex("close_2")));
  109. hm.put("volume_2", cursor.getString(cursor.getColumnIndex("volume_2")));
  110.  
  111. cursor.close();
  112. return hm;
  113. }else{
  114. hm.put("symbol_code", str_symbolCode);
  115. hm.put("market_code", str_marketCode);
  116. hm.put("instrument_name","");
  117. hm.put("company_name", "");
  118. hm.put("isin", "");
  119. hm.put("interval", "");
  120. hm.put("exchange", "");
  121. hm.put("ex_open", "");
  122. hm.put("ex_close", "");
  123. hm.put("currency", "");
  124. hm.put("timezone", "America/New_York");
  125.  
  126. hm.put("date_1", "");
  127. hm.put("hour_1", "");
  128. hm.put("open_interest_1", "");
  129. hm.put("open_1", "");
  130. hm.put("high_1", "");
  131. hm.put("low_1", "");
  132. hm.put("close_1", "");
  133. hm.put("volume_1", "");
  134.  
  135. hm.put("date_2", "-");
  136. hm.put("hour_2", "");
  137. hm.put("open_interest_2", "");
  138. hm.put("open_2", "");
  139. hm.put("high_2", "");
  140. hm.put("low_2", "");
  141. hm.put("close_2", "");
  142. hm.put("volume_2", "");
  143.  
  144. cursor.close();
  145. return hm;
  146. }
  147. // cursor.close();
  148. // return hm;
  149. }
  150.  
  151. 09-29 12:14:49.485: E/AndroidRuntime(4956): Caused by: java.lang.IllegalStateException: database /data/data/com.irlsolutions.ittrading/databases/ITTrading.sqlite (conn# 0) already closed
  152. 09-29 12:14:49.485: E/AndroidRuntime(4956): at android.database.sqlite.SQLiteDatabase.verifyDbIsOpen(SQLiteDatabase.java:2134)
  153. 09-29 12:14:49.485: E/AndroidRuntime(4956): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1526)
  154. 09-29 12:14:49.485: E/AndroidRuntime(4956): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1508)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!