title: Android does not update SQLite database
body: <p>I am experiencing some trouble with an SQLIte database in my Android application. 
  The issue is that the database is never updated, not even on multiple restarts of the emulator, of Eclipse or after deletion from DDMS. </p>
  
  <p>This is my onCreate method, located in a class that extends SQLiteOpenHelper:</p>
  
  <pre><code>public void onCreate(SQLiteDatabase database) {
      try {
          database.execSQL(ESSENCE_TABLE_CREATE);
          database.execSQL(PACCO_TABLE_CREATE);
          database.execSQL(TAVOLE_TABLE_CREATE);
          database.rawQuery("insert into essenza values(1, 'Rovere')",
                  null); // added later
      } catch (SQLException e) {
          Log.e("DB", e.getMessage());
      }
  }
  </code></pre>
  
  <p>After instantiating the helper, I request a reference to the database:</p>
  
  <pre><code>    helper = new DBHelper(context, dbpath + "/" + DATABASE_NAME);
      database = helper.getWritableDatabase();
  </code></pre>
  
  <p>It seems that the rawQuery statement (which was added at a later time) is not executed and that the database in use is instead cached from a previous version. I also tried to change the version of the database, but it did not work. Am I missing something? Thanks in advance.</p>