Java Programming with Oracle JDBC

Let Donald Bales show you how to leverage JDBC, a key technology used to access relational data from Java programs, in an Oracle environment. Begin by learning the all-important mysteries of establishing database connections. Then learn to issue SQL statements and get results back, to read and write data from large, streaming data types such as BLOBs, CLOBs, and BFILEs, and to interface with Oracle's other built-in language, PL/SQL. If you're taking advantage of the Oracle's relatively new ability to create object tables and column objects based on user-defined datatypes, you'll be pleased with Donald's thorough treatment of this subject. Donald shows you how to use JPublisher and JDBC to work seamlessly with Oracle database objects from within Java programs. You'll also learn how to access nested tables and arrays using JDBC. Donald concludes the book with a discussion of transaction management, locking, concurrency, and performance--topics that every professional JDBC programmer needs to know and understand. This is a must-have book for Java programmers working with Oracle.

User review
A no-nonsense, well-written and well-organized introduction to the Java programming language with Oracle JDBC.
A no-nonsense, well-written and well-organized introduction to the Java programming language with Oracle JDBC. It uses a careful, example-based, easy to understand approach. A friendly and well-written book recommended for anyone ready to learn the power of Java programming language with Oracle JDBC.
Thank you


User review
Well written, but out of date
Let me start by saying that had I purchased this book 2 years ago when it was first released, I would have given it 5 stars.

This is a very well-written book, with good explanations and sample code. However, the book is fairly out of date, and much of the performance tuning suggestions he makes don't really apply as much when using the latest Oracle JDBC drivers and Oracle9 database. This book covers Oracle 8.1.6, and a lot of changes have been made between that release and 8.1.7 and Oracle9.

I recommend the newer `Oracle 9i JDBC Programming` book by Jason Price for much more current coverage of this topic.

User review
A workmanlike book which achieves its aims
This book is for Java developers who need to get the most out of using JDBC and Oracle (version 8.1.6). Choosing a specific database allows a lot more detail. Other JDBC books may skip database-dependent parts of the API; this book even gives code examples for the hard stuff. It is slow to read end-to-end, but `dipping` works well - there's almost always a helpful code example nearby.

There are problems, though. The author is obviously very familiar with Oracle, but lacks the experience to make comparisons with other products, this book won't help you choose when to use Oracle or whan another system might be more appropriate. Also I noticed other signs of lack of research - he sometimes gets abbreviations wrong, and the Java code is not particularly well-written.

The big problem for me is that the book assumes you only ever use Oracle. There is no consideration of code portability, it offers no wisdom about avoiding or encapsulating proprietary Oracle-specific extensions. The techniques in this book could easily lock your product into Oracle, worse, they might even lock your product into a specific version of Oracle.

The book has minor discussion of extra features in Oracle8i and Oracle9i, but nothing about JDBC 3. It's less helpful if you are using a version older than 8.1.6, too.

If you (or your management) have already sold your soul to Oracle, get this book. If you might need to use other databases, get a more generic book, but keep this one for those times when only a specific Oracle feature will do the trick.

User review
Not bad, but,,,,
This book gives good coverage of Oracle's JDBC implementation. That is about as far as it goes. This is just too close to being documentation. When purchasing books on a specific technology, I am looking for the author's insight. Specific things the author learned while working with it. Give me best practices, suggestions, things to avoid, etc. Tell me what I won't learn from Oracle's docs, don't just rewrite them.

User review
average book
Looks like most of the material came from oracle documentation. Examples are very basic