org.camunda.bpm.engine.test.examples.mgmt.ManagementServiceTest fails, where is the 5th entry coming

[Frank Langelage]

Still trying to get Camunda running with IBM Informix I get thsi exception now:
-------------------------------------------------------------------------------
Test set: org.camunda.bpm.engine.test.examples.mgmt.ManagementServiceTest
-------------------------------------------------------------------------------
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.349 sec <<< FAILURE! - in org.camunda.bpm.engine.test.examples.mgmt.ManagementServiceTest
testTableCount(org.camunda.bpm.engine.test.examples.mgmt.ManagementServiceTest)  Time elapsed: 0.169 sec  <<< FAILURE!
junit.framework.AssertionFailedError: expected:<5> but was:<4>
    at junit.framework.Assert.fail(Assert.java:57)
    at junit.framework.Assert.failNotEquals(Assert.java:329)
    at junit.framework.Assert.assertEquals(Assert.java:78)
    at junit.framework.Assert.assertEquals(Assert.java:86)
    at junit.framework.TestCase.assertEquals(TestCase.java:253)
    at org.camunda.bpm.engine.test.examples.mgmt.ManagementServiceTest.testTableCount(ManagementServiceTest.java:48)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at junit.framework.TestCase.runTest(TestCase.java:176)
    at org.camunda.bpm.engine.impl.test.PvmTestCase.runTest(PvmTestCase.java:85)
    at junit.framework.TestCase.runBare(TestCase.java:141)
    at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:91)
...

The create script creates the table and 4 entries.

create table ACT_GE_PROPERTY (
    NAME_ VARCHAR(64),
    VALUE_ VARCHAR(255),
    REV_ INTEGER,
    primary key (NAME_)
);

insert into ACT_GE_PROPERTY
values ('schema.version', 'fox', 1);

insert into ACT_GE_PROPERTY
values ('schema.history', 'create(fox)', 1);

insert into ACT_GE_PROPERTY
values ('next.dbid', '1', 1);

insert into ACT_GE_PROPERTY
values ('deployment.lock', '0', 1);

Why are 5 rows expected?
Running the tests with the h2 database the testcase succeeds, but I did not find the place where another entry into this table is done.

[Frank Langelage]

I just found method dbCreateHistoryLevel in class SchemaOperationsProcessEngineBuild.
But why does Informix run not see this entry and h2 does?

Is there a certain isolation level required to make this working?

[Frank Langelage]

Yes, it is.

Setting isolation level for Informix connect to "COMMITTED READ WITH RETAIN LOCKS" it works.
With "RETAIN LOCKS" locks on records read with "SELECT ... FOR UPDATE" are held until the end of the transaction. Without it not, as the record did not got updated.