Home > Books & Products > Networking & System Administration > System Administration - WebSphere > Apache Derby -- Off to the Races: Includes Details of IBM Cloudscape

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

View Larger Image

By Paul C. Zikopoulos, George Baklarz, Dan Scott.
Published by IBM Press.

Published: Oct 27, 2005
Copyright 2006
Dimensions: 7x9-1/4
Pages: 600
Edition: 1st

Book
ISBN-10: 0-13-185525-5
ISBN-13: 978-0-13-185525-0

More Information

Description Downloads Reviews Sample Content

Product 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/

Sample Files

Untitled Document Articles - Various IBM Cloudscape and Apache Derby articles from the IBM developerWorks site.
http://www.ibm.com/developerworks/db2/zones/cloudscape/

IBM Cloudscape - Installation images for Java, Windows, and Linux environments.
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408cline/index.html
For non-Java client support
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0409cline2/

Documentation - The IBM Cloudscape Information Center.
http://publib.boulder.ibm.com/infocenter/cscv/v10r1/index.jsp

Eclipse Demo - A demonstration of the Eclipse plug-in for Apache Derby.
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0509cline/

Examples - Examples and sample code from Apache Derby - Off to the Races.
Chapter 8 CH08-SQL.zip
Chapter 9 CH09-JDBC.zip
Chapter 11 CH11-YMLD-JDBC.zip
Chapter 12 CH12-YMLD-Windows.zip
Chapter 13 CH13-YMLD-PHP.zip
Chapter 14 CH14-YMLD-Perl.zip
Chapter 15 CH15-YMLD-Python.zip

YMLD Database YMLD-Database.zip - SQL script for creating the Your Momma Loves Drama database. The directory also includes a generated copy of the database.

Customer Reviews

10 of 10 people found the following review helpful

aggressive promotion of Derby, November 27, 2005

W Boudville (Terra, Sol 3) - See all my reviews

This review is from: Apache Derby -- Off to the Races: Includes Details of IBM Cloudscape (Hardcover)

Apache Derby is a very promising package that is being freely offered, as both source code and binaries. This book is an aggressive promotion of its virtues. The authors stress many things about Derby, or its IBM sidekick, Cloudscape.

Derby addresses a persistent need amongst many Java programmers for an easy to use SQL database. Often, a Java programmer has only cursory expertise in coding for a full database like IBM's DB2 or Oracle. Best usage of these often requires you to be a DBA.

By contrast, Derby comes as a Java JAR file, and can be plonked into your programming environment just as any other JAR file. The book explains in depth how to then interact with Derby, at the level of your Java source code. You can see that you get a pretty powerful engine. Including features like stored procedures and user defined functions, that let you optimise for speed.

Speaking of speed, that is perhaps the biggest possible drawback of Derby. It is run as Java... Read more

Help other customers find the most helpful reviews

Was this review helpful to you?

Report abuse | Permalink

Comment

7 of 7 people found the following review helpful

Solid addition to your programming bookshelf..., February 20, 2006

Thomas Duff "Duffbert" (Portland, OR United States) - See all my reviews

This review is from: Apache Derby -- Off to the Races: Includes Details of IBM Cloudscape (Hardcover)

If you've ever been curious about using or integrating Apache Derby (or IBM Cloudscape) into your project, here's the book you'll need... Apache Derby - Off to the Races by Paul C. Zikopoulos, Dan Scott, and George Baklarz. Very well done...

Contents: On Your Marks... Get Set... Go!!! - An Introduction to the Apache Derby and IBM Cloudscape Community; Deployment Options for Apache Derby Databases; Apache Derby Databases; Installing Apache Derby and IBM Cloudscape on Windows; Installing Apache Derby and IBM Cloudscape on Linux; Managing an Apache Derby Database; Security; SQL; Developing Apache Derby Applications with JDBC; Developing Apache Derby Applications with Perl, PHP, Python, and ODBC; "Your Momma Loves Drama" in JDBC; "Your Momma Loves Drama" in Windows; "Your Momma Loves Drama" in PHP; "Your Momma Loves Drama" in Perl; "Your Momma Loves Drama" In Python; Web Site Contents; Apache Derby and IBM Cloudscape Resources; Troubleshooting Hints and Tips; Index... Read more

Help other customers find the most helpful reviews

Was this review helpful to you?

Report abuse | Permalink

Comment

4 of 4 people found the following review helpful

A Must-Have for Derby Users, March 11, 2008

J. Brutto "~ RevOf11" (Macungie, PA) - See all my reviews

This review is from: Apache Derby -- Off to the Races: Includes Details of IBM Cloudscape (Hardcover)

The definitely guide to Derby. This offers much more explanation and information than the online documentation provided by Apache. But what do you expect... it comes from the minds at IBM themselves.

However, unlike most of IBM's publications and documentation, this is actually readable and informative. You don't have to wade through a series of unknowns and missing pieces of the puzzle in order to figure out what IBM was trying to actually get at.

This will not only help you define and work with Apache Derby, but also make your applications lighter, faster and easier to deploy.

Help other customers find the most helpful reviews

Was this review helpful to you?

Report abuse | Permalink

Comment

Share your thoughts with other customers:

› See all 5 customer reviews...

Index

Download the Index file related to this title.

Preface.

Acknowledgments.

About the Authors.

1. On Your Marks ... Get Set ... Go!!! An Introduction to the Apache Derby and IBM

II.

2. Deployment Options for Apache Derby Databases.

3. Apache Derby Databases.

4. Installing Apache Derby and IBM Cloudscape on Windows.

5. Installing Apache Derby and IBM Cloudscape on Linux.

6. Managing an Apache Derby Database.

7. Security.

8. SQL.

III.

9. Developing Apache Derby Applications with JDBC.

10. Developing Apache Derby Applications with Perl, PHP, Python, and ODBC.

IV.

11. "Your Momma Loves Drama" in JDBC.

12. "Your Momma Loves Drama" in Windows.

13. "Your Momma Loves Drama" in PHP.

14. "Your Momma Loves Drama" in Perl.

15. "Your Momma Loves Drama" in Python.

Appendix A. Web Site Contents.

Appendix B. Apache Derby and IBM Cloudscape Resources.

Appendix C. Troubleshooting Hints and Tips.

Downloadable Sample Chapter

Download the Sample Chapter related to this title.

Book

This product currently is not for sale.

By completing any purchase on IBM Press, you become eligible for an unlimited access one-month subscription to Safari Books Online.

Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.