Expert Oracle JDBC Programming: High Performance Applications with Oracle 10g
- 11h 5m
- R. M. Menon
- Apress
- 2005
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. Using this book you will learn, among other things:
- How to efficiently query, insert, update and delete data using JDBC
- How to exploit knowledge of Oracle fundamentals in building applications
- What transaction isolation levels are, which ones Oracle supports and how to write your transactions effectively on Oracle
- How to use proxy authentication to make your programs more secure
- How to use Oracle objects and collections effectively in your applications
- How to deal with the phenomenon of “lost updates” using variants of optimistic and pessimistic locking strageties
- How to exploit statement caching and connection pooling to increase performance and scalability of your application
About the Author
R.M. Menon has worked with the Oracle database for over nine years, the last six of which have been at Oracle Corporation, where he is currently Project Lead in the Server Technologies division. For the past five years, he has used JDBC and other J2EE technologies extensively as part of his work.
In this Book
-
Performance Toolkit
-
Oracle Fundamentals
-
Introduction to JDBC
-
Transactions
-
Statement and PreparedStatement
-
CallableStatement
-
Result Sets Explored
-
Oracle Objects: An Objective Analysis
-
Using Weakly Typed Struct Objects
-
Using Strongly Typed Interfaces with JPublisher
-
Using Oracle Collections and References
-
Using LOBs and BFILEs
-
Statement Caching
-
Connection Pooling and Caching
-
Security-Related Issues
-
Locking-Related Issues
-
Selected PL/SQL Techniques
