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