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

Document ID : KB000084452
Last Modified Date : 22/08/2018
Show Technical Document Details
Issue:
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(PhysicalConnection.java:2356)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2403)
at com.uc4.ra.jdbc.DBCall.runSql(DBCall.java:388)
at com.uc4.ra.jdbc.DBCall$runSql.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:136)
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(CallSiteArray.java:44)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callCurrent(AbstractCallSite.java:141)
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(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
Cause:
Please contact Oracle regarding more information as the solution and issue is JVM related.
Resolution:
Add the following line to the $AW_HOME/site/sosite or %AW_HOME%\site\sosite.bat file(Windows), where banner agent is installed:

START_OPTION_AGENT=-Doracle.jdbc.autoCommitSpecCompliant=false; export START_OPTION_AGENT

Restart the Agent or Windows Service