Cannot rollback when autoCommit is enabled

General
#1

png_fixed
image.png_fixed.jpeg1646×871 483 KB

#2

Hi @chaihuo,

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

#3

Synchronize data from mysql to CRDb

#4

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.