ebean overrides transaction isolation=none in the connection string and uses some level of transaction isolation. This is resulting in java.sql.SQLException: [SQL7008]. For reasons out of my control the table has no journal. I have been unsuccessful finding information on no transaction isolation.
This is the faulty line:
Ebean.createSqlUpdate("UPDATE dummytable SET column1 = 'Test' WHERE id = 1").execute();
This is the connection string:
datasource.as400.databaseUrl=jdbc:as400://localhost/LIBRARY;naming=sql;errors=full;transaction isolation=none;
Only way I found to be able to get this to work was by adding this to properties:
datasource.as400.isolationlevel=none
where as400 is the name of the datasource and would change depending on how you name yours.
However I am unable to find any documentation explaining it. Only reference is from source code.