How to handle 2 connections to database without error?

Question

I have a problem with my database.

Basically my applications read texts and rates of text from my SQLite database and show it on screen. I have also Thread function which downloads content from external internet server and uploads it into the database.

On less popular devices (mostly tablets) it generates errors like:

DB close exception
DB locked

Someone advised me to create something called a singleton to handle this and I created it but it generates errors. So I have an idea to use AsyncTask instead of Thread; do you think it will help? Maybe you have other solutions?

I don't see why using AsyncTask would change anything for your issue — sdabet, Jan 10 '13 at 13:43

score 0 · Answer 1 · answered Jan 10 '13 at 13:45

0

AsyncTask will not help you here. You have to create a database connection as a singleton.

answered Jan 10 '13 at 13:45

Vladimir Mironov

30,514
3
65
62

score 0 · Answer 2 · answered Jan 10 '13 at 13:45

0

You should get a readable database for when you are reading and a writable database for when you are writing. Then you will be able to do both at the same time.

Both of the methods are in the SQLHelper class

answered Jan 10 '13 at 13:45

jiduvah

5,108
6
39
55

score 0 · Answer 3 · edited May 23 '17 at 12:12

0

Never close the DB. Make sure you have only one Helper instance per application. See this for reference SQLiteDatabase close() function causing NullPointerException when multiple threads

This may help you :)

edited May 23 '17 at 12:12

Community

1
1

answered Jan 10 '13 at 13:49

Milind D

314
2
3

How to handle 2 connections to database without error?

3 Answers3