Spring Batch ORA-08177: can't serialize access for this transaction when running single job, SERIALIZED isolation level
Solution 1:
From official doc - 4.3.1
The default isolation level for that method is SERIALIZABLE, which is quite aggressive: READ_COMMITTED would work just as well; READ_UNCOMMITTED would be fine if two processes are not likely to collide in this way. However, since a call to the create* method is quite short, it is unlikely that the SERIALIZED will cause problems, as long as the database platform supports it.
Solution 2:
When using serialized transactions you need to increase the initrans parameter on the table per the Oracle Docs. To handle serialized transactions this needs to be 3 or more.
alter table BATCH_.... INITRANS 3
Solution 3:
I had the same problem, and effectively isolation in jobRepository level is the key, here is an example of code that works for me:
<batch:job-repository id="jobRepository"
data-source="dataSource" transaction-manager="transactionManager"
isolation-level-for-create="READ_COMMITTED" table-prefix="SB_" />
Solution 4:
We have tried jacking up INI_TRANS to 100 and we were still running into issues
I found this article that suggests adding ROWDEPENDENCIES to the creation of tables.
http://www.devx.com/dbzone/Article/41591?pf=true
For me with INI_TRANS & now ROWDEPENDENCIES the exceptions for Serialized have gone away.
Update: Turns out not to be a perfect solution. We did have one event of this SERIALIZED exception happen over night. Now that's much better as we had 100s of runs before a single failure but it appears that using ROWDEPENDENCIES isn't a yet a complete solution.