 RSS,
Feed
 eBooks Space Blog
 Sitemap ,
eBooks Link
Add your Link
Cool eBook Library 
Many eBook for Free
|
|
|
|
Expert Oracle JDBC Programming
Ebooks category
Oracle
File size
4.00 MB
, eBook Downloads [2413]
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値l 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値l 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値l learn the software you need to install to develop and run JDBC programs on either UNIX or the Windows platform. You値l 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値l take a brief look at transactions in the context of JDBC. You値l see how to commit and roll back a transaction in JDBC. You値l learn what transaction isolation levels are and which ones are supported by Oracle.
Chapter 5: Statement and PreparedStatement
In this chapter, you値l first be introduced to the mechanics of how Oracle processes SQL statements. You値l then examine two of the fundamental statement interfaces of JDBC: Statement and PreparedStatement.
Chapter 6: CallableStatement
In this chapter, you値l explore in detail how to invoke stored SQL procedures from JDBC using the CallableStatement interface. You値l 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値l critically examine how these features should be used in Oracle applications in general. Note that this chapter doesn稚 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値l 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値l 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値l learn what LOBs (large objects) are and how they池e stored in Oracle. You値l then examine how to retrieve and manipulate them. You値l also compare various alternatives when manipulating LOBs through the JDBC API.
Chapter 13: Statement Caching
In this chapter, you値l 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値l also examine cursors and ref cursors in detail.
Chapter 14: Connection Pooling and Caching
In this chapter, you値l learn about connection pooling and caching, and how they can improve the performance of your application. You値l look at the 9i and 10g implementations separately. |
Default Password
eBooks-Space.com
Download
this eBook
Free eBook Review
|
|
other eBook in Oracle |
|
