Expert Oracle JDBC Programming

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.

This highly anticipated book tackles performance issues in JDBC applications head-on, to help you become an expert yourself! The book details concisely and clearly, the relevant aspects of Oracle's architecture that directly impact the performance and effectiveness of your JDBC application.

Author R.M. Menon provides comprehensive coverage of the JDBC API, with an in-depth review of Oracle 10g-specific features (the book also covers Oracle 9i.) Menon covers basic and advanced JDBC (standard and Oracle extensions), performance tips with supporting benchmarks, connection pooling, statement caching, selected PL/SQL techniques, Oracle objects and collections, as well as other topics.

R.M. Menon has worked with Oracle database for over eleven years, eight of which have been at Oracle Corporation. Menon works as a Project Lead in the core technology division of Oracle. For the past five years, Menon has used JDBC and other J2EE technologies extensively as part of his work. He believes in the philosophy of proving all assertions, and has strived to follow this philosophy rigorously in his book. When he is not doing research on Oracle, Menon learns Indian classical vocal music and performs at local cultural events as a singer. Occasionally, he also dabbles in sketching portraits, and drawing paintings and cartoons.