Cannot rollback when autoCommit is enabled

Hi @chaihuo,

What were you trying to do when you encountered this error?

Synchronize data from mysql to CRDb

Judging from the error it looks like you’re using JDBC and you’re running more than one SQL statement in a single transaction. If that’s the case, you need to set autocommit to false and control the transaction using the commit() and rollback() methods. We have a code snippet in our java app example that might be helpful.