Database Cursor and error with columns

Question

This is part of my database. I followed the position of the columns but there's still an error.

public static final String CREATE_TABLE_NOTE = "create table " + NOTE_TABLE + " ( "
        + COLUMN_ID + " integer primary key autoincrement, "
        + COLUMN_TITLE + " text not null, "
        + COLUMN_MESSAGE + " text not null, "
        + COLUMN_THOUGHTS + " text not null, "
        + COLUMN_CATEGORY + " text not null, "
        + COLUMN_DATE + ");";


private Note cursorToNote(Cursor cursor){

//this part is underlined in red(error)

Note newNote = new Note (cursor.getString(1), cursor.getString(2),cursor.getString(3),
                        Note.Category.valueOf(cursor.getString(4)), cursor.getLong(0), cursor.getLong(5));
                return newNote;
            }

Note.java

public Note (String title, String message, Category category, long noteId, long dateCreatedMilli){
        this.title = title;
        this.message = message;
        this.thoughts = thoughts;
        this.category = category;
        this.noteId = noteId;
        this.dateCreatedMilli = dateCreatedMilli;
    }

Error:(112, 24) error: no suitable constructor found for Note(String,String,String,Category,long,long) constructor Note.Note(String,String,Category) is not applicable (actual and formal argument lists differ in length) constructor Note.Note(String,String,Category,long,long) is not applicable (actual and formal argument lists differ in length) +Misagh — Minho
– Minho, Commented Jul 10, 2016 at 13:54

Misagh Emamverdi · Accepted Answer · 2016-07-10 13:58:41Z

2

You are missing thoughts in constructor input parameters. Change it to this:

public Note (String title, String message, String thoughts, Category category, long noteId, long dateCreatedMilli){
        this.title = title;
        this.message = message;
        this.thoughts = thoughts;
        this.category = category;
        this.noteId = noteId;
        this.dateCreatedMilli = dateCreatedMilli;
    }

answered Jul 10, 2016 at 13:58

Misagh Emamverdi

3,6745 gold badges36 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Minho Over a year ago

Oh yes ! Thank you so much!!

Ehsan Heidari · Accepted Answer · 2016-07-10 13:58:04Z

1

Third parameter of Note() constructor is type of Category, but you passed it a String (returned by cursor.getString(3) method)

answered Jul 10, 2016 at 13:58

Ehsan Heidari

5366 silver badges18 bronze badges

2 Comments

Minho Over a year ago

isn't my third parameter COLUMN_THOUGHTS?

Ehsan Heidari Over a year ago

Yes, in your table. But no in your constructor. I think you made a mistake in your constructor. add "thoughts" to your constructor in third place.

Collectives™ on Stack Overflow

Database Cursor and error with columns

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related