Issue fetching data in SQLite

Question

I have two service classes like Service A and Service B running simultaneously. The two services need SQLite data from a single table. When two queries are executed simultaneously, the application crashes when data is fetched from one table. Here is what I mean:

Service A
{
  db.getdata();
}

Service B
{
  db.getdata();
}

Is there any way to execute the same query simultaneously on a single table? If so, how?

show code you have written to fetch data as well as update your query with logs for crash — Amod Gokhale
– Amod Gokhale, Commented Sep 10, 2016 at 8:01
check here on how to avoid that -- stackoverflow.com/questions/19755142/… -- however i suspect your problem lies somewere else so add the code and error you see in the log cat — Tasos
– Tasos, Commented Sep 10, 2016 at 8:05
there is no logcat error for this crash.when app get crash app not closing. — VibinReji Y
– VibinReji Y, Commented Sep 10, 2016 at 8:18

Kartik Shah · Accepted Answer · 2016-09-10 08:19:08Z

1

To handle such errors, its best to use Content Providers,it handles such requests.

If you want to continue using sqlite, create a singleton for ur sqlite object and make calls synchronous

answered Sep 10, 2016 at 8:19

Kartik Shah

4413 silver badges13 bronze badges

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

2 Comments

Kartik Shah Over a year ago

github.com/ikartiks/Capstone-project/blob/master/greVocab/src/… mark the answer as correct if you find the solution useful

Razor Over a year ago

This answer should be the accepted answer. Nice one!

Collectives™ on Stack Overflow

Issue fetching data in SQLite

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related