Android sqlite `db.execSQL()` is force close

Question

This is fragment from db class existing on my onCreate method. Above this method was defined a constructor with proper arguments.

So, when running it, the runtime log for this method shows that it executed up to run1.2 but not further.

public void onCreate(SQLiteDatabase db) {
        try{
          db = getWritableDatabase();
          db.beginTransaction();
          android.util.Log.w("check", "run1.1");
          String query = " CREATE TABLE check ( id INTEGER )";
          android.util.Log.w("check", "run1.2");
          db.execSQL(query, null);
          android.util.Log.w("check", "run1.3");
        }
        catch(Exception e){
            android.util.Log.w("check", e.toString());
        }

    }

@Zubair_2024 this question is a lit bit confuse. I changed it a lit bit. What mean "not further statement" ? You could need more precise providing logging information as well as which statements is not running. — e2a, Mar 30 '16 at 12:35

score 1 · Answer 1 · answered Mar 30 '16 at 11:59

Remove the second parameter of your execSQL call. This is the execSQL code from SQLiteDatabase.java:

public void execSQL(String sql, Object[] bindArgs) throws SQLException {
    if (bindArgs == null) {
        throw new IllegalArgumentException("Empty bindArgs");
    }
    executeSql(sql, bindArgs);
}

Use only:

db.execSQL(query);

Android sqlite `db.execSQL()` is force close

1 Answers1