Book 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.
Table of contents
- Title
- Dedication
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewers
- Acknowledgments
- Introduction
- About the OakTable Network
- CHAPTER 1: Performance Toolkit
- CHAPTER 2: Oracle Fundamentals
- CHAPTER 3: Introduction to JDBC
- CHAPTER 4: Transactions
- CHAPTER 5: Statement and PreparedStatement
- CHAPTER 6: CallableStatement
-
CHAPTER 7: Result Sets Explored
- Handling Null Values
- Prefetching
- Scrollability, Positioning, and Sensitivity
- Updatability
- Creating Different Categories of Result Sets
- Result Set Limitations and Downgrade Rules
- Positioning in a Scrollable Result Set
- Updating, Inserting, and Deleting Result Set Rows
- Refetching Rows
- Database Changes Visible to a Result Set
- A Result Set's Ability to Detect Database Changes
- Paginating Through a Result Set
- Dynamically Building a Query with an Unknown Number of Bind Variables
- ResultSetMetaData
- DatabaseMetaData
- Summary
- CHAPTER 8: Oracle Objects: An Objective Analysis
- CHAPTER 9: Using Weakly Typed Struct Objects
- CHAPTER 10: Using Strongly Typed Interfaces with JPublisher
- CHAPTER 11: Using Oracle Collections and References
- CHAPTER 12: Using LOBs and BFILEs
- CHAPTER 13: Statement Caching
-
CHAPTER 14: Connection Pooling and Caching
- Connections and Sessions in Oracle
- Client/Server Applications and Connections
- Web Applications and Connection-Related Challenges
- Cost of Opening and Closing a Connection
- What Is Connection Pooling?
- What Is Connection Caching?
- Oracle9i Connection Pooling Framework
- Oracle9i Connection Caching
- Oracle 10g Implicit Connection Caching
- OCI Connection Pooling
- Summary
- CHAPTER 15: Security-Related Issues
- CHAPTER 16: Locking-Related Issues
- CHAPTER 17: Selected PL/SQL Techniques
- Appendix
- INDEX
Product information
- Title: Expert Oracle JDBC Programming
- Author(s):
- Release date: June 2005
- Publisher(s): Apress
- ISBN: 9781590594070
You might also like
book
Java Programming with Oracle JDBC
JDBC is the key Java technology for relational database access. Oracle is arguably the most widely …
book
Database Programming with JDBC & Java, Second Edition
Java and databases make a powerful combination. Getting the two sides to work together, however, takes …
book
Java EE 7: The Big Picture
The Definitive Guide to Java Platform, Enterprise Edition 7 Java EE 7: The Big Picture uniquely …
book
Pro Java 7 NIO.2
Pro Java 7 NIO.2 addresses the three primary elements that offer new input/output (I/O) APIs in …