Data not inserting in Sqlite database in android

Question

I am developing an application which requires use of an SQLite database. I have implemented fetching the data, but I am facing problems when I try to insert data. The problem that I am having is that the new data I enter is not stored, i.e nothing is new is being entered into the database.

This is my insert code, myDataBase is an instance of SQLiteDatabase.

public void insertTitle(String Recipe)  
{  
    ContentValues initialValues = new ContentValues();  
    initialValues.put(COLUMN_NAME,value);  
    myDataBase.insert(ZRECIPE, null, initialValues);  
 }

What is the return value from insert(): -1 (error), or a valid row ID? — LarsH
– LarsH, Commented Nov 13, 2017 at 18:41

Konstantin Burov · Accepted Answer · 2010-08-15 05:50:07Z

5

Try it this way. You need first start transaction, then mark it as successful and end.

   try {  
       myDataBase.beginTransaction();
       myDataBase.insert(ZRECIPE, null, initialValues);
       myDataBase.setTransactionSuccessful();
       } 
   finally {
       myDataBase.endTransaction();
       }

answered Aug 15, 2010 at 5:50

Konstantin Burov

69.3k16 gold badges117 silver badges93 bronze badges

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

1 Comment

LarsH Over a year ago

Is it necessary to do an explicit transaction in order to get it to commit? Doesn't SQLite use autocommit mode by default?

habnabit · Accepted Answer · 2010-08-14 11:53:02Z

2

You forgot to commit the transaction.

answered Aug 14, 2010 at 11:53

habnabit

10.4k3 gold badges35 silver badges26 bronze badges

2 Comments

Jaymin Over a year ago

Hi, but how to commit the transcaction..?

Stan Over a year ago

Not sure but I guess that setTransactionSuccessful() actually is the commit.

Nagaraja · Accepted Answer · 2013-12-05 14:21:06Z

0

Try with this code this may help you

public void insertTitle(String Recipe)  
{  
    ContentValues initialValues = new ContentValues();  
    initialValues.put(COLUMN_NAME,Recipe);  
    myDataBase.insert(ZRECIPE, null, initialValues);  
 }

answered Dec 5, 2013 at 14:21

Nagaraja

5811 gold badge4 silver badges12 bronze badges

Collectives™ on Stack Overflow

Data not inserting in Sqlite database in android

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related