Multithreading with SQLite and Objective-C

Question

I have a couple of threads and I'm using SQLite for storage. When I'm trying to access the database I'm getting SQLITE_BUSY error.

Is there a way how to fix this problem other than trying at each request ?

Perception · Accepted Answer · 2011-08-11 20:32:05Z

2

You are most likely running in serialized mode. But ... you're probably looking to run in multi-threaded mode instead. Note that you will need a separate database connection in each thread if you go that route.

Here is the link to the documentation goodness: http://www.sqlite.org/threadsafe.html

answered Aug 11, 2011 at 20:32

Perception

80.8k19 gold badges190 silver badges197 bronze badges

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

Comments

user859375 · Accepted Answer · 2011-08-11 20:46:07Z

0

Ignore my last answer.

You can use the sqlite3_errmsg function to get the error message as string and print it using NSLog or other ways as soon as error occurs to find the more appropriate and proper reason. http://www.sqlite.org/c3ref/errcode.html

You probably seem to be running in to serialization issue; I am not sure where.

edited Aug 11, 2011 at 20:46

answered Aug 11, 2011 at 20:37

user859375

3,7295 gold badges23 silver badges22 bronze badges

Collectives™ on Stack Overflow

Multithreading with SQLite and Objective-C

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related