You are previewing Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™.
O'Reilly logo
Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™

Book Description

  • Learn installation, configuration, management, and security

  • Delve deeper with coverage on SQL, troubleshooting, application development, and more

  • Master Apache Derby: the only open source, pure Java™, fully transactional, small-footprint RDBMS

    Apache Derby is the world's only enterprise class open source, pure Java, fully transactional relational database. It's small enough to be embedded directly into your Java applications, providing a local data store that requires no DBA support. Powerful enough to support a wide range of traditional applications, this database ships as the default database for WebSphere Application Server and more than fifty other IBM software products. Apache Derby is built on the mature IBM Cloudscape code base IBM recently contributed to the open source community. The IBM Cloudscape code was nominated and won Developer.com's Product of the Year 2005 award.

    Now, IBM's own database experts have written a comprehensive guide to making the most of Apache Derby—and its commercial counterpart, IBM Cloudscape— in any development or production environment. This book systematically introduces the Apache Derby/IBM Cloudscape technology: where it fits and how to install and configure it—and how to build robust business applications and Web services with it, one step at a time.

    Coverage includes

  • Comparing Apache Derby with the commercial IBM Cloudscape offering

  • Deploying Apache Derby/IBM Cloudscape to support development and production environments, client/server environments, multi-threaded applications, and Web servers

  • Integrating Apache Derby/IBM Cloudscape into a completely open source development environment

  • Specific instruction on installing Apache Derby/IBM Cloudscape on Windows® and Linux® workstations—with tips on how to install the code on any platform that has a supported JVM

  • Understanding how programming languages interact with Apache Derby/IBM Cloudscape

  • Building complete sample applications step-by-step in JDBC, Windows (ODBC and .NET), PHP, Perl, and Python

  • Managing and securing Apache Derby/IBM Cloudscape databases

  • Writing SQL code for creating, retrieving, and updating data

  • Troubleshooting installations, databases, and applications

  • This book has a companion Web site that contains links to the IBM version of Apache Derby and other downloadable code, documentation, articles, and other resources to give the reader a deeper understanding of some of the features available in Apache Derby.

    ibmpressbooks.com/title/0131855255

    www-306.ibm.com/software/data/awards/

    © Copyright Pearson Education. All rights reserved.

    Table of Contents

    1. Copyright
    2. IBM Press
    3. Preface
    4. Acknowledgments
    5. About the Authors
    6. Introduction
      1. On Your Marks … Get Set … Go!!! An Introduction to the Apache Derby and IBM Cloudscape Community
        1. Introduction
        2. Let Me Get This Straight, Apache Derby Is IBM Cloudscape?
        3. Development of the Apache Derby Database—Who Can Contribute and How?
        4. How Can IBM Sell a Product for Profit and Contribute the Same Product to the Open Source Community?
        5. How an Open Source Database Like Apache Derby Can Help
        6. Why the Need for a Local Data Store?
        7. Why Use a Relational Database?
        8. How the Apache Derby Platform Can Help Your Business
        9. A High-Level View of the Apache Derby Database
        10. The Apache Derby Components
        11. Developing Apache Derby Applications
    7. Apache Derby Database and SQL
      1. Deployment Options for Apache Derby Databases
        1. Using the Embedded Framework for Apache Derby Applications
        2. Using the Server Framework for Apache Derby Applications
      2. Apache Derby Databases
        1. Introduction
        2. Database Structure
        3. Database Objects
        4. Summary
      3. Installing Apache Derby and IBM Cloudscape on Windows
        1. Migration from Previous Versions of Cloudscape
        2. Before You Begin
        3. Using the Windows Installer to Install IBM Cloudscape on Windows—Attention Developers!
        4. Installing Apache Derby or IBM Cloudscape on Windows Manually
        5. Verifying the Installation
        6. Troubleshooting an Installation
        7. Odds and Ends About Your Installation
      4. Installing Apache Derby and IBM Cloudscape on Linux
        1. Migration from Previous Versions of Cloudscape
        2. Before You Begin
        3. Using the Linux Installer to Install IBM Cloudscape on Linux—Attention Developers!
        4. Installing Apache Derby or IBM Cloudscape on Linux Manually
        5. Verifying the Installation
        6. Troubleshooting an Installation
        7. Odds and Ends About Your Installation
      5. Managing an Apache Derby Database
        1. Disaster Prevention and Recovery
        2. Data Movement
        3. Database Maintenance and Tuning
        4. Summary
      6. Security
        1. Introduction
        2. Database File Security
        3. Database File Encryption
        4. User Authentication
        5. Database Authorization
        6. Summary
      7. SQL
        1. Introduction
        2. Your Momma Loves Drama Database
        3. Data Definition Language (DDL)
        4. Data Retrieval
        5. Data Modification
        6. Development SQL
        7. Summary
    8. Developing Apache Derby Applications
      1. Developing Apache Derby Applications with JDBC
        1. Introduction
        2. JBDC Program Structure
        3. JDBC Imports
        4. Using Embedded JDBC Drivers
        5. IBM DB2 JDBC Universal Driver for Derby
        6. Establishing a Database Connection
        7. Connecting with DB2 JDBC Drivers
        8. Allocating Statements
        9. Executing Dynamic SQL
        10. Trapping SQLExceptions
        11. SQLWarnings Versus SQLExceptions
        12. Retrieving Query Results
        13. Retrieving Column Values
        14. Dynamically Determining Result Sets
        15. Prepared Statements
        16. AUTOCOMMIT, COMMITs, and ROLLBACKs
        17. Batching Requests
        18. Using Result Sets to Modify Data
        19. Setting a Column to Null
        20. Inserting and Updating Large Objects
        21. Stored Procedures
        22. User-Defined Functions
        23. Apache Derby Applets
        24. Locking Considerations
        25. Summary
      2. Developing Apache Derby Applications with Perl, PHP, Python, and ODBC
        1. Communicating with an Apache Derby Network Server
        2. Installing the DB2 Runtime Client
        3. Cataloging Apache Derby Network Servers
        4. Cataloging Apache Derby Databases
        5. Testing Your Connection
        6. Uncataloged Connections
        7. Summary
    9. “Your Momma Loves Drama” in Applications
      1. “Your Momma Loves Drama” in JDBC
        1. Introduction
        2. Your Momma Loves Drama Database
        3. The Your Momma Loves Drama Application
        4. YMLD Overview
        5. Installing the YMLD Application
        6. YMLD Initialization
        7. Connecting to the YMLD System
        8. Current Performances at the Theater
        9. Seat Pricing
        10. Theater Seat Map
        11. Purchase Tickets by Performance
        12. View Transaction Log
        13. Exit Routine
        14. Summary
      2. “Your Momma Loves Drama” in Windows
        1. Introduction
        2. The Your Momma Loves Drama Application
        3. Installing the YMLD Application
        4. YMLD Initialization
        5. Connecting to the YMLD System
        6. Current Performances at the Theater
        7. Try/Catch Block
        8. Seat Pricing
        9. Theater Seat Map
        10. Purchase Tickets by Performance
        11. View Transaction Log
        12. Exit Routine
        13. Summary
      3. “Your Momma Loves Drama” in PHP
        1. PHP Overview
        2. Learning the PHP Language
        3. Installing and Configuring PHP
        4. Creating Apache Derby Applications with PHP
        5. Summary
      4. “Your Momma Loves Drama” in Perl
        1. Perl Overview
        2. Installing and Configuring Perl
        3. Creating Apache Derby Applications with Perl
        4. Summary
      5. “Your Momma Loves Drama” in Python
        1. Python Overview
        2. Learning the Python Language
        3. Installing and Configuring Python
        4. Creating Apache Derby Applications with Python
        5. Summary
    10. Appendices
      1. Web Site Contents
        1. Introduction
        2. Web Site Contents
        3. Summary
      2. Apache Derby and IBM Cloudscape Resources
        1. General Information
        2. Application Development
        3. Getting to Know the IBM Cloudscape and Apache Derby Databases
        4. Support
        5. Newsgroups and Mailing Lists
      3. Troubleshooting Hints and Tips
        1. Introduction
        2. Installation
        3. Performance Tuning
        4. Security
        5. Database Features
        6. SQL
        7. JDBC Application Development
        8. Summary
    11. Index