Java and databases make a powerful combination. Getting the two sides to work together, however, takes some effort--largely because Java deals in objects while most databases do not.

This book describes the standard Java interfaces that make portable object-oriented access to relational databases possible and offers a robust model for writing applications that are easy to maintain. It introduces the JDBC and RMI packages and uses them to develop three-tier applications (applications divided into a user interface, an object-oriented logic component, and an information store).

The book begins with a quick overview of SQL for developers who may be asked to handle a database for the first time. It then explains how to issue database queries and updates through SQL and JDBC. It also covers the use of stored procedures and other measures to improve efficiency, where these are available.

But the book's key contribution is a set of patterns that let developers isolate critical tasks like object creation, information storage and retrieval, and the committing or aborting of transactions.

The second edition includes more basics of JDBC and SQL, with more examples, and a deeper discussion about the architecture of a robust, maintainable database application. The second edition also explains the relationship between JDBC and Enterprise JavaBeans.

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 40 Ratings

Hard to read, little pay-off - 2002-10-16
Reviewer Rating:
I'm a Java Certified Programmer for the Java 2 Platform. I bought this book to begin learning additional APIs. The preface claimed that only a basic knowledge of Java and some understanding of SQL was required. The book was not as advertised. Yes, the book did cover basic and advanced JDBC in two very short chapters, and provided a summary of the features of JDBC Optional Package without giving any details in a third. After reading these chapters I feel I have had an introduction to the subject, but no real depth.

The rest of the book takes off into very difficult Java topics (RMI, JNDI, EJB, Java Patterns, Distributed Architectures, Persistence, Swing...)proportedly to demonstrate how JDBC is used in the "real world." From time to time I was actually able to understand some of it, most of the time not. The author did not provide a high level introduction to these topics, which I would have found useful. Rather, the author jumped into the bowels of these subjects in a page or two. The language the author uses is often very exacting such as one might expect to find in a specification. The exacting language and limited number of illustrations caused me to have to re-read many sections several times often to remain confused.

The majority of this book was way too ambitious for someone with the background the Prefaces the reader should have. This book may be very useful for a reader with a more advanced background. After I have read several other books covering the "unadvertised-bonus" topics which comprise most of this book more slowly, I will try to read it again.

Not enough meat - 2002-09-14
Reviewer Rating:
The first section of the book provided a rapid overview of using JDBC. Many topics, such as establishing the actual database connection (a relatively obscure process as every database vendor writes their JDBC connection class differently) were skimmed over without nearly enough detail. It was useful enough to get a start using JDBC, but little else.

The second part of the book was called "Applied JDBC". I don't think so. The examples were weak and poorly explained. Part of the reason I bought the book was it claimed it detailed "Developing Multi-Tier Applications". There were 5 pages on a writing a 3 tier application. The text only covered enough of each topic to leave you scratching your head wondering about the actual details.

The last section was a reference to JDBC APIs, which you could find online. Most likely already out of date and obviously a filler to turn what should have been a 100 page book into a 300 page book.

Usually I swear by O'Reilly books, but it was hard to justify the expenditure for this one.

A Book without a Country - 2003-08-23
Reviewer Rating:
This book starts strong, clearly elucidating the simple mechanics behind opening database connections and controling content updates through sql statements. It quickly drifts into something of a rambling however as the author attempts to cover too much ground in too short a span. Reese jumps from a slow introduction to JDBC and a gentle explanation of how to integrate database calls into simple applications to a mess of complex design patterns and ugly (I mean UGLY... where are his editors) code almost completely bereft of any helpful comments.

It almost seems as if the author started with the noble idea of advancing both the basic and more extensible uses of the API and then gets bored (or drunk) half-way through. The book just drops off a cliff when it gets to the 7th chapter.

The biggest crime however is that the text only devots a cursory page and a half to the high subject of Connection Pooling despite declaring (correctly) that it is absolutely essential to any successful JDBC deployment. Where does the author suggest we find information related to this topic, in a book dedicated to the discussion of Swing??

Look elsewhere... this text is under-edited, under-written and over-priced for the amount of useful information it contains; terribly dissapointing!

More sales pitch than substance - 2005-08-05
Reviewer Rating:

Database Programming with JDBC and Java
By George Reese
Published by O'Reilly
ISBN 1565926161
Reviewed by Larry Hess-HuNTUG member

This book is more of a sales pitch for Java Database Connectivity (JDBC) than anything else. The first 3 chapter keep trying to sell the reader on why you should use JDBC not how to use it as the title indicates. Maybe if I was a Java program I would have gotten more out of the book also I like to get to the meat of a function I don't need to be sold. I believe the function should sell itself if it works. Another problem with the book is, it is limited to only examples in C#, and I think examples should be in both C and VB.Net to ensure helping more programmers.

After the slow start and the limited examples the book did a good job explaining how JDBC would work. I found the chapter 10 The User Interface was the best read and most important to me. Overall the book went into detail on how to use JDBC and I think if I was a C programmer I would have gotten more out of the book.

For a non-java programmer the book is hard to read and understand and limiting the samples to C# also limits the readers understanding. To the authors credit he does state: "If .... have studied JAVA, this book will help you become a more effective application developer for JAVA database programs."

I would give this book a rating of 2 out of 5.

Excellent book on JDBC and multitier development - 2004-07-11
Reviewer Rating:
The text covers JDBC with enough depth, without burdening the reader with useless details available in any reference (in fact the reference is attached in an appendix, so there is no need to go looking online). Unlike other books it doesn't bore the reader with introduction to obvious concepts and examples. I highly recommend this for experienced professionals who need to understand and start using JDBC.
The book also gives a great in-depth explanation of multitier applications and some aspects of EJB. The author develops a framework which can be used both as EJB replacement for simple projects or as a explanation for how EJB operates.
In a word, great read, even four years after it was published.

Browse Similar Topics

Top Level Categories:
Programming

Sub-Categories:
Programming > Java
Java > Java Database Connectivity