IBM Support

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

Technote (troubleshooting)


Problem(Abstract)

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

Document information

More support for: Maximo Asset Management
System Related

Software version: 7.5, 7.6

Operating system(s): Platform Independent

Reference #: 1989586

Modified date: 26 August 2016


Translate this page: