"Expert Oracle JDBC Programming"

eBook Name: Expert Oracle JDBC Programming
eBook Type: Oracle

Oracle 8i/9i/10g/11g Database, PL/SQL, Oracle Form, Report

Expert Oracle JDBC Programming: Build scalable,high-performance JDBC-based application with Oracle Database 10g and 9i

Chapter 1: Performance Toolkit
The very first chapter introduces you to the various performance tools you�ll use throughout the book. These include tools such as tkprof that come bundled with Oracle, as well as tools I wrote in Java for your convenience.

Chapter 2: Oracle Fundamentals
This chapter explores some of the fundamental architectural features of Oracle that you as a developer should know. You�ll be introduced to topics such as multiversioning read consistency, the locking mechanism used by Oracle, shared pool, latches, undo, redo, and so on, with illustrative examples.

Chapter 3: Introduction to JDBC
In this chapter, you�ll learn the software you need to install to develop and run JDBC programs on either UNIX or the Windows platform. You�ll examine the various types of JDBC drivers, and which ones to use when.

Chapter 4: Transactions
Transactions form the basis of any database. 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. You�ll learn what transaction isolation levels are and which ones are supported by Oracle.

Chapter 5: Statement and PreparedStatement
In this chapter, you�ll first be introduced to the mechanics of how Oracle processes SQL statements. You�ll then examine two of the fundamental statement interfaces of JDBC: Statement and PreparedStatement.

Chapter 6: CallableStatement
In this chapter, you�ll explore in detail how to invoke stored SQL procedures from JDBC using the CallableStatement interface. You�ll learn how to use SQL92 syntax or Oracle syntax when invoking a stored procedure using the CallableStatement interface.

Chapter 7: Result Sets Explored
This chapter describes the advanced features of the ResultSet interface, including prefetching, scrollability, positioning, sensitivity, and updatability.

Chapter 8: Oracle Objects: An Objective Analysis
This chapter introduces Oracle objects and collections. You�ll critically examine how these features should be used in Oracle applications in general. Note that this chapter doesn�t discuss how to access objects and collections from JDBC; those topics are covered in the next three chapters.

Chapter 9:Using Weakly Typed Struct Objects
In this chapter, you�ll learn how to materialize Oracle objects as weakly typed objects in Java. A weakly typed object refers to a Java object that represents objects using an array of attributes.

Chapter 10:Using Strongly Typed Interfaces with JPublisher
Here, you�ll learn how to materialize objects as strongly typed objects in Java. A strongly typed object refers to an object belonging to a custom Java class specifically created to represent a given database object type in Java.

Chapter 11:Using Oracle Collections and References
This chapter explains how to retrieve the collections in Oracle as either a weakly typed or strongly typed array of custom class objects (generated using the JPublisher utility).

Chapter 12:Using LOBs and BFILEs
In this chapter, you�ll learn what LOBs (large objects) are and how they�re stored in Oracle. You�ll then examine how to retrieve and manipulate them. You�ll also compare various alternatives when manipulating LOBs through the JDBC API.

Chapter 13: Statement Caching
In this chapter, you�ll learn about statement caching, its different flavors in JDBC, and how it improves the performance of JDBC programs. As a background to the statement-caching concept, you�ll also examine cursors and ref cursors in detail.

Chapter 14: Connection Pooling and Caching
In this chapter, you�ll learn about connection pooling and caching, and how they can improve the performance of your application. You�ll look at the 9i and 10g implementations separately.