IBM Press - Apache Derby-Off to the Races - Includes Details of IBM Cloudscape

• Apache Derby-Off to the Races: Includes Details of IBM Cloudscape
• Table of Contents
• Copyright
• IBM Press
  • DB2 Books
  • On Demand Computing Books
  • Rational Software Books
  • WebSphere Books
  • More Books from IBM Press
• Preface
  • Executive Letter from Bob Picciano (Vice President of Database Servers, IBM)
  • About This Book
• Acknowledgments
• About the Authors
• None: Part 1
  • Chapter 1. On Your Marks ... Get Set ... Go!!! An Introduction to the Apache Derby and IBM Cloudscape Community
    • Introduction
    • Let Me Get This Straight, Apache Derby Is IBM Cloudscape?
    • Development of the Apache Derby Database-Who Can Contribute and How?
    • How Can IBM Sell a Product for Profit and Contribute the Same Product to the Open Source Community?
    • How an Open Source Database Like Apache Derby Can Help
    • Why the Need for a Local Data Store?
    • Why Use a Relational Database?
    • How the Apache Derby Platform Can Help Your Business
    • A High-Level View of the Apache Derby Database
    • The Apache Derby Components
    • Developing Apache Derby Applications
• None: Part 2
  • Chapter 2. Deployment Options for Apache Derby Databases
    • Using the Embedded Framework for Apache Derby Applications
    • Using the Server Framework for Apache Derby Applications
  • Chapter 3. Apache Derby Databases
    • Introduction
    • Database Structure
    • Database Objects
    • Summary
  • Chapter 4. Installing Apache Derby and IBM Cloudscape on Windows
    • Migration from Previous Versions of Cloudscape
    • Before You Begin
    • Using the Windows Installer to Install IBM Cloudscape on Windows-Attention Developers!
    • Installing Apache Derby or IBM Cloudscape on Windows Manually
    • Verifying the Installation
    • Troubleshooting an Installation
    • Odds and Ends About Your Installation
  • Chapter 5. Installing Apache Derby and IBM Cloudscape on Linux
    • Migration from Previous Versions of Cloudscape
    • Before You Begin
    • Using the Linux Installer to Install IBM Cloudscape on Linux-Attention Developers!
    • Installing Apache Derby or IBM Cloudscape on Linux Manually
    • Verifying the Installation
    • Troubleshooting an Installation
    • Odds and Ends About Your Installation
  • Chapter 6. Managing an Apache Derby Database
    • Disaster Prevention and Recovery
    • Data Movement
    • Database Maintenance and Tuning
    • Summary
  • Chapter 7. Security
    • Introduction
    • Database File Security
    • Database File Encryption
    • User Authentication
    • Database Authorization
    • Summary
  • Chapter 8. SQL
    • Introduction
    • Your Momma Loves Drama Database
    • Data Definition Language (DDL)
    • Data Retrieval
    • Data Modification
    • Development SQL
    • Summary
• None: Part 3
  • Chapter 9. Developing Apache Derby Applications with JDBC
    • Introduction
    • JBDC Program Structure
    • JDBC Imports
    • Using Embedded JDBC Drivers
    • IBM DB2 JDBC Universal Driver for Derby
    • Establishing a Database Connection
    • Connecting with DB2 JDBC Drivers
    • Allocating Statements
    • Executing Dynamic SQL
    • Trapping SQLExceptions
    • SQLWarnings Versus SQLExceptions
    • Retrieving Query Results
    • Retrieving Column Values
    • Dynamically Determining Result Sets
    • Prepared Statements
    • AUTOCOMMIT, COMMITs, and ROLLBACKs
    • Batching Requests
    • Using Result Sets to Modify Data
    • Setting a Column to Null
    • Inserting and Updating Large Objects
    • Stored Procedures
    • User-Defined Functions
    • Apache Derby Applets
    • Locking Considerations
    • Summary
  • Chapter 10. Developing Apache Derby Applications with Perl, PHP, Python, and ODBC
    • Communicating with an Apache Derby Network Server
    • Installing the DB2 Runtime Client
    • Cataloging Apache Derby Network Servers
    • Cataloging Apache Derby Databases
    • Testing Your Connection
    • Uncataloged Connections
    • Summary
• None: Part 4
  • Chapter 11. "Your Momma Loves Drama" in JDBC
    • Introduction
    • Your Momma Loves Drama Database
    • The Your Momma Loves Drama Application
    • YMLD Overview
    • Installing the YMLD Application
    • YMLD Initialization
    • Connecting to the YMLD System
    • Current Performances at the Theater
    • Seat Pricing
    • Theater Seat Map
    • Purchase Tickets by Performance
    • View Transaction Log
    • Exit Routine
    • Summary
  • Chapter 12. "Your Momma Loves Drama" in Windows
    • Introduction
    • The Your Momma Loves Drama Application
    • Installing the YMLD Application
    • YMLD Initialization
    • Connecting to the YMLD System
    • Current Performances at the Theater
    • Try/Catch Block
    • Seat Pricing
    • Theater Seat Map
    • Purchase Tickets by Performance
    • View Transaction Log
    • Exit Routine
    • Summary
  • Chapter 13. "Your Momma Loves Drama" in PHP
    • PHP Overview
    • Learning the PHP Language
    • Installing and Configuring PHP
    • Creating Apache Derby Applications with PHP
    • Summary
  • Chapter 14. "Your Momma Loves Drama" in Perl
    • Perl Overview
    • Installing and Configuring Perl
    • Creating Apache Derby Applications with Perl
    • Summary
  • Chapter 15. "Your Momma Loves Drama" in Python
    • Python Overview
    • Learning the Python Language
    • Installing and Configuring Python
    • Creating Apache Derby Applications with Python
    • Summary
• None: Part 5
  • Appendix A. Web Site Contents
    • Introduction
    • Web Site Contents
    • Summary
  • Appendix B. Apache Derby and IBM Cloudscape Resources
    • General Information
    • Application Development
    • Getting to Know the IBM Cloudscape and Apache Derby Databases
    • Support
    • Newsgroups and Mailing Lists
  • Appendix C. Troubleshooting Hints and Tips
    • Introduction
    • Installation
    • Performance Tuning
    • Security
    • Database Features
    • SQL
    • JDBC Application Development
    • Summary
• Index
  • index_SYMBOL
  • index_A
  • index_B
  • index_C
  • index_D
  • index_E
  • index_F
  • index_G
  • index_H
  • index_I
  • index_J
  • index_L
  • index_M
  • index_N
  • index_O
  • index_P
  • index_Q
  • index_R
  • index_S
  • index_T
  • index_U
  • index_V
  • index_W
  • index_X
  • index_Y