<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html><head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>HSQLDB</title></head> <body> <img style="width: 223px; height: 47px;" alt="HyperSQL logo" src="doc-src/images/hypersql_logo.png"> <h3><br> </h3> <h3>HyperSQL version 2.2.9 Distribution</h3> <p>HSQLDB (HyperSQL DataBase) is a relational database engine written in Java. Version 2.2.x is the result of over 6 years development since version 1.8.0. It offers many features and adheres closely to the latest SQL and JDBC 4 standards.</p> <p>This is a point release of version 2.2 which marked the 10th anniversary of our first release. This release should be used in preference to earlier 2.x releases, as it fixes a number of bugs and regressions, as well as improving functionality.</p> <h4>SUPPORTWARE</h4> The development and maintenance of HyperSQL has been possible because of financial contributions by business users. We need renewed contributions. Please subscribe to SupporWare at <a href="http://hsqldb.org/web/supportware">http://hsqldb.org/web/supportware</a> . Especially if you include HSQLDB as part of an applications that you sell, you are expected to subscribe to SupportWare at the appropriate level. <h4>PACKAGE CONTENTS</h4> <p>This download contains the following files and directories: </p> <p><b>bin</b></p> <p>This directory contains some Windows utility wrapper scripts, and some HTML pages with HSQLDB embedded as an applet.</p> <h4>build</h4> <p>This directory contains the ant build.xml script plus MSDOS CMD files for build. See the <a href="doc/guide/building-app.html">Building HyperSQL Jars</a> appendix of the HyperSQL User Guide for details. </p> <h4>classes</h4> <p>When the jar is rebuilt, this directory contains the *.class files generated by the ANT build tool. It does not exist in the distribution zip.</p> <h4>doc</h4> <p>A set of HTML, PDF and text documents covering different aspects of HSQLDB and some of its utilities.</p> <p><a href="doc/guide/index.html">HyperSQL User Guide</a> in HTML format. <br> <a href="doc/guide/guide.pdf">HyperSQL User Guide</a> in PDF format. </p> <p><a href="doc/util-guide/index.html">HyperSQL Utilities Guide</a> in HTML format.<br> <a href="doc/util-guide/util-guide.html">HyperSQL Utilities Guide</a> in PDF format. </p> <p>The <a href="doc/apidocs/index.html">JavaDoc</a> for public classes, including the JDBC documentation. </p> <p>Chronological list of minor changes and bug fixes since the release of version 2.0.0 <a href="doc/changelist_2_0.txt">changelist_2_0.txt</a> </p> <p>The license texts for the source and binaries, based on the BSD license. <a href="doc/hsqldb_lic.txt">hsqldb_lic.txt</a> is for sources developed entirely by the HSQL Development Group. <a href="doc/hypersonic_lic.txt">hypersonic_lic.txt</a> is for the few sources that contain code from the closed HypersonicSQL project.</p> <h4>lib</h4> <p>The jar needed for running HyperSQL and its GUI utilities (hsqldb.jar) has been pre-built in this directory. The jar is compatible with Java version 1.6. The jar for SqlTool (sqltool.jar) is also in this directory. The extra zip file in the directory is needed only for recompiling hsqldb and is not required for deployment.</p> <h4>src</h4> <p>All source code is in this directory. </p> <h4>testrun</h4> <p>Contains test scripts for the database engine and SqlTool. These scripts are run by separate test utilities for the engine and SqlTool</p> <h4>CHANGES</h4> <ul> <li>Compared to version 1.8, there are many new features and changes. Most of these do not affect existing features in version 1.8.x.</li> <li>Differences are detailed in the Guide. The main differences are as follows:</li> <li>Transaction isolation is always enforced - READ COMMITTED and SERIALIZABLE modes are supported.</li> <li>GENERATE BY DEFAULT AS IDENTITY does not create a primary key. A primary key must be declared explicitly.</li> <li>Column sizes are enforced, although you can change this and other properties to some extent.</li> </ul> <h4>UPDATES</h4> We constantly fix reported issues. Please check the web site regularly for latest updated version and latest information. <h4>SUPPORT</h4> <p>Support for HyperSQL is available from <a href="http://hsqldb.org/support">http://hsqldb.org/support</a> in various forms, including a mailing list and user forums. The web site features the latest bugfix versions of the software, FAQ and other useful resources.</p> <p>Fred Toussi (fredt (at) users.sourceforge.net)<br> Blaine Simpson (blaine dot simpson (at) admc dot com)</p> <p><a href="http://hsqldb.org">http://hsqldb.org</a> </p> </body></html>