Could Not Commit With Autocommit Set On Exception With JDBC 12.1 (Doc ID 1633346.1)

Last updated on AUGUST 31, 2023

Applies to:

Symptoms

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

While using the following commit code in JDBC driver 12.1.0.1 connecting to an Oracle 12c database.

java.sql.SQLException: Could not commit with auto-commit set on
       at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:4439)
       at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:4486)
       at oracle.jdbc.OracleConnectionWrapper.commit(OracleConnectionWrapper.java:140)

The code works successfully with prior versions of the JDBC driver.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.