Why is the error occured?

HyeontaeJu

I Use spring batch and i run the application
by the way, sometime the error is occured when the application is doing merge into task.
Cause: java.sql.SQLNonTransientException: [Vertica]VJDBC ERROR: DDL statement interfered with this statement

and error_messages table sometimes occured this message 'Cannot commit; no transaction in progress'

mosheg

1) Which DDL statements were running at the error time? Can you check your Vertica logs and see what, if any, other statements were running at the same time as the statement that errored out?
If it is a failed INSERT statement, see: https://forum.vertica.com/discussion/221321/vertica-vjdbc-3007-error-ddl-statement-interfered-with-this-statement
2) COMMIT suppose to end the transaction and to make all changes that occurred during the transaction permanent and visible to other users.
However, when the previous DML statement fail and no transaction starts, the following COMMIT statement may complain that it 'Cannot commit' since there is 'no transaction in progress'.