jdbc transaction

最新推荐文章于 2025-08-13 08:40:22 发布

原创最新推荐文章于 2025-08-13 08:40:22 发布 · 154 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#JDBC #performance

本文探讨了在JDBC中如何通过调用Connection.setAutoCommit(false)来禁用默认的自动提交模式，进而开始一个事务。阐述了在执行一系列相互依赖的SQL语句时，这种做法如何帮助提高性能及确保数据一致性。

Question:
Does "Connection.setAutoCommit(false)" mean "begin a transaction?"
Answer:
By default, JDBC connections start in autocommit mode. This means that every executed statement is treated as a separate transaction. A transaction is simply an operation that is irreversibly completed.

There are occasions where this default behavior is undesirable. Having every statement commited to the database can reduce performance. In addition, a set of statements may have dependencies such that previous statements should be undone if a succeeding statement fails. This is why the JDBC API provides the

Connection.setAutoCommit()
method. You can turn off the default autocommit behavior by calling this method with an argument of false. All statements executed afterward will not take effect until you call
commit()
Therefore, the first call of
setAutoCommit(false)
and each call of
commit()
implicitly mark the start of a transaction. Transactions can be undone before they are committed by calling
rollback()
You will typically rollback a transaction when one of its constituent statements fails.