Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape

Learn installation, configuration, management, and securityDelve deeper with coverage on SQL, troubleshooting, application development, and moreMaster Apache Derby: the only open source, pure Java™, fully transactional, small-footprint RDBMSApache 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 includesComparing Apache Derby with the commercial IBM Cloudscape offeringDeploying Apache Derby/IBM Cloudscape to support development and production environments, client/server environments, multi-threaded applications, and Web serversIntegrating Apache Derby/IBM Cloudscape into a completely open source development environmentSpecific 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 JVMUnderstanding how programming languages interact with Apache Derby/IBM CloudscapeBuilding complete sample applications step-by-step in JDBC, Windows (ODBC and .NET), PHP, Perl, and PythonManaging and securing Apache Derby/IBM Cloudscape databasesWriting SQL code for creating, retrieving, and updating dataTroubleshooting installations, databases, and applicationsThis 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/0131855255www-306.ibm.com/software/