View Larger Image	R. M. Menon Apress, Paperback, Published May 2005, 708 pages, ISBN 159059407X
	List Price: $59.99 Our Price: $36.50 You Save: $23.49 (39% Off)
	Availability: Out-Of-Stock

Read an excerpt: Chapter 5: Statement and PreparedStatement       Chapter 15: Security-Related Issues Excerpts provided courtesy of Apress. Copyright © Apress. Written permission from the publisher is required for any use of this material.

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

• Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions; Thomas Kyte, $30.50, 39% Off!
• Mastering Oracle SQL and SQL *Plus; Lex de Haan, $24.50, 39% Off!
• Oracle PL/SQL Programming, 4th Edition; Steven Feuerstein, et al, $40.50, 38% Off!
• Shell Scripting Recipes: A Problem-Solution Approach; Chris F.A. Johnson, $24.50, 39% Off!

• Databases : Oracle
• Programming Languages : Java

• Apress

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

Table of 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
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
CHAPTER 15 Security-Related Issues
CHAPTER 16 Locking-Related Issues
CHAPTER 17 Selected PL/SQL Techniques
APPENDIX
INDEX

About the Author

R.M. Menon has worked with Oracle database for over nine years, six 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.

May 3, 2006     Scot Martin (scotmartin1@yahoo.com) from Jacksonville, Florida
Required Reading
I'd just like to agree with the other excellent reviews of this book. If you are using JDBC to connect to Oracle then you need to understand and apply the material taught in this book. Menon does an excellent job with clear examples, and he demonstrates conclusively the appropriate techniques required for an effective system.

Apr 7, 2006     AZ OAUG from Tempe, Arizona
Great book for novice to advanced users
Good Things: Lots of excellent real life code examples. Good reading for beginners to advanced users; helpful for advanced concepts but also built up to them by explaining the basics ones. Great code optimization recommendations. Well written, easy to understand. Bad Things: No CD that comes with book containing code examples. I also did not find a website with the code examples.

Feb 9, 2006     Jeanne Boyarsky from New York, NY
how to use oracle & java effectively and fast!
Expert Oracle JDBC Programming is part of a new series called OakTable Press. This series is written by Oracle experts, making the quality very high. In fact, one of the technical reviewers of this book is Ask Tom. This strong relationship with Oracle results in trying to convince the reader to use stored procs/Oracle specific code. This isn't a good or a bad thing just something to know up front. The author clearly shows what is Oracle specific and describes the tradeoffs. The book has three sections, starting with an introduction to JDBC. While JDBC knowledge is not required, it is helpful to get full benefit from the book as advanced concepts are introduced very quickly. The book relies heavily on code with all examples clearly explained. The second section goes into Oracle specific concepts. The last section explains best practices, issues and specific performance related concepts. This book is distinguished from others by the emphasis on good quality, high performing code. Benchmarks are provided from the beginning. Chapter 1 even covers how to time your code. As you can tell from the title, the book is Oracle specific. So you can copy/paste the code and run it on Oracle. All code examples specifically state whether they work on 9i, 10g or both. The focus of Oracle also allows the author to demonstrate exactly what needs to be done to run/test the examples on Oracle. I recommend this book for Java developers on Oracle.

Dec 21, 2005     Dean Frazee
Not an effective JDBC programming book.
I was looking for a book which describes JDBC programming in details. I was excited to read the previous review of 5 stars and ordered this book. To make people understand the author could have given simple examples. I would not recommend this book.

Jul 27, 2005     Vijay Raghavan from Mountain View, CA, USA
Excellent Oracle-JDBC book!
This is an excellent book with a very refreshing hands-on approach to JDBC programming for the Oracle database. The author tackles fundamental database concepts, with a strong emphasis on performance. The approach that the author uses includes the right combination of theoretical fundamentals and hands-on coding and testing. The result is a book that is ideal for both the novice user looking to understand fundamental database concepts and the advanced user looking for in-depth analyses using code examples and benchmark numbers. Best of all, the book is not just about the Oracle database in isolation. It is set within the context of JDBC programming, bringing the world of RDBMS programming to the Java community. This book is a must have for the enterprise software developer who is even half serious about leveraging the enormous power of the Oracle database in her/his application.

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account