我正在创建我的employee表(引用另一个表实体),如下所示(为简洁起见)：

CREATE TABLE employee (_id INTEGER NOT NULL,PRIMARY KEY ( _id ),FOREIGN KEY (_id) REFERENCES entity(_id)  ON DELETE cascade ON UPDATE cascade DEFERRABLE INITIALLY DEFERRED )

然后我按如下方式运行事务(使用sqliteDatabase对象,我还报告日志中事务的状态)：

>> In transaction: false
beginTransaction();
>> In transaction: true
doSomeWrongINSERT();
setTransactionSuccessful();
endTransaction();
>> In transaction: false
sqliteConstraintException: foreign key constraint Failed (code 19)

好的,一切正常.现在,如果我尝试启动新事务或回滚,则两者都会失败：

>> In transaction: false
beginTransaction();
android.database.sqlite.sqliteException: cannot start a transaction within a transaction (code 1)

>> In transaction: false
endTransaction();
java.lang.IllegalStateException: Cannot perform this operation because there is no current transaction.

请注意,如果FK立即而不是延期,则所有这些都不会发生.