Carlos

Java Programming with Oracle JDBC
Donald Bales
Publisher: O'Reilly
First Edition January 2002
ISBN: 0-596-00088-x, 496 pages

By GiantDino

Copyright
Table of Contents
Index
Full Description
About the Author
Reviews
Reader reviews
Errata

Learn how to leverage JDBC, a key Java technology used to access
relational data from Java programs, in an Oracle environment.
Author DonaldBales begins by teaching you the mysteries of
establishing database connections, and how to issue SQL queries
and get results back. You'll move on to advanced topics such as
streaming large objects, calling PL/SQL procedures, and working
with Oracle9i's object-oriented features, then finish with a look at
transactions, concurrency management, and performance.

Java Programming with OracleJDBC
Preface
Why I Wrote This Book
This Book's Intended Audience
Structure of This Book
Conventions Used in This Book
Software and Versions
Comments and Questions
Acknowledgments
I: Overview
Introduction to JDBC
1.1 The JDBC API
1.2 Clients
1.3 Using SQL
II: Connections
2. Application Database Connections
2.1 JDBC Drivers
2.2 Installation
2.3 Connecting to a Database
2.4 HandlingExceptions
3. Applet Database Connections
3.1 Oracle Drivers and JDK Versions
3.2 It's an Applet's Life
3.3 Packaging Your Applet
3.4 Getting Around the Sandbox

3.5 Establishing a Connection Through a Firewall
3.6 Guidelines for Choosing a Workaround
4. Servlet Database Connections
4.1 Oracle Driver Selection
4.2 Servlet Connection Strategies
4.3 Guidelines for Choosing a ConnectionStrategy
5. Internal Database Connections
5.1 Server-Side Driver Types
5.2 Using the Server-Side Internal Driver
5.3 Using the Server-Side Thin Driver
5.4 JServer Program Support
6. Oracle Advanced Security
6.1 Authentication
6.2 Data Encryption
6.3 Data Integrity
6.4 A Data Encryption and Integrity Example
6.5 Secure Sockets Layer
7. JNDI and Connection Pooling
7.1 DataSources
7.2Oracle's Connection Cache
III: Relational SQL
8. A Relational SQL Example
8.1 Relational Database Analysis
8.2 Refining the Analysis
8.3 Relational Database Design
9. Statements
9.1 Creating a Statement Object
9.2 The execute( ) Method
9.3 The executeUpdate( ) Method
9.4 The executeQuery( ) Method
9.5 OracleStatement Implements Statement
10. Result Sets
10.1 Basic Cursor Positioning10.2 Data Types
10.3 Accessor Methods
10.4 Scrollable, Updateable Result Sets
10.5 ResultSet Is an OracleResultSet
11. Prepared Statements
11.1 A Prepared Statement Versus a Statement
11.2 Formulating SQL Statements
11.3 Batching
11.4 PreparedStatement Is an OraclePreparedStatement
12. Streaming Data Types

12.1
12.2
12.3
12.4
12.5

BLOBs
CLOBs
BFILEs
LONG RAWs
LONGs

13.Callable Statements
13.1 Understanding Stored Procedures
13.2 Calling Stored Procedures
13.3 CallableStatement Is an OracleCallableStatement
IV: Object-Relational SQL
14. An Object-Relational SQL Example
14.1 From Relational Tables to Object Views
14.2 Object Tables
15. Weakly Typed Object SQL
15.1 Accessing Objects as Relational Tables
15.2 Structs
15.3 Arrays
15.4 Refs
15.5 CallingObject Methods
15.6 Putting It All Together
15.7 Oracle's Implementations
16. Strongly Typed Object SQL
16.1 JPublisher
16.2 The SQLData Interface
16.3 Oracle's CustomDatum Interface
V: Essentials
17. Transactions
17.1 Manual Transactions
17.2 Transaction Scope
17.3 Implicit Locking and Visibility
17.4 Isolation Levels
17.5 Distributed Transactions
18. Detection and Locking
18.1Oracle's Locking Mechanisms
18.2 Detection
18.3 Data Integrity Solutions
19. Performance
19.1 A Testing Framework
19.2 Auto-Commit
19.3 SQL92 Token Parsing
19.4 Statement Versus PreparedStatement
19.5 Batching
19.6 Predefined SELECT Statements
19.7 CallableStatements

19.8 OCI Versus Thin Drivers
20. Troubleshooting
20.1 The "Gotchas"
20.2 Unsupported Features
20.3 Debugging
20.4...