title: Android SQLiteAssetHelper Can't upgrade read-only database from version 1 to 2:
body: <p>I want to create an offline dictionary app, that need sometimes to get update and old database will be replaced by new one. It's what I want to do, and I did something like this with <code>SQLiteAssetHelper</code> Library:</p>
  
  <p>Note:  <strong><code>SQLiteAssetHelper</code> will copy database from assets folder into app data folder</strong></p>
  
  <pre><code>public class MyDb extends SQLiteAssetHelper {
    private static final String DATABASE_NAME    = "db.sqlite";
    private static final int    DATABASE_VERSION = 1;
    public MyDb(Context context) {
      super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }
  }
  </code></pre>
  
  <p>now i want to update database, after puting new <code>db.sqlite</code> file into <code>assets</code> folder, I have manipulate my codes like this:</p>
  
  <pre><code>public class MyDb extends SQLiteAssetHelper {
    private static final String DATABASE_NAME    = "db.sqlite";
    private static final int    DATABASE_VERSION = 2;
    public MyDb(Context context) {
      super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }
  }
  </code></pre>
  
  <p>but when i compiled and run, it says: <strong>Can't upgrade read-only database from version 1 to 2</strong></p>
  
  <p>what is the solution?</p>
  
  <p>by clearing app data, it will works fine...</p>
  
  <p>SORRY FOR MY BAD ENGLISH...</p>