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, Nov 13 '17 at 18:41

score 5 · Answer 1 · answered Aug 15 '10 at 05:50

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 '10 at 05:50

Konstantin Burov

68,980
16
115
93

Is it necessary to do an explicit transaction in order to get it to commit? Doesn't SQLite use autocommit mode by default? – LarsH Nov 13 '17 at 18:42

score 2 · Answer 2 · answered Aug 14 '10 at 11:53

2

You forgot to commit the transaction.

answered Aug 14 '10 at 11:53

habnabit

9,906
3
32
26

2

Hi, but how to commit the transcaction..? – Jaymin Aug 14 '10 at 12:03
Not sure but I guess that `setTransactionSuccessful()` actually is the commit. – Stan Mar 16 '15 at 12:03

score 0 · Answer 3 · answered Dec 05 '13 at 14:21

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 05 '13 at 14:21

Nagaraja

581
1
4
12

Data not inserting in Sqlite database in android

3 Answers3

Linked

Related