I see from forum posting that this is as a result of running two jobs simultaneously
http://forum.springsource.org/showth...ith-Oracle-11G
Edit: Checked the document and the default transaction Isolation is 'Serializable'. Not sure what else needs to be configured.
I checked the logs and I did not see any other job running/executed at that time.Code:The Job failed org.springframework.dao.CannotSerializeTransactionException: PreparedStatementCallback; SQL [INSERT into BATCH_JOB_INSTANCE(JOB_INSTANCE_ID, JOB_NAME, JOB_KEY, VERSION) values (?, ?, ?, ?)]; ORA-08177: can't serialize access for this transaction ; nested exception is java.sql.SQLException: ORA-08177: can't serialize access for this transaction
Also, I am not able to resubmit the Job with the same name once this error occurs.
This is happening very frequently. Need help in preventing this from happening again.
Thanks
Edit: after another attempt, the Job Ran


Reply With Quote