Error when executing Groovy script: java.sql.SQLException: Can't call commit when autocommit=true

Legacy Knowledge Base

Published Sep. 10, 2025

Error when executing Groovy script: java.sql.SQLException: Can't call commit when autocommit=true

Written By

Alfonso Abad

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.

Issue

When a Groovy script with a commit instruction is executed it fails with the error:

 java.sql.SQLException: Can't call commit when autocommit=true

Environment

DXP 7.2

Resolution

On the portal-ext.properties file make the following changes:
- At the end of the jdbc connector add: &relaxAutoCommit=true
- Add the property: jdbc.default.autoCommit=false
Restart the portal and execute the script again.