Sqlite pendingOperation in Statement prepares
My code:
Statement mstatement = null; URI uri = URI.create(DBPath); sqliteDb = DatabaseFactory.openOrCreate(uri); mStatement = sqliteDb.createStatement(strQuery); mStatement.prepare();
My problem is that I am getting an error like "Sqlite pendingOperation" on mstatement.prepare () ;. I am using synchronized blocks in every database processing method. This happens when multiple threads are running.
+3
source to share
1 answer
I got my answer myself.
I modified the whole method as (in bold):
Cursor c = null;
DBHelper.mStatement = null;
Vector followups = new Vector();
**boolean runFlag = true;**
synchronized (GlobalVariables.lockObject) {
try {
**while(runFlag)**
SELECT EventId,OldTitle,OrderNumber,Status,Title,Type,UpdateDateTime,Id FROM Questions WHERE EventId=5 AND Type=1 AND (Status=0 OR Status=1 OR Status=2) ORDER BY OrderNumber
DBHelper.CreateAndOpenSqliteDBConnection();
DBHelper.mStatement = DBHelper.sqliteDb.createStatement(strQuery);
DBHelper.mStatement.prepare();
**if(DBHelper.mStatement == null)
{
DBHelper.CloseSqliteDBConnection();
runFlag = true;
continue;
}
else
{
runFlag = false;
}**
c = DBHelper.mStatement.getCursor();
while (c.next()) {
followups.addElement(Followup.getFromCursor(c));
}
}
**}**
catch (Exception ex) {
System.out.print(ERRORSTRING + "getUploadFollowupsFromDB: "
+ ex);
} finally {
DBHelper.CloseSqliteDBConnection();
}
GlobalVariables.lockObject.notifyAll();
}
return followups;
Great Ankit Rox ..
+2
source to share