Solved

BlackBerry sqLite Multithreading

Posted on 2012-12-27
1
670 Views
Last Modified: 2013-11-24
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.

Thank You
0
Comment
Question by:rigelnet
1 Comment
 

Accepted Solution

by:
rigelnet earned 0 total points
ID: 38732170
I have found solution.

Apprantly in my case i had a UI element invalidating its parent element in paint method.

Thus UI was going into infinite loop and since in OS 6.0 UI methods takes higher precedence and thread is kept on wait until UI methods are completed it was stucked in thread.

Thanks to all who read this post and tried to help me out.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
Last night I received a weird phone call, from a number I didn’t recognized.  I answered it and no one responded back so I hung up.   Didn’t look at my phone until my husband said “Your phone is doing something weird”.   I had what I’ll consider the…
The viewer will learn how to implement Singleton Design Pattern in Java.
This video teaches viewers about errors in exception handling.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now