JDBC API Tutorial and Reference / Edition 3

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 97%)
Other sellers (Paperback)
  • All (14) from $1.99   
  • New (6) from $45.00   
  • Used (8) from $1.99   


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.


Read More Show Less

Product Details

  • ISBN-13: 9780321173843
  • Publisher: Addison-Wesley
  • Publication date: 6/11/2003
  • Series: Java Series
  • Edition description: REV
  • Edition number: 3
  • Pages: 1280
  • Product dimensions: 7.42 (w) x 9.30 (h) x 1.82 (d)

Meet the Author

Maydene Fisher, a native of San Jose, California, specializes in object-oriented languages. She has experience spanning both coasts of the United States, having documented everything from complex financial models on Wall Street to Java APIs in Silicon Valley.

Jon Ellis, author of the JDBC 3.0 API specification, has been working with database systems for the past ten years. Currently based in Tokyo, Japan, he is now leading several Java Community Process specifications in the wireless space.

Jonathan Bruce, who previously worked on JNDI technology in Ireland and is now based in Santa Clara, California, has worked on the specifications for the JDBC 3.0 API, the RowSet implementations, and the JDBC API subset for use with wireless devices.


Read More Show Less

Table of Contents

1 Introduction 3
2 Basic Tutorial 49
3 Advanced Tutorial 113
4 MetaData Tutorial 193
5 Rowset Tutorial 255
6 Array 283
7 BatchUpdateException 301
8 Blob 309
9 CallableStatement 321
10 Clob 373
11 Connection 385
12 ConnectionEvent 431
13 ConnectionEventListener 435
14 ConnectionPoolDataSource 439
15 DatabaseMetaData 449
16 DataSource 565
17 DataTruncation 581
18 Date 589
19 Distinct Types 599
20 Driver 603
21 DriverManager 611
22 DriverPropertyInfo 623
23 ParameterMetaData 627
24 PooledConnection 637
25 PreparedStatement 647
26 Ref 679
27 ResultSet 691
28 ResultSetMetaData 783
29 RowSet 797
30 RowSetEvent 855
31 RowSetInternal 859
32 RowSetListener 865
33 RowSetMetaData 871
34 RowSetReader 881
35 RowSetWriter 885
36 Savepoint 889
37 SQLData 895
38 SQLException 907
39 SQLInput 915
40 SQLOutput 929
41 SQLPermission 941
42 SQLWarning 945
43 Statement 951
44 Struct 997
45 Time 1011
46 Timestamp 1021
47 Types 1033
48 XAConnection 1039
49 XADataSource 1055
50 Mapping SQL and Java Types 1065
App. A For Driver Writers 1097
App. B: Summary of Changes 1121
Glossary 1161
Index 1175
Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted July 31, 2003

    Mature and stable

    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.)

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)