title: Android SQLite Transaction rollback facility?
body: <p>I have to insert three tables independently .. but if first table is inserted successfully, then only 2nd table is needed to insert the data. If any error occurs while inserting the 2nd table, then it needs to rollback 1st table's last inserted one, likewise the 3rd table also :</p>
  
  <p>I did currently like this :</p>
  
  <pre><code>   DBAdapter dbAdapter = DBAdapter.getDBAdapterInstance(RetailerOrderActivity.this);
  dbAdapter.openDataBase();
     for (Map.Entry&lt;String, MyProduct&gt; entry : myProductMap.entrySet()) {
                      String key = entry.getKey();
                      MyProduct myProduct = entry.getValue();
  
                      ContentValues initialValue = new ContentValues();
                      initialValue.put("BusinessUnit",strBusinessUnit);
                      initialValue.put("ExecutiveCode",strExecutive);
  
                      if(salesType.equalsIgnoreCase("I")){
                          initialValue.put("InvoiceNo",transactionControl.getNextInvoiceNo());
                          initialValue.put("SalesCategory",transactionControl.getInvoicePrefix());
  
                      }else if(salesType.equalsIgnoreCase("O")){
                          initialValue.put("InvoiceNo",transactionControl.getNextOrderNo());
                          initialValue.put("SalesCategory",transactionControl.getOrderPrefix());
                      }
                      initialValue.put("ProductCode",key);
                      initialValue.put("LineNumber",i);
                      initialValue.put("Qty",myProduct.getQty());
                      initialValue.put("UnitPrice",myProduct.getPrice());
                      initialValue.put("DiscountValue",myProduct.getDisValue());
                      initialValue.put("DiscountQty",myProduct.getDisQty());
  
  
                      long nl = dbAdapter.insertRecordsInDB("WMInvoiceLine", null, initialValue); 
  
                     //update WMStockRecord table
                      if(nl != -1 ){
  
                          if((salesType.equalsIgnoreCase("I") &amp;&amp; orderStockValidation.equals("1")) || (salesType.equalsIgnoreCase("O") &amp;&amp; orderStockValidation.equals("1"))){
                              ContentValues stockValue = new ContentValues();
                              if(myProduct.getAvailableQuantity() &lt; myProduct.getQty()){
                                  stockValue.put("Stock",0.00);
                              }else{
                                  double tmp = myProduct.getAvailableQuantity() - myProduct.getQty();
                                  stockValue.put("Stock",tmp);
                              }
                              stockValue.put("LastUpdatedOn",strDate);
                              stockValue.put("LastUpdatedBy",strExecutive);
                              stockValue.put("ActiveStatus","1");
  
                              String whereCon = "BusinessUnit = '"+ strBusinessUnit +"' WarehouseCode = '"+defaultSalesWarehouse + "' LocationCode = '" + defaultSalesLocation + "' ProductCode = '" + key + "'";
                              long stock = dbAdapter.updateRecordsInDB("WMStockRecord", stockValue, whereCon, null);
                        }
  
                          //TO-DO WMInvoicekit
                      }
  
                      i++;
                     insertStatus = true;
                     lineStatus = true;
                  }
  </code></pre>
  
  <p>but Here is not transaction not available. How we can implement the transaction facility? I am using <code>DBAdapter</code></p>