Hi @Ankit_Kothiya
As far as I know, the Databricks JDBC driver doesn’t support manual transaction controls like setAutoCommit(false), commit(), rollback(), or BEGIN TRANSACTION. That’s because Delta Lake are designed to support atomic operations at the single statement or table level, not multi-statement transactions like you’d find in traditional databases. The JDBC driver runs in auto-commit mode by default, so it doesn’t allow for manual transaction handling.
As of now, there isn’t another JDBC driver for Databricks that supports those manual transaction features. Instead, you can use operations like MERGE or INSERT OVERWRITE, which are atomic on their own. And if you ever need to roll back changes, Delta Lake’s Time Travel feature can help with that.