O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

AUTOCOMMIT, COMMITs, and ROLLBACKs

The SQL language has COMMIT and ROLLBACK statements that control when changes made to a database are physically committed to disk.

To ensure consistency of the data in a database, it is often necessary for applications to apply a number of changes together as a unit. This is called a unit of work. A unit of work is a recoverable sequence of operations within an application process. It is the basic mechanism that an application uses to ensure database integrity. At any given time, an application process has a single unit of work, but the life of an application process can involve many units of work. A unit of work is also known as a transaction.

Any application that successfully connects to a database automatically ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required