+2I 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'
+21) 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'.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
