JDBC Transactions

JDBC Transactions

Does “Connection.setAutoCommit(false)” mean “begin a transaction?”

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 reduceperformance. In addition, a set of statements may have dependenciessuch that previous statements should be undone if a succeedingstatement fails. This is why the JDBC API provides the


method. You can turn off thedefault autocommit behavior by calling this method with an argument offalse. All statements executed afterward will not take effect untilyou call


Therefore, the first call of


and each call of


implicitly mark the start of a transaction.Transactions can be undone before they are committed by calling


You will typically rollback a transactionwhen one of its constituent statements fails.

See also  5 Ways to Improve Customer Experience

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist