java android executeupdatedelete_android-了解updateWithOnConflict

我正在使用一个简单的数据库.它具有三列. _id(整数主键自动递增),jobnumber(文本唯一性不为null)和jobpart(文本不为null).

一切正常,直到我尝试更新记录并输入现有的职位编号.当我这样做时,应用程序崩溃,我被迫关闭.

我正在使用updateWithOnConflict,我认为这会导致事情正常退出并返回代码.不知道我只是不了解还是做错了什么…

任何帮助表示赞赏.

更新代码段：

public int updateJob(long rowId, String jobnumber, String jobpart) {

ContentValues args = new ContentValues();

args.put(JOB_NUMBER, jobnumber);

args.put(JOB_PART, jobpart);

return mDb.updateWithOnConflict(JOB_TABLE, args, JOB_ROWID + "=" + rowId, null, SQLiteDatabase.CONFLICT_ROLLBACK);

}

LogCat的输出：

FATAL EXCEPTION: main

android.database.sqlite.SQLiteException: cannot commit - no transaction is active

at android.database.sqlite.SQLiteStatement.native_executeSql(Native Method)

at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:89)

at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1933)

at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1864)

at android.database.sqlite.SQLiteDatabase.endTransaction(SQLiteDatabase.java:688)

at android.database.sqlite.SQLiteStatement.releaseAndUnlock(SQLiteStatement.java:266)

at android.database.sqlite.SQLiteStatement.executeUpdateDelete(SQLiteStatement.java:96)

at android.database.sqlite.SQLiteDatabase.updateWithOnConflict(SQLiteDatabase.java:1829)

at cdc.gridtest.ScheduleDBAdapter.updateJob(ScheduleDBAdapter.java:325)

at cdc.gridtest.JobEdit.saveState(JobEdit.java:104)

at cdc.gridtest.JobEdit.access$0(JobEdit.java:90)

at cdc.gridtest.JobEdit$1.onClick(JobEdit.java:47)

at android.view.View.performClick(View.java:3110)

at android.view.View$PerformClick.run(View.java:11934)

at android.os.Handler.handleCallback(Handler.java:587)

at android.os.Handler.dispatchMessage(Handler.java:92)

at android.os.Looper.loop(Looper.java:132)

at android.app.ActivityThread.main(ActivityThread.java:4123)

at java.lang.reflect.Method.invokeNative(Native Method)

at java.lang.reflect.Method.invoke(Method.java:491)

at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:841)

at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:599)

at dalvik.system.NativeStart.main(Native Method)

解决方法:

我认为问题是您使用了SQLiteDatabase.CONFLICT_ROLLBACK标志,但没有使用事务.您应该创建一个事务或将CONFLICT_IGNORE作为标志放在您的方法调用中.

标签：sqlite,android

来源： https://codeday.me/bug/20191101/1986245.html