Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.19 KB | None | 0 0
  1. 07-28 14:22:08.781: E/Database(403): Error inserting id=1 phone_number=999000 name=John
  2. 07-28 14:22:08.781: E/Database(403): android.database.sqlite.SQLiteConstraintException: error code 19: constraint failed
  3. 07-28 14:22:08.781: E/Database(403): at android.database.sqlite.SQLiteStatement.native_execute(Native Method)
  4. 07-28 14:22:08.781: E/Database(403): at android.database.sqlite.SQLiteStatement.execute(SQLiteStatement.java:61)
  5. 07-28 14:22:08.781: E/Database(403): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1582)
  6. 07-28 14:22:08.781: E/Database(403): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1426)
  7. 07-28 14:22:08.781: E/Database(403): at com.example.dbtest.DBHelper.insertContact(DBHelper.java:47)
  8. 07-28 14:22:08.781: E/Database(403): at com.example.dbtest.MainActivity.onCreate(MainActivity.java:22)
  9. 07-28 14:22:08.781: E/Database(403): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
  10. 07-28 14:22:08.781: E/Database(403): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1611)
  11. 07-28 14:22:08.781: E/Database(403): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1663)
  12. 07-28 14:22:08.781: E/Database(403): at android.app.ActivityThread.access$1500(ActivityThread.java:117)
  13. 07-28 14:22:08.781: E/Database(403): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:931)
  14. 07-28 14:22:08.781: E/Database(403): at android.os.Handler.dispatchMessage(Handler.java:99)
  15. 07-28 14:22:08.781: E/Database(403): at android.os.Looper.loop(Looper.java:123)
  16. 07-28 14:22:08.781: E/Database(403): at android.app.ActivityThread.main(ActivityThread.java:3683)
  17. 07-28 14:22:08.781: E/Database(403): at java.lang.reflect.Method.invokeNative(Native Method)
  18. 07-28 14:22:08.781: E/Database(403): at java.lang.reflect.Method.invoke(Method.java:507)
  19. 07-28 14:22:08.781: E/Database(403): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
  20. 07-28 14:22:08.781: E/Database(403): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
  21. 07-28 14:22:08.781: E/Database(403): at dalvik.system.NativeStart.main(Native Method)
  22. 07-28 14:22:08.781: D/ContactsMaster ::(403): inserted
  23.  
  24. public void onCreate(SQLiteDatabase db) {
  25. // TODO Auto-generated method stub
  26. String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_NAME + "(" + KEY_ID + " INTEGER PRIMARY KEY," + KEY_NAME + " TEXT," + KEY_PH_NO + " TEXT" + ")";
  27. db.execSQL(CREATE_CONTACTS_TABLE);
  28. }
  29.  
  30.  
  31. public void insertContact(){
  32. SQLiteDatabase db = this.getWritableDatabase();
  33. ContentValues values = new ContentValues();
  34.  
  35. values.put(KEY_ID, "1");
  36. values.put(KEY_NAME, "Rajan");
  37. values.put(KEY_PH_NO, "9990008973");
  38.  
  39. db.insert(TABLE_NAME, null, values);
  40. db.close();
  41. }
  42.  
  43. values.put(KEY_ID, "1");
  44.  
  45. Long id = db.insert(TABLE_NAME, null, values);
  46.  
  47. String KEY_ID = "_id";
  48. String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_NAME + "(" + KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + KEY_NAME + " TEXT," + KEY_PH_NO + " TEXT" + ")";
  49.  
  50. values.put(KEY_ID, "1");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement