Android Eclipse SQLiteDatabase OnCreate is not called
-
Please can you guide me to resolve in my code . I am a beginner in Android development. In my code On Create method is not calling
public class mtsDatabaseHelper extends SQLiteOpenHelper
{
private static final String DATABASE_NAME="fleetdatabase";
private static final String TABLE_NAME="USERS_TABLE";
private static final int DATABASE_VERSION = 1;
private static final String UID = "_id";
private static final String NAME = "Name";
private static final String CREATE_TABLE = "CREATE TABLE "+TABLE_NAME+" ("+UID+" INTEGER PRIMARY KEY AUTOINCREMENT, "+NAME+" VARCHAR(50));";
private static final String DROP_TABLE = "DROP TABLE "+TABLE_NAME+" IF EXISTS";
private Context context;
public mtsDatabaseHelper(Context context)
{
super(context,DATABASE_NAME,null,DATABASE_VERSION);
this.context = context;
Message.message(context, "Constructor called");
}public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub try { db.execSQL(CREATE\_TABLE); Message.message(context, "On Create called"); } catch(SQLException e) { Message.message(context, ""+e); } } public void onUpgrade(SQLiteDatabase db, int oldversion, int newversion) { // TODO Auto-generated method stub try { Message.message(context, "On Upgrade called"); db.execSQL(DROP\_TABLE); onCreate(db); } catch (SQLException e) { // TODO Auto-generated catch block Message.message(context, ""+e); } }
}
public class MainActivity extends Activity
{
mtsDatabaseHelper mtsdatabasehelper;
@Override
protected void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
mtsdatabasehelper = new mtsDatabaseHelper(this);
SQLiteDatabase sqlitdatabase = mtsdatabasehelper.getWritableDatabase();}
Please help