Solved

BlackBerry sqLite Multithreading

Posted on 2012-12-27
1
677 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
Suggested Courses

734 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