| Java Programming with Oracle SQLJ | | | | Copyright | | | | Table of Contents | | | | Preface | | | | 1. Introduction | | | | 2. Relational Databases, SQL, and PL/SQL | | | | 3. Fundamental SQLJ Programming | | | | 4. Database Objects | | | | 5. Collections | | | | 6. Deploying SQLJ in the JServer | | | | 7. Large Objects | | | | 8. Contexts and Multithreading | | | | 9. Advanced Transaction Control | | | | 10. Performance Tuning | | | | 11. Combining JDBC, SQLJ, and Dynamic SQL | | | | A. Java and Oracle Type Mappings | | | | B. Oracle Java Utilities Reference | | | | C. SQLJ in Applets, Servlets, and JavaServer Pages | | | | Colophon | | | | Index | | | Database > Java Programming with Oracle SQLJ > 9. Advanced Transaction Control | Chapter 9. Advanced Transaction ControlIn this chapter, I discuss the various problems that relational database systems must solve when dealing with many users running different transactions involving the same tables at the same time. I describe how these problems are solved by modern database systems, and provide an example showing how you can alter the default transaction isolation, the degree to which the results of one transaction interfere with other transactions. | |