Expert Oracle JDBC Programming

✍ Scribed by R. M. Menon (auth.)

• Publisher: Apress
• Year: 2005
• Tongue: English
• Leaves: 723
• Edition: 1
• Category: Library

✦ Synopsis

JDBC is the most commonly used API in Java to access and manipulate data in a database. Oracle is one of the most popular and scalable databases in the world. This book is a must-have for any developer building an application that employs JDBC on Oracle database. Unlike other JDBC books, this book has been written to complement not rehash the contents of Oracle JDBC documentation and the JDBC specification.

The book teaches you not just how to write JDBC code, but how to write effective JDBC code in a step-by-step fashion. This book does not assume any prior knowledge of JDBC, though it does assume basic knowledge of SQL and PL/SQL. It covers JDBC with a focus on writing high-performing, scalable and secure applications for Oracle 10g and 9i.

✦ Table of Contents

Front Matter....Pages i-xxxi
Performance Toolkit....Pages 1-32
Oracle Fundamentals....Pages 33-77
Introduction to JDBC....Pages 79-113
Transactions....Pages 115-138
Statement and PreparedStatement....Pages 139-185
CallableStatement....Pages 187-207
Result Sets Explored....Pages 209-275
Oracle Objects: An Objective Analysis....Pages 277-321
Using Weakly Typed Struct Objects....Pages 323-344
Using Strongly Typed Interfaces with JPublisher....Pages 345-385
Using Oracle Collections and References....Pages 387-446
Using LOBs and BFILEs....Pages 447-493
Statement Caching....Pages 495-528
Connection Pooling and Caching....Pages 529-573
Security-Related Issues....Pages 575-598
Locking-Related Issues....Pages 599-628
Selected PL/SQL Techniques....Pages 629-687
Back Matter....Pages 689-708

✦ Subjects

Programming Languages, Compilers, Interpreters