Getting below ORA-08177 issue when multiple Spring batch jobs are triggered at the same time.
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [INSERT INTO BATCH_JOB_EXECUTION(JOB_EXECUTION_ID, JOB_INSTANCE_ID, START_TIME, END_TIME, STATUS, EXIT_CODE, EXIT_MESSAGE, VERSION, CREATE_TIME, LAST_UPDATED)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
]; SQL state [72000]; error code [8177]; ORA-08177: can't serialize access for this transaction
Property already added to set the Transaction isolation level as READ_COMMITTED
- spring.batch.jdbc.isolation-level-for-create=READ_COMMITTED
- spring.datasource.hikari.transaction-isolation=TRANSACTION_READ_COMMITTED
Versions used
- Spring Boot version: 3.3.2
- Spring Batch version: 5.1.0
- Oracle Database version: 19.14
- JDBC Driver: ojdbc11
- HikariCP version: 5.0.1