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

最新推荐文章于 2024-07-23 08:45:00 发布

ningfuxuan

最新推荐文章于 2024-07-23 08:45:00 发布

阅读量4.1k

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/ningfuxuan/article/details/80209137

版权

JAVA 专栏收录该内容

21 篇文章

订阅专栏

本文介绍了解决使用Oracle JDBC Driver 12及以上版本时出现的“Could not commit with auto-commit set on”异常的方法。提供了更换旧版本驱动、设置JVM参数以及关闭Auto-Commit的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:803)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)

at java.lang.Thread.run(Thread.java:785)

解决方法：本人原来用的驱动是 ojdbc6-12.1.0.2.0.19120445.jar 报上面错误，换成ojdbc5_g.jar 即可解决上面问题

思路来自：

down vote

This kind of exceptions occur when the Oracle JDBC Driver (ojdbc6.jar) version 12 or above will be used. Version 12 and above of the driver is more strictly than earlier driver versions.

You can solve the problem, you have few options:

Change jar file to old version.( Below 12; usually issue occurs while migrating to new server)
Override behavior of new jar version(ojdbc6.jar) with setting below JVM arguments.

-Doracle.jdbc.autoCommitSpecCompliant=false

IBM WAS users, refer this link:
Set Auto Commit off in Java/SQL:

Java:

conn.setAutoCommit(false);

Oracle:

SET AUTOCOMMIT OFF