Menon R.M. Expert Oracle JDBC Programming

Apress, 2005. - 723 p. - ISBN: (pbk): 1-59059-407-X.With the popularity of Java language, JDBC is now perhaps the most commonly used API
to access databases. Oracle is one of the premium databases of the world. This book is about
accessing and manipulating data in Oracle using JDBC, with a focus on performance and scalability.
Why another book on JDBC and Oracle, you may ask? I wrote this book because I realized
that most of the other JDBC books available today more or less regurgitate the JDBC specification
and the Oracle JDBC documentation that is freely available on the Internet. This book is
different. The central aim of this book is to complement the available documentation on JDBC
and Oracle, and to teach you how to use JDBC with Oracle effectively. This book is also different
from other JDBC books because of its focus on performance and scalability of applications.
Using this book, you will discover the following, among other things:How to use all the major features of standard JDBC and its Oracle extensions (Oracle 10g
and 9i)The most important architectural features of Oracle, an understanding of which will
enable you to write solid Oracle applicationsHow to write and run your own benchmarks to validate (or invalidate) various performance
claims, using invaluable Oracle performance tools such as tkprof, SQL trace, etc.The importance of understanding how to effectively exploit SQL and PL/SQL in your
applicationsPlease note that this book does not cover related technologies such as OC4J, JSP, Spring
Framework, and so on. Instead, it maintains focus on the JDBC API and the database tier.
Within the JDBC API, I have skipped some of the less commonly used JDBC features such as
distributed transactions, some of the RAC-related topics, and rowsets. The section “Overview
of JDBC API” in Chapter 3 explains in detail the different interfaces of the JDBC API and the
chapters that cover them (and it provides appropriate references if a topic is not covered).