IBM Support

java.sql.SQLException: Could not commit with auto-commit set on

Troubleshooting


Problem

The above error is returned when saving data when using an Oracle 12 driver.

Symptom

You will see a stack trace similar to this:

java.sql.SQLException: Could not commit with auto-commit set on
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:
4443)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:
4490)
at psdi.iface.intertables.IfaceTbCronTask.sendMessage(IfaceTbCronTask.
java:963)
at psdi.iface.intertables.IfaceTbCronTask.processData(IfaceTbCronTask.
java:1037)
at psdi.iface.intertables.IfaceTbCronTask.processIfaceData
(IfaceTbCronTask.java:858)
at psdi.iface.intertables.IfaceTbCronTask.cronAction(IfaceTbCronTask.
java:514)
...

Cause

The latest OJDBC drivers are more compliant than they were. You can
turn off this behavior.

Resolving The Problem

Set this JVM option:

-Doracle.jdbc.autoCommitSpecCompliant=false

Set the argument on the WAS JVM arguments and restart the JVM.

This technote explains how to set the JVM arguments:

http://www-01.ibm.com/support/docview.wss?uid=swg21417365

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"System Related","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5;7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21989586

Page Feedback