C H A P T E R  4

Images

Transactions

In this chapter, you'll take a brief look at transactions in the context of JDBC. You'll see how to commit and roll back a transaction in JDBC, and you'll learn what transaction isolation levels are and which ones are supported by Oracle. In addition, I'll explain why it's important to turn off the autocommit feature in JDBC in production code. Finally, you'll examine transaction savepoints, a feature exposed to Java programs in JDBC 3.0.

What Is a Transaction?

A transaction is a set of SQL statements that performs an atomic logical unit of work in the database. Oracle Database Concepts Guide (10g Release 1) states ...

Get Expert Oracle JDBC Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.