I am trying to create an application which has multiple threads running in background. In total there would be 5 threads including UI thread and all would be editing and reading database.
I have created a static final object to be used for synchronization purpose.
For each SQL statement i am enclosing it in
synchronized (GlobalVariables.lockObject) {
//// Create or Open Database
//// Create Statement
//// Prepare Statment & Execute
//// Close Database
//// lockObject.notify()
}
Theoritically i belive this should work in multithreading environment. However it doesnt. It works for UI thread but then it waits indefinately at prepare statement for background thread at random places in my code and doesnt move ahead until i take some action in UI thread which makes some database operation.
When my thread goes into waiting mode it stucks at SQLite Pending Operation and doesnt move until i my app does any other database transaction in UI Thread.
I am creating and closing db connection for each database operation in UI and background threads.
I am not sure if this is the best way to handle multiple thread sqlite operation but so far there is no documentation available in BlackBerry or forums and few links i found in forum suggested the way i mentioned above.
This works perfectly in OS 7.0 but not working in 6.0 simulator and devices.
Can someone help me here? I am really stuck at here since last 4 days.