This book provides the definitive tutorial and reference to the JDBC™ API, the technology that enables universal data access for the Java™ programming language. This new edition has been updated and expanded to cover the entire JDBC 3.0 API, including the java.sql package and the javax.sql package, the package that facilitates building server-side applications.

Containing in-depth explanations that go beyond the specification, this complete resource pairs a step-by-step tutorial with a comprehensive reference to every class and interface.

For those new to Java technology, the book includes an introduction to the Java programming language and to SQL. It builds on this basic knowledge to walk you through the creation of a JDBC application--from setting up a database and establishing a connection to retrieving values from result sets and using prepared statements. In addition, the authors provide many examples along the way that demonstrate how to execute common tasks. The book then turns to more advanced topics, focusing on features such as scrollable and updatable result sets, batch updates, SQL99 data types, custom mapping, savepoints, statement pooling, automatically generated keys, and more.

In addition to in-depth coverage of the JDBC metadata API, the book gives you the latest information on rowsets, the technology that makes it possible to handle data sets as JavaBeans™ components. As an added bonus, you get a preview of the standard implementations for JdbcRowSet, CachedRowSet, WebRowSet, JoinRowSet, and FilteredRowSet objects.

From Array to XADataSource, an easy-to-use alphabetical reference provides concise but complete information on each class and interface in the JDBC API. Each entry includes an overview with usage examples as well as a comprehensive explanation of the methods and fields.

A chapter on mapping SQL types and types in the Java programming language, an appendix for driver writers, a summary of the new features in the JDBC 2.0 and 3.0 APIs, and a glossary complete this indispensable resource for all database programmers.

The Java™ Series is supported, endorsed, and authored by the creators of the Java technology at Sun Microsystems, Inc. It is the official place to go for complete, expert, and definitive information on Java technology. The books in this Series provide the inside information you need to build effective, robust, and portable applications and applets. The Series is an indispensable resource for anyone targeting the Java™ 2 platform.

0321173848B05222003

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 22 Ratings

an exceptionally comprehensive volume - 2003-11-11
Reviewer Rating:
JDBC is one of the most mature and widely used Java APIs. Even after the arrival of more recent tools and technologies like EJB's CMP and JDO, JDBC still remains a simple, fast, and reliable way of storing objects' state in an RDBMS. While conceptually this technology is quite straightforward, its evolution has made it more complex and voluminous. Many books have been trying to explain the main aspects of it over and over again, but the 3rd edition of "JDBC API Tutorial and Reference" goes far beyond that.

The book is divided into two major sections: the Tutorial and the Reference. Actually, there are four tutorials in the Part One: Basic, Advanced, MetaData, and Rowset. Here well-written explanations are followed by clear and detailed examples.

It is remarkable that Part Two, The Reference, is not your typical API reference with simply method signatures or redundant explanations of their arguments. This is an extremely well thought through description of how to use JDBC 3.0 API to achieve a particular goal. Every class has a solid overview, examples, schemas -- everything one needs to get the job done. The book also contains an Appendix for JDBC driver developers and another Appendix covering JDBC 3.0 API changes.

This book provides the most clear and comprehensive JDBC coverage that I have ever seen. It is not just a matter of its size of over 1200 pages, but although the result of a well designed book structure and clear delivery.

Mature and stable - 2003-08-01
Reviewer Rating:
Almost all practical commercial deployments of Java involve hooking to a back end database. Of the latter, relational databases are the dominant form. The first version of JDBC arose soon after Java was released, because of this compelling need. Since then, Sun has extended the functionality while still striving to keep its learning curve shallow, as compared to Microsoft's ODBC. Indeed, the latest Java 1.4 Standard Edition includes JDBC 3.0 in its entirety.

To document JDBC 3.0, Sun has put out the third edition of this book. The maturity of JDBC is reflected in its heft. The reference portion is voluminous. The tutorial section is like aged whisky; it goes down smoothly. Sun has had plenty of time to sandpaper rough edges and, based on user feedback, to add popularly requested capabilities.

The attraction of this book is that it describes a mature and stable product. In corporate terms, it is safe and conservative. In other words, you can develop with JDBC according to the book and be highly confident of success. At least insofar as your Java GUI conversing with the database. (The design of a GUI or a database is outside the purview of the book.)

A Must For Your Bookshelf! - 2004-12-05
Reviewer Rating:
What can I say... if you do JDBC programming, you must have this book in your bookshelf. Great examples and super coverage of a very wide topic. You'll read it and continue to look back at it. Well worth the money!

No choice - a must - 2009-06-30
Reviewer Rating:
Of course this is not a tutorial or introduction of any kind. If you are looking to learn about databases or Java or SQL, look elsewhere. But come back when you are ready to do work!

There are many fine points to JDBC. Sure, the simple stuff is simple, but if you are looking for high reliability or high performance or both, you need to have a thorough understanding of your tools.

You won't find a better book if you are looking to find out exactly how JDBC is supposed to behave.

This book is written by the authors of the JDBC specification. For all intents and purposes, this book IS the JDBC specification.

On my job we treat this book as the JDBC specification. There are a couple of typos here and there, but it does indeed contain a complete description of every JDBC feature.

You will also need an equivalent SQL book to complement this one, because this book is ONLY about JDBC, not SQL. You will also have to reference the ODBC specification at times for some of the more arcane transaction semantics and such. Of course, any real database application is going to involve threads, and there is virtually no discussion of threads in this book, either. This book's singular focus on JDBC is what makes it what it is.

Like most Java books, it is overdue for an upgrade.

The only JDBC book you will need - 2003-07-16
Reviewer Rating:
Whether you are a beginner, intermediate, or advanced JDBC programmer you will find useful information in this book. The book is divided into two sections. The first section is a tutorial on using JDBC which makes up four chapters. The tutorial starts with a look at JDBC 1.0. The next chapter looks at the additional features added to JDBC in 2.0 and 3.0. The third tutorial chapter looks at metadata. The final chapter examines the RowSet interface, which is complex enough to need its own chapter.

The remainder of the book (about 800 pages) is a reference containing a chapter for each class or interface in JDBC. Each chapter contains an overview of a class or interface, sections on anything of either special interest or complexity, and then a list of all the methods of the class or interface with complete descriptions. If a section applies to a particular version of JDBC, the version it applies to is clearly marked. The information contained in the reference is much more than you can find in the APIs. The reference section itself is well laid out to make the information you need easy to find.

This is probably the only JDBC book you will ever need. No matter which version of JDBC your database drivers support, you will find your answers in this book. The book is well written with clear explanations and plenty of code samples (which can be downloaded from the Sun web site) . Anyone working with JDBC will want this book by their side while they are coding.

Browse Similar Topics

Top Level Categories:
Programming

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