SQL Rollback Exception Errors In Webcenter Sites (Doc ID 1944728.1)

Last updated on MAY 31, 2023

Applies to:

Symptoms

Encountering various SQL Exception errors in Webcenter Sites which may be causing latency issues. Rollback SQLExceptions can be found in the Sites log:

java.sql.SQLException: java.sql.SQLException.rollback() should not be called while in auto-commit mode.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:2138)
at net.sourceforge.jtds.jdbcx.proxy.ConnectionProxy.rollback(ConnectionProxy.java:518)
at weblogic.jdbc.wrapper.XAConnection.rollback(XAConnection.java:878) at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:74)
at weblogic.jdbc.wrapper.JTAConnection.setAutoCommit(JTAConnection.java:309)
at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:155)
at COM.FutureTense.CatalogManager.CatalogEngine.query(CatalogEngine.java:2467)

Cause

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