• Table of Contents • Index JDBC™ API Tutorial and Reference, Third Edition By Maydene Fisher, Jon Ellis, Jonathan Bruce Publisher: Addison Wesley Pub Date: June 13, 2003 ISBN: 0-321-17384-8 Pages: 1280 Slots: 2 This book provides the definitive tutorial and reference to the JDBC(TM) API, the technology that enables universal data access for the Java(TM) 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(TM) 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(TM) 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(TM) 2 platform. • Table of Contents • Index JDBC™ API Tutorial and Reference, Third Edition By Maydene Fisher, Jon Ellis, Jonathan Bruce Publisher: Addison Wesley Pub Date: June 13, 2003 ISBN: 0-321-17384-8 Pages: 1280 Slots: 2 Copyright The Java™ Series The Jini™ Technology Series The Java™ Series, Enterprise Edition Acknowledgments Part One Chapter 1. Introduction Section 1.1. What the JDBC 3.0 API Includes Section 1.2. Conventions Used in This Book Section 1.3. Contents of the Book Section 1.4. What Is the JDBC API? Section 1.5. The JDBC API and the Java Platforms Section 1.6. Java Overview Section 1.7. Relational Database Overview Chapter 2. Basic Tutorial Section 2.1. Getting Started Section 2.2. Setting Up a Database Section 2.3. Establishing a Connection Section 2.4. Setting Up Tables Section 2.5. Getting Data from a Table Section 2.6. Retrieving Values from Result Sets Section 2.7. Updating Tables Section 2.8. Milestone: The Basics of JDBC Section 2.9. Using Prepared Statements Section 2.10. Using Joins Section 2.11. Using Transactions Section 2.12. Stored Procedures Section 2.13. Creating Complete JDBC Applications Section 2.14. Running the Sample Applications Section 2.15. Sample Code Section 2.16. Creating an Applet from an Application Section 2.17. Stored Procedures Using SQLJ and the JDBC API Chapter 3. Advanced Tutorial Section 3.1. Getting Set Up to Use the JDBC 2.0 and 3.0 API Section 3.2. Moving the Cursor in Scrollable Result Sets Section 3.3. Making Updates to Updatable Result Sets Section 3.4. Making Batch Updates Section 3.5. SQL99 Data Types Section 3.6. Using Custom Mapping Section 3.7. Using a Object DataSource Section 3.8. JDBC 3.0 Functionality Chapter 4. MetaData Tutorial Section 4.1. Using a Object ResultSetMetaData Section 4.2. Using a Object DatabaseMetaData Section 4.3. Methods Added in the JDBC 2.0 Core API Section 4.4. Methods Added in the JDBC 3.0 API Section 4.5. Using a Object ParameterMetaData Section 4.6. Generic Applications Chapter 5. Rowset Tutorial Section 5.1. Types and Uses of Rowsets Section 5.2. Using a Rowset Section 5.3. An EJB Example Part Two Chapter 6. Array Section 6.1. Overview Array Section 6.2. Interface Definition Array Section 6.3. Methods Array Chapter 7. BatchUpdateException Section 7.1. Overview BatchUpdateException Section 7.2. Class Definition BatchUpdateException Section 7.3. Constructors BatchUpdateException Section 7.4. Methods BatchUpdateException Chapter 8. Blob Section 8.1. Overview Blob Section 8.2. Interface Definition Blob Section 8.3. Methods Blob Chapter 9. CallableStatement Section 9.1. Overview CallableStatement Section 9.2. Definition CallableStatement Section 9.3. Methods CallableStatement Chapter 10. Clob Section 10.1. Overview Clob Section 10.2. Interface Definition Clob Section 10.3. Methods Clob Chapter 11. Connection Section 11.1. Overview Connection Section 11.2. Interface Definition Connection Section 11.3. Methods Connection Section 11.4. Fields Connection Chapter 12. ConnectionEvent Section 12.1. Overview ConnectionEvent Section 12.2. Interface Definition ConnectionEvent Section 12.3. Constructors ConnectionEvent Section 12.4. Methods ConnectionEvent Chapter 13. ConnectionEventListener Section 13.1. Overview ConnectionEventListener Section 13.2. Interface Definition ConnectionEventListener Section 13.3. Methods ConnectionEventListener Chapter 14. ConnectionPoolDataSource Section 14.1. Overview ConnectionPoolDataSource Section 14.2. Interface Definition ConnectionPoolDataSource Section 14.3. Methods ConnectionPoolDataSource Chapter 15. DatabaseMetaData Section 15.1. Overview DatabaseMetaData Section 15.2. Interface Definition DatabaseMetaData Section 15.3. Methods DatabaseMetaData Section 15.4. Fields DatabaseMetaData Chapter 16. DataSource Section 16.1. Overview DataSource Section 16.2. Interface Definition DataSource Section 16.3. Methods DataSource Chapter 17. DataTruncation Section 17.1. Overview DataTruncation Section 17.2. Class Definition DataTruncation Section 17.3. Constructor DataTruncation Section 17.4. Methods DataTruncation Chapter 18. Date Section 18.1. Overview Date Section 18.2. Class Definition Date Section 18.3. Constructors Date Section 18.4. Methods Date Chapter 19. Distinct Types Section 19.1. Distinct Types Overview Chapter 20. Driver Section 20.1. Overview Driver Section 20.2. Interface Definition Driver Section 20.3. Methods Driver Chapter 21. DriverManager Section 21.1. Overview DriverManager Section 21.2. Class Definition DriverManager Section 21.3. Methods DriverManager Chapter 22. DriverPropertyInfo Section 22.1. Overview DriverPropertyInfo Section 22.2. Class Definition DriverPropertyInfo Section 22.3. Constructor DriverPropertyInfo Section 22.4. Fields DriverPropertyInfo Chapter 23. ParameterMetaData Section 23.1. Overview ParameterMetaData Section 23.2. Interface Definition ParameterMetaData Section 23.3. Methods ParameterMetaData Section 23.4. Fields ParameterMetaData Chapter 24. PooledConnection Section 24.1. Overview PooledConnection Section 24.2. Interface Definition PooledConnection Section 24.3. Methods PooledConnection Chapter 25. PreparedStatement Section 25.1. Overview PreparedStatement Section 25.2. Interface Definition PreparedStatement Section 25.3. Methods PreparedStatement Chapter 26. Ref Section 26.1. Overview Ref Section 26.2. Interface Definition Ref Section 26.3. Methods Ref Chapter 27. ResultSet Section 27.1. Overview ResultSet Section 27.2. Interface Definition ResultSet Section 27.3. Methods ResultSet Section 27.4. Fields ResultSet Chapter 28. ResultSetMetaData Section 28.1. Overview ResultSetMetaData Section 28.2. Interface Definition ResultSetMetaData Section 28.3. Methods ResultSetMetaData Section 28.4. Fields ResultSetMetaData Chapter 29. RowSet Section 29.1. Overview RowSet Section 29.2. Standard Implementations Section 29.3. Interface Definition RowSet Section 29.4. Methods RowSet Section 29.5. Fields RowSet Chapter 30. RowSetEvent Section 30.1. Overview RowSetEvent Section 30.2. Interface Definition RowSetEvent Section 30.3. Constructor RowSetEvent Section 30.4. Methods RowSetEvent Chapter 31. RowSetInternal Section 31.1. Overview RowSetInternal Section 31.2. Interface Definition RowSetInternal Section 31.3. Methods RowSetInternal Chapter 32. RowSetListener Section 32.1. Overview RowSetListener Section 32.2. Interface Definition RowSetListener Section 32.3. Methods RowSetListener Chapter 33. RowSetMetaData Section 33.1. Overview RowSetMetaData Section 33.2. Interface Definition RowSetMetaData Section 33.3. Methods RowSetMetaData Section 33.4. Fields RowSetMetaData Chapter 34. RowSetReader Section 34.1. Overview RowSetReader Section 34.2. Interface Definition RowSetReader Section 34.3. Methods RowSetReader Chapter 35. RowSetWriter Section 35.1. Overview RowSetWriter Section 35.2. Interface Definition RowSetWriter Section 35.3. Methods RowSetWriter Chapter 36. Savepoint Section 36.1. Overview Savepoint Section 36.2. Interface Definition Savepoint Section 36.3. Methods Savepoint Chapter 37. SQLData Section 37.1. Overview SQLData Section 37.2. Interface Definition SQLData Section 37.3. Methods SQLData Chapter 38. SQLException Section 38.1. Overview SQLException Section 38.2. Class Definition SQLException Section 38.3. Constructors SQLException Section 38.4. Methods SQLException Chapter 39. SQLInput Section 39.1. Overview SQLInput Section 39.2. Interface Definition SQLInput Section 39.3. Methods SQLInput Chapter 40. SQLOutput Section 40.1. Overview SQLOutput Section 40.2. Interface Definition SQLOutput Section 40.3. Methods SQLOutput Chapter 41. SQLPermission Section 41.1. Overview SQLPermission Section 41.2. Class Definition SQLPermission Section 41.3. Constructors SQLPermission Chapter 42. SQLWarning Section 42.1. Overview SQLWarning Section 42.2. Class Definition SQLWarning Section 42.3. Constructors SQLWarning Section 42.4. Methods SQLWarning Chapter 43. Statement Section 43.1. Overview Statement Section 43.2. Interface Definition Statement Section 43.3. Methods Statement Section 43.4. Fields Statement Chapter 44. Struct Section 44.1. > Overview Struct Section 44.2. Interface Definition Struct Section 44.3. Methods Struct Chapter 45. Time Section 45.1. Overview Time Section 45.2. Class Definition Time Section 45.3. Constructors Time Section 45.4. Methods Time Chapter 46. Timestamp Section 46.1. Overview Timestamp Section 46.2. Class Definition Timestamp Section 46.3. Constructors Timestamp Section 46.4. Methods Timestamp Chapter 47. Types Section 47.1. Overview of Class Types Section 47.2. Class Definition Types Chapter 48. XAConnection Section 48.1. Overview XAConnection Section 48.2. Interface Definition XAConnection Section 48.3. Methods XAConnection Chapter 49. XADataSource Section 49.1. Overview XADataSource Section 49.2. Interface Definition XADataSource Section 49.3. Methods XADataSource Chapter 50. Mapping SQL and Java Types Section 50.1. Mapping Overview Section 50.2. Mapping SQL Types to Java Types Section 50.3. Basic JDBC Types Section 50.4. Advanced JDBC Data Types Section 50.5. JDBC Types Added in the JDBC 3.0 API Section 50.6. Examples of Mapping Section 50.7. Custom Mapping Section 50.8. Dynamic Data Access Section 50.9. Storing Java Objects in a Database Section 50.10. Tables for Type Mapping Appendix A. For Driver Writers Section A.1. Requirements for All Drivers Section A.2. Requirements for JDBC 1.0 API Compliance Section A.3. Requirements for JDBC 2.0 API Compliance Section A.4. Requirements for JDBC 3.0 API Compliance Section A.5. API That Is Already Implemented Section A.6. Additional Requirements Section A.7. Permitted Variants Section A.8. Security Responsibilities of Drivers Section A.9. Use for Exceptions SQLException Section A.10. Implementation Suggestions Section A.11. Connection and Statement Pooling Implementations Section A.12. JDBC Test Suite Section A.13. Connectors Appendix B. Summary of Changes Section B.1. Overview of JDBC 3.0 API Changes Section B.2. Summary of New Functionality Section B.3. Complete List of JDBC 3.0 API Changes Section B.4. Overview of JDBC 2.0 Core API Changes Section B.5. Summary of New Functionality Section B.6. JDBC 2.0 Core API Changes Section B.7. JDBC Optional Package Features Section B.8. Complete List of Optional Package API Section B.9. Post JDBC 1.0 API Changes Section B.10. Early Design Decisions Section B.11. Where to Send Suggestions Glossary JDBC Quick Reference Index