Java Programming with Oracle JDBC BY Donald Bales
Chapter1.Introduction to JDBC:
1.1.The JDBC API
1.2.Clients
1.3.Using Sql
Chapter2.Application Database Connections
2.1.JDBC Drivers
2.2.Installation
2.3.Connecting to a database
2.4.Handling Exceptions
Chapter3.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
Chapter4.Servlet Database Connections
4.1.Oracle Driver Selection
4.2.Servlet Connection Strategies
4.3.Guidelines for Choosing a Connection Strategies
Chapter5.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
Chapter6.Oracle Advanced Security
6.1.Authentication
6.2.Data Encryption
6.3.Data Inteqrity
6.4.A Data Encryption and Inteqrity Example
6.5.Secure Sockets Layer
Chapter7.JNDI and Connection Pooling
7.1.DataSources
7.2.Oracle's Connection Cache
Chapter8.A Relational SQL Example
8.1.Relational Database Analysis
8.2.Refining the Analysis
8.3.Relational Database Design
Chapter9.Statements
9.1.Creating a Statements Object
9.2.The execute()Method
9.3.The executeUpdate()Method
9.4.The executeQuery()Method
9.5.OracleStatement Implements Statement
Chapter10.Result Sets
10.1.Basic Cursor Positioning
10.2.Data types
10.3.Accessor Methods
10.4.Scrollable,Updateable Result Sets
10.5.Result Set Is an OracleResult Set
Chapter11.Prepared Statements
11.1.A Prepared Statement Versus a Statement
11.2.Formulating SQL Statements
11.3.Batching
11.4.Prepared Statement Is an OraclePrepared Statement
Chapter12.Streaming Data Types
12.1.BLOBs
12.2.CLOBs
12.3.BFILEs
12.4.LONG RAWs
12.5.LONGs
Chapter13.Callable Statements
13.1.Understanding Stored Procedures
13.2.Calling Stored Procedures
13.3.Callable Statements Is an OracleCallableStatement
Chapter14.An Object-Relational SQL Example
14.1.From Relational Tables to Object Views
14.2.Object Tables
Chapter15.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
Chapter16.Strongly Typed Object SQL
16.1.JPublisher
16.2.The SQLData Interface
16.3.Oracle's CustomDatum Interface
Chapter17.Transactions
17.1.Manual Transactions
17.2.Transaction scope
17.3.Implicit Locking and Visibility
17.4.Isolation Levels
17.5.Distributed Transactions
Chapter18.Detection and Locking
18.1.Oracle's Locking Mechanisms
18.2.Detection
18.3.Data Integrity Solution.Download