[CAM-8351] ORA-01000 on Oracle 12 with MyBatis BATCH mode on Created: 23/Oct/17  Updated: 17/Nov/17  Resolved: 07/Nov/17

Status: Closed
Project: camunda BPM
Component/s: engine
Affects Version/s: None
Fix Version/s: 7.8.0, 7.8.0-alpha6

Type: Task Priority: L3 - Default
Reporter: Svetlana Dorokhova Assignee: Yana Vasileva
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: 0 minutes
Time Spent: Not Specified
Original Estimate: 0 minutes

Attachments: Text File console-oracle-12.txt    
Issue Links:
Related
is related to CAM-8327 Switch on MyBatis batch processing mode Closed

 Description   

When

  • Mybatis BATCH mode is on

Then

  • some tests are failing with the error:
Caused by: java.sql.BatchUpdateException: ORA-01000: maximum open cursors exceeded

	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:12296)
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:246)
	at org.apache.ibatis.executor.BatchExecutor.doFlushStatements(BatchExecutor.java:122)
	... 29 more

Generated at Tue Oct 15 19:42:24 CEST 2019 using JIRA 6.4.6#64021-sha1:33e5b454af4594f54560ac233c30a6e00459507e.