Expert Oracle JDBC Programming

Description

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. 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