|
Free ebooks
 Free database ebooks Oracle 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 ebook. 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. 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. Chapter 5: Statement and PreparedStatement - In this chapter, you’ll first be introduced to the mechanics of how Oracle processes SQL statements. 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. 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. 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. 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. 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. Download free pdf ebooks on oracle:Expert Oracle JDBC Programming
|
