Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-08177 - SQL state [72000]; error code [8177]; ORA-08177: can't serialize access for this transaction

Prasanth K SDec 3 2024

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
This post has been answered by Prasanth K S on Jan 31 2025
Jump to Answer
Comments
Post Details
Added on Dec 3 2024
3 comments
251 views