 | Level: Introductory Susan Cline (clines@us.ibm.com), Cloudscape Community Developer, IBM
16 Aug 2005
Updated 24 Nov 2005 The latest release of IBM® Cloudscape™, Version 10.1, a commercial release of Apache Derby, is available for download at no charge. This article explains a few differences for this version of the release. It also helps you to select the proper installer version of IBM Cloudscape to download. Introduction
Cloudscape is a commercial release of the Apache Software Foundation's (ASF) open source Apache Derby relational database and is available at no charge. Product support is available to purchase through IBM. For information about the differences between Cloudscape and Apache Derby, refer to the article, "Cloudscape Version 10: A technical overview." (See Resources.)
What's new in IBM Cloudscape Version 10.1?
In Version 10.1, Cloudscape has been enhanced from Version 10.0 with these additions:
- Derby Network Client Driver, an Open Source driver from Apache
- XA support for the Network Server
- Support for J2ME/CDC/Foundation with JSR-169 subset
- JDBC ™ Updatable Result Sets
- Additional SQL support: INTERSECT, EXCEPT, SYNONYM, and ORDER by expressions
- Online compress functionality for reclaiming disk space during operation
- Increased identifier lengths to 128 characters for all identifiers
- Support for insertions into an identity column
Support for the following is made available through separate downloads. (See Resources.)
- GA support for CLI/ODBC on Windows®
- GA support for PHP on Linux®, POWER, and AIX® platforms, and a beta solution on Windows
Upgrade is supported from Cloudscape Version 10.0 to Version 10.1. For detailed information, consult the Cloudscape 10.1 documentation.
For a detailed list of all additions and changes, including the defects resolved in this release, refer to the Release Notes included with the distribution.
Version 10.1 functionality
Cloudscape entered the marketplace in 1996 as the original zero-admin, embeddable, all-Java™ relational database. The functionality has grown quite a bit since that time. Some of the features of Cloudscape 10.1 are:
- Embedded engine with JDBC Driver
- Network Server
- Network client JDBC Driver
- Command line tools
- Support for CLI/ODBC applications, including PHP, Perl, and .NET
- A stand-alone GUI database browsing and migration tool, the IBM Cloudscape
Workbench (available as a no-charge download -- see Resources)
Cloudscape's SQL support consists of:
- Schemas, tables, temporary tables, views, triggers, indexes, savepoints
- Java procedures and functions
- Standard datatypes, including BLOB and CLOB
- Primary key, foreign key, unique, and check constraints
- Referential actions
For additional information about Cloudscape 10.1's feature set and overall architecture, refer to the developerWorks article, "Cloudscape Version 10: A technical overview" (See Resources.)
JDK Version and JDBC support
Cloudscape supports JDK and SDK versions 1.3, 1.4, 1.5, and J2ME support. The supported JDBC APIs are JDBC 2.1, JDBC 3.0, and a subset of JSR-169.
Selecting the correct installer type
You can choose between three Cloudscape installation packages:
- The Java installer can be used on any platform that supports Java and has a graphical user interface. The Java installer has been verified on SUSE Linux, Red Hat Linux, Fedora Linux, IBM AIX, Sun® Solaris, Mac OS X, and Windows. The Java installer does not include a Java Runtime Environment. You must have a Java Runtime Environment already installed on your system in order to use this installer.
- The Linux installer is for use on any Linux platform running on an Intel 32-bit (x86) processor. The Linux installer includes the IBM Java Runtime Environment 1.4.2 Service Release 2 for Linux.
- The Windows native installer is for use only on Microsoft Windows platforms. The Windows installer has been verified on Windows 2000, Windows XP, and Windows Server 2003. The Windows installer includes the IBM Java Runtime Environment 1.4.2 Service Release 2 for Windows.
On UNIX® platforms using the Java installer, please note the following:
- You may need to increase the number of file descriptors for the installation to succeed.
- The installer proposes
/opt/ibm/Cloudscape_10.1 as the installation directory. In most cases you will want to override this suggestion. If you choose to accept the default location, verify that you have permission to write to this directory before beginning the installation.
Be sure to read the installation instructions for additional information.
Download
Resources Learn
Get products and technologies
- GA support for CLI/ODBC on Windows® is available via the DB2 Run-Time Client.
- Zend Core for IBM provides GA support for PHP on Linux, POWER, and AIX ® platforms and a beta solution on Windows platforms.
- IBM Cloudscape Workbench: Download the Cloudscape Workbench as a set of Eclipse plug-ins or as a stand-alone tool.
About the author | | | Susan Cline works in IBM Cloudscape to develop technical content for
Cloudscape developers and users. |
Rate this page
| |
