Java Programming with Oracle JDBC

Learn how to leverage JDBC, a key Java technology used to access relational data from Java programs, in an Oracle environment. Author Donald Bales 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 Oracle JDBC
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 Handling Exceptions
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 Connection Strategy
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.2 Oracle'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 Positioning
10.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 BLOBs
12.2 CLOBs
12.3 BFILEs
12.4 LONG RAWs
12.5 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 Calling Object 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.1 Oracle'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 Net8 Tracing
20.5 Wait for the Cure


Download this book click here
Another Database books click here
Another Java books click here