Expert Oracle JDBC Programming

Author: R. M. Menon

ISBN-10: 159059407X

ISBN-13: 9781590594070

Category: Applications & Languages - Databases

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

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.

Ch. 1Performance toolkit1Ch. 2Oracle fundamentals33Ch. 3Introduction to JDBC79Ch. 4Transactions115Ch. 5Statement and PreparedStatement139Ch. 6CallableStatement187Ch. 7Result sets explored209Ch. 8Oracle objects : an objective analysis277Ch. 9Using weakly typed struct objects323Ch. 10Using strongly typed interfaces with JPublisher345Ch. 11Using Oracle collections and references387Ch. 12Using LOBs and BFILEs447Ch. 13Statement caching495Ch. 14Connection pooling and caching529Ch. 15Security-related issues575Ch. 16Locking-related issues599Ch. 17Selected PL/SQL techniques629