Android Database is empty

Question

I have a Problem with my sqlite database. Whenever i insert something in my db, it is inserted right, i can tell because i can find it in the debug mode with all its entries. However when i close the db with db.endTransaction(); the data seems lost because whenever i reopen it to read from the db it cant find any entries...even so the app starts without exceptions.

Can anyone help me?

thanks, thoorbenVerdorben

    public boolean storeValues(Context context, List<Course> values){
    db = DBOpenHelper.getInstance(context).getWritableDatabase();
    long id = 0;

    db.beginTransaction();


    for(values value: myvalues){
        ContentValues cv = new ContentValues();
        cv.put(DatabaseContract.HomeTable.name,value.name);
        cv.put(DatabaseContract.HomeTable.link,value.name);
        cv.put(DatabaseContract.HomeTable.id,value.name);
        id = db.insert(DatabaseContract.HomeTable.TABLE_NAME,null,cv);
    }
    db.endTransaction();
    if(id<0 ){
        return false;

    }
    else return true;
}


    public Set<values> getValues(Context context){
    db = DBOpenHelper.getInstance(context).getReadableDatabase();
    db.beginTransaction();
    String[] columns = {DatabaseContract.HomeTable.name,DatabaseContract.HomeTable.link,DatabaseContract.HomeTable.id};
    Cursor cursor = db.query(DatabaseContract.HomeTable.TABLE_NAME, columns,null,null,null,null,null);
    Set<Course> mySet = new LinkedHashSet<Course>();

    while(cursor.moveToNext()) {
        Values value = new Values();

        value.setName(cursor.getString(0));
        value.setName(cursor.getString(1));
        value.setName(cursor.getString(2));

        mySet.add(value);
    }

    db.endTransaction();

    return mySet;
}

Community · Accepted Answer · 2017-05-23 12:05:56Z

2

You're never closing the connection or committing the changes.

setTransactionSuccessful()

I think is what you're looking for. Check here for more info:

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered May 22, 2015 at 17:47

amza

8102 gold badges8 silver badges33 bronze badges

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

Comments

jyanks · Accepted Answer · 2015-05-22 17:46:44Z

1

I would change your while() loop to:

if(cursor.moveToFirst()) { // Ensure the cursor starts from the beginning
    do {
        Values value = new Values();

        value.setName(cursor.getString(0)); // Hopefully you realize you're 
        value.setName(cursor.getString(1)); // setting all these to the
        value.setName(cursor.getString(2)); // same property

        mySet.add(value);
    } while(cursor.moveToNext());
}
if(cursor != null) { cursor.close(); }

If that doesn't work, you would need to probably provide your DbHelper code

answered May 22, 2015 at 17:46

jyanks

2,3961 gold badge20 silver badges36 bronze badges

1 Comment

jyanks Over a year ago

I didn't even see that you hadn't set the transaction to successful - that is the right answer. That being said, you should still be doing the moveToFirst() check and the cursor.close() as a best-practice

Collectives™ on Stack Overflow

Android Database is empty

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related