Banner Job fails with error "Could not commit with auto-commit set on"

Document ID : KB000084452
Last Modified Date : 14/04/2018
Show Technical Document Details
Error Message :
java.sql.SQLException: Could not commit with auto-commit set on

Running a Banner Job can fail with the error "java.sql.SQLException: Could not commit with auto-commit set on". The is seen in the Job's output file. Below is an example.

+++++++++++++++++++++++++++++++++++++ Start of Runtime Exception +++++++++++++++++++++++++++++++++++++
java.sql.SQLException: Could not commit with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.commit(
at oracle.jdbc.driver.PhysicalConnection.commit(
at com.uc4.ra.jdbc.DBCall.runSql(
at com.uc4.ra.jdbc.DBCall$ Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(
at BannerAgentImpl.insertParmsSQL(BannerAgent.groovy:3507)
at BannerAgentImpl.this$4$insertParmsSQL(BannerAgent.groovy)
at BannerAgentImpl$this$4$insertParmsSQL.callCurrent(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallCurrent(
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(
at BannerAgentImpl.insertParms(BannerAgent.groovy:3464)
at BannerAgentImpl.this$4$insertParms(BannerAgent.groovy)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
OS Version: N/A
Cause type:
By design
Root Cause: Please contact Oracle regarding more information as the solution and issue is JVM related.
Add the following line to the $AW_HOME/site/sosite or %AW_HOME%\site\sosite.bat file(Windows), under the line [default] section, where the banner agent is installed:

START_OPTION_AGENT=-Doracle.jdbc.autoCommitSpecCompliant=false; export START_OPTION_AGENT
Restart the Agent processes or Service(Windows)

Fix Status: No Fix

Fix Version(s):
Additional Information:
Workaround :