Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

"There is no default constructor available in android.database.sqlite.SQLitepenhelper" in Android Studio

Trying to extend class with SQLiteOpenHelper, but this error shows up : "There is no default constructor available in android.database.sqlite.SQLitepenhelper" along with other "cannot resolve symbol Category, Note,..."

class DbHelper extends SQLiteOpenHelper {
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(Category.getSql());
        db.execSQL(Note.getSql());
        db.execSQL(Attachment.getSql());
        db.execSQL(CheckItem.getSql());
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS " + Category.TABLE_NAME);
       db.execSQL("DROP TABLE IF EXISTS " + Note.TABLE_NAME);
        db.execSQL("DROP TABLE IF EXISTS " + Attachment.TABLE_NAME);
        db.execSQL("DROP TABLE IF EXISTS " + CheckItem.TABLE_NAME);
        onCreate(db);
You need to define an explicit constructor yourself that calls the 4- or 5-arg super constructor in SQLiteOpenHelper.
For example:
public DbHelper(Context context) {
    super(context, "database.db", null, 1);
where database.db is your database file name and 1 is the version.
                I had the same question about the WebView class, but this answered my question anyways. Thanks!
– Seth
                Aug 4, 2016 at 22:02
If your DBHelper child then this post help, othervise you can allready understandfirst Define it like this one in outside of you class, means uperside...
private DBHelper ourHelper;
private final Context ourContext;
Then use this
class DbHelper extends SQLiteOpenHelper {
public DBHelper(Context context) {
        super(context, DB_NAME, null, DB_VIRSION);
        // TODO Auto-generated constructor stub
@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(Category.getSql());
    db.execSQL(Note.getSql());
    db.execSQL(Attachment.getSql());
    db.execSQL(CheckItem.getSql());
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    db.execSQL("DROP TABLE IF EXISTS " + Category.TABLE_NAME);
   db.execSQL("DROP TABLE IF EXISTS " + Note.TABLE_NAME);
    db.execSQL("DROP TABLE IF EXISTS " + Attachment.TABLE_NAME);
    db.execSQL("DROP TABLE IF EXISTS " + CheckItem.TABLE_NAME);
    onCreate(db);
And then try this context for your parent class
public MyDatabase(Context c){
    ourContext=c;
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.