--- hsqldb1.8.0-1.8.0.10+dfsg.orig/build/build.xml-old
+++ hsqldb1.8.0-1.8.0.10+dfsg/build/build.xml-old
@@ -0,0 +1,1233 @@
+<?xml version="1.0"?>
+<!-- author fredt@users.sourceforge.net 2001 - 2008 -->
+<!-- additional targets by unsaved@users.sourceforge.net 2004 - 2008 -->
+
+<project name="hsqldb" default="help" basedir="../">
+   <!-- This loads properties in the same exact way as if you ran
+        "ant -Dprop1name=val1 -Dprop2name=val2...", etc.  To use all
+        defaults, you should have no 'build.properties' file.
+        If you don't understand this or want to know about precedence or
+        how to use an Ant properties file, look up an Ant manual or an
+        Ant expert.
+        If you want to know, "Can I set property 'x' in 'build.properties'",
+        rephrase the question to yourself as "Can I run 'ant -Dx=...?"
+        Do not address questions about property file(s) to the
+        hsqldb community. -->
+   <property file='build/build.properties'/>
+   <property name="hsqldb.version" value="1.8.0.10"/>
+
+   <tstamp>
+       <format property="_tmpstamp" pattern="yyyy/MM/dd-hh:mm:ss"
+               locale="en"/>
+   </tstamp>
+
+   <property name="build.label" value="private-${_tmpstamp}"/>
+   <property name="build.vendor" value="${user.name}"/>
+   <property name="hsqldb.title" value="HSQLDB"/>
+   <property name="hsqldb.vendor" value="The HSQLDB Development Group"/>
+   <property name="src" value="${basedir}/src"/>
+   <property name="build.debug" value="off"/>
+
+   <target name="init">
+   </target>
+
+   <target name='explainjars'
+           description="List description of jars that you can build">
+     <echo>jar filename    build command   explanation
+--------------  -------------   -----------------------------------
+hsqldb.jar      ant hsqldb      Default distribution jar
+hsqljdbc.jar    ant hsqljdbc    JDBC client only.  (No direct urls
+                                of form jdbc:hsqldb:mem/file/res:*)
+hsqldbmain.jar  ant hsqldbmain  No utility programs
+hsqldbutil.jar  ant hsqldbutil  Utility programs only.  No JDBC
+                                driver.  (Includes SqlTool and
+                                DatabaseManagers)
+hsqldbmin.jar   ant hsqldbmin   No utility or server programs.
+                                (Include JDBC driver, but no support
+                                for urls of form jdbc:hsqldb:ht*...)
+hsqldbtest.jar  ant hsqldbtest  All, including test classes
+hsqldbz.jar     ant hsqldbz     Min jar plus necessary util classes
+                                for Zaurus
+hsqltool.jar    ant hsqltool    SqlTool client and JDBC driver.
+                                (No direct urls of form
+                                jdbc:hsqldb:mem/file/res:*)
+transfer.jar    ant transfer    Transfer Tool classes only.
+
+jars built with JDK 1.2 OR 1.3 can now be used with JRE 1.1.</echo>
+   </target>
+
+   <!-- Blaine's new jar target naming strategy.
+        Target name is always the same as the desired jar file name, less
+        the ".jar" extension. -->
+   <!-- Commented out descriptions can be enabled if we want to assist
+        people using old-style target names.  If so, remember to remove
+        the trailing "/>" on every first target line. -->
+   <target name='jar' depends='hsqldb'/>
+       <!-- description="Same as target 'hsqldb'"/> -->
+   <target name='jarclient' depends='hsqljdbc'/>
+       <!-- description="Same as target 'hsqljdbc'"/> -->
+   <target name='jarmain' depends='hsqldbmain'/>
+       <!-- description="Same as target 'hsqldbmain'"/> -->
+   <target name='jarmin' depends='hsqldbmin'/>
+       <!-- description="Same as target 'hsqldbmin'"/> -->
+   <target name='jarsqltool' depends='hsqltool'/>
+       <!-- description="Same as target 'hsqltool'"/> -->
+   <target name='jartest' depends='hsqldbtest'/>
+       <!-- description="Same as target 'hsqldbtest'"/> -->
+   <target name='jarutil' depends='hsqldbutil'/>
+       <!-- description="Same as target 'hsqldbutil'"/> -->
+   <target name='jarzaurus' depends='hsqldbz'/>
+       <!-- description="Same as target 'hsqldbz'"/> -->
+
+   <target name="help" description="Top-level help message">
+      <echo>usage:
+   ant -help            Display ant help screen
+   ant -projecthelp     Display all invocable targets
+   ant explainjars      List all targets which build jar files
+   ant ANYTHING ELSE    Run 'ant -projecthelp' for details
+
+   jars built with JDK 1.2 OR 1.3 can now be used with JRE 1.1
+
+examples:
+   ant jar
+   ant clean</echo>
+   </target>
+
+   <target name="-javajsse">
+      <available classname="javax.net.ssl.SSLSession" property="ant.java.hasjsse"/>
+      <echo message="ant.java.hasjsse=${ant.java.hasjsse}" />
+   </target>
+
+   <target name="javaversion7" unless="ant.java.iscjavaset">
+      <available classname="java.util.Objects" property="ant.java.iscjava17"/>
+      <available classname="java.util.Objects" property="ant.java.iscjavaset"/>
+   </target>
+
+   <target name="javaversion6" depends="javaversion7" unless="ant.java.iscjavaset">
+      <available classname="java.net.IDN" property="ant.java.iscjava16"/>
+      <available classname="java.net.IDN" property="ant.java.iscjavaset"/>
+   </target>
+
+   <target name="javaversion4" depends="javaversion6" unless="ant.java.iscjavaset">
+      <available classname="java.nio.Buffer" property="ant.java.iscjava14"/>
+      <available classname="java.nio.Buffer" property="ant.java.iscjavaset"/>
+   </target>
+
+   <target name="javaversion2" depends="javaversion4" unless="ant.java.iscjavaset">
+      <available classname="java.lang.ref.Reference" property="ant.java.iscjava12"/>
+      <available classname="java.lang.ref.Reference" property="ant.java.iscjavaset"/>
+   </target>
+
+   <target name="-prepare" depends="init,javaversion2">
+       <mkdir dir="classes" />
+   </target>
+
+   <target name="-preparedoc" depends="init">
+       <mkdir dir="doc/src" />
+   </target>
+
+   <target name="clean" depends="clean-docwork"
+           description="Delete the /classes directory created by ant tasks">
+        <delete dir="classes"/>
+   </target>
+
+   <target name="cleanall" depends="clean,clean-doc"
+           description="Same as clean but delete the jar files as well">
+      <delete>
+         <fileset dir="lib" includes="hsql*.jar"/>
+      </delete>
+   </target>
+
+    <target name="codeswitcher" depends="-prepare"
+            description="uses +-JAVA2 +-JAVA4">
+      <javac destdir="classes">
+         <src path="${src}"/>
+         <include name="org/hsqldb/util/CodeSwitcher.java"/>
+       </javac>
+    </target>
+
+    <target name="switchtodeprecatedjdbc" depends="codeswitcher"
+            description="self explanatory">
+      <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+        <arg file="${src}/org/hsqldb/jdbc/jdbcCallableStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcPreparedStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSet.java"/>
+        <arg value="+DEPRECATEDJDBC"/>
+      </java>
+    </target>
+
+    <target name="switchoffdeprecatedjdbc" depends="codeswitcher"
+            description="self explanatory">
+      <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+        <arg file="${src}/org/hsqldb/jdbc/jdbcCallableStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcPreparedStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSet.java"/>
+        <arg value="-DEPRECATEDJDBC"/>
+      </java>
+    </target>
+
+    <target name="switches" depends="codeswitcher"
+            description="self explanatory">
+    </target>
+
+    <target name="switchtojdk11" depends="switches" description="self explanatory">
+      <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+        <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
+        <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
+        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcStatement.java"/>
+        <arg file="${src}/org/hsqldb/persist/LockFile.java"/>
+        <arg file="${src}/org/hsqldb/persist/Logger.java"/>
+        <arg file="${src}/org/hsqldb/util/DatabaseManager.java"/>
+        <arg file="${src}/org/hsqldb/util/ConnectionDialogCommon.java"/>
+        <arg value="+JAVA2"/>
+        <arg value="-JAVA2FULL"/>
+        <arg value="-JAVA4"/>
+       </java>
+       <available classname="java.util.Vector" property="noswing"/>
+    </target>
+
+    <target name="switchtojdk13" depends="switches"
+            description="self explanatory" if="ant.java.iscjava12">
+      <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+        <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
+        <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
+        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcBlob.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcDatabaseMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcDataSource.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcDriver.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcCallableStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcClob.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcConnection.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcParameterMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcPreparedStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSet.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSetMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcStatement.java"/>
+        <arg file="${src}/org/hsqldb/persist/LockFile.java"/>
+        <arg file="${src}/org/hsqldb/persist/Logger.java"/>
+        <arg file="${src}/org/hsqldb/persist/ScaledRAFile.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/util/DatabaseManager.java"/>
+        <arg file="${src}/org/hsqldb/util/ConnectionDialogCommon.java"/>
+        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/HsqlDateTime.java"/>
+        <arg value="+JAVA2"/>
+        <arg value="+JAVA2FULL"/>
+        <arg value="-JAVA4"/>
+        <arg value="-JAVA6"/>
+        <arg value="-JAVA7"/>
+       </java>
+    </target>
+
+    <target name="switchtojdk14" depends="switches"
+            description="self explanatory" if="ant.java.iscjava14">
+      <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+        <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
+        <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
+        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcBlob.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcDatabaseMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcDataSource.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcCallableStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcClob.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcConnection.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcParameterMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcPreparedStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSet.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSetMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcStatement.java"/>
+        <arg file="${src}/org/hsqldb/persist/LockFile.java"/>
+        <arg file="${src}/org/hsqldb/persist/Logger.java"/>
+        <arg file="${src}/org/hsqldb/persist/ScaledRAFile.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/util/DatabaseManager.java"/>
+        <arg file="${src}/org/hsqldb/util/ConnectionDialogCommon.java"/>
+        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/HsqlDateTime.java"/>
+        <arg value="+JAVA2"/>
+        <arg value="+JAVA2FULL"/>
+        <arg value="+JAVA4"/>
+        <arg value="-JAVA6"/>
+        <arg value="-JAVA7"/>
+       </java>
+    </target>
+
+
+    <target name="switchtojdk16" depends="switchtojdk14"
+            description="self explanatory" if="ant.java.iscjava16">
+      <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+        <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
+        <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
+        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcBlob.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcDatabaseMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcDataSource.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcCallableStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcClob.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcConnection.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcParameterMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcPreparedStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSet.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSetMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcStatement.java"/>
+        <arg file="${src}/org/hsqldb/persist/LockFile.java"/>
+        <arg file="${src}/org/hsqldb/persist/Logger.java"/>
+        <arg file="${src}/org/hsqldb/persist/ScaledRAFile.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/util/DatabaseManager.java"/>
+        <arg file="${src}/org/hsqldb/util/ConnectionDialogCommon.java"/>
+        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/HsqlDateTime.java"/>
+        <arg value="+JAVA2"/>
+        <arg value="+JAVA2FULL"/>
+        <arg value="+JAVA4"/>
+        <arg value="+JAVA6"/>
+        <arg value="-JAVA7"/>
+      </java>
+    </target>
+
+    <target name="switchtojdk17" depends="switchtojdk16"
+            description="self explanatory" if="ant.java.iscjava17">
+      <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+        <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
+        <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
+        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcBlob.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcDatabaseMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcDataSource.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcCallableStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcClob.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcConnection.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcParameterMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcPreparedStatement.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSet.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSetMetaData.java"/>
+        <arg file="${src}/org/hsqldb/jdbc/jdbcStatement.java"/>
+        <arg file="${src}/org/hsqldb/persist/LockFile.java"/>
+        <arg file="${src}/org/hsqldb/persist/Logger.java"/>
+        <arg file="${src}/org/hsqldb/persist/ScaledRAFile.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/util/DatabaseManager.java"/>
+        <arg file="${src}/org/hsqldb/util/ConnectionDialogCommon.java"/>
+        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
+        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
+        <arg file="${src}/org/hsqldb/HsqlDateTime.java"/>
+        <arg value="+JAVA2"/>
+        <arg value="+JAVA2FULL"/>
+        <arg value="+JAVA4"/>
+        <arg value="+JAVA6"/>
+        <arg value="+JAVA7"/>
+      </java>
+    </target>
+
+    <target name="store" depends="switchtojdk17"
+            description="compiles the /store folder">
+      <javac srcdir="${src}"
+             destdir="classes"
+                 debug="${build.debug}"
+                 optimize="${build.optimize}"
+      >
+         <include name="org/hsqldb/store/**"/>
+      </javac>
+    </target>
+
+    <target name="lib" depends="store"
+            description="compiles the /lib folder">
+      <javac srcdir="${src}"
+             destdir="classes"
+                 debug="${build.debug}"
+                 optimize="${build.optimize}"
+      >
+         <include name="org/hsqldb/lib/**"/>
+         <include name="org/hsqldb/lib/java/**"/>
+      </javac>
+    </target>
+
+    <target name="classes" depends="lib,-javajsse"
+            description="compiles all the classes">
+      <javac srcdir="${src}"
+             destdir="classes"
+                 debug="${build.debug}"
+                 optimize="${build.optimize}"
+       >
+         <classpath>
+            <pathelement location="/usr/share/java/servlet-api-3.1.jar"/>
+         </classpath>
+         <include name="*.java"/>
+         <include name="org/hsqldb/*.java"/>
+         <include name="org/hsqldb/index/*.java"/>
+         <include name="org/hsqldb/jdbc/*.java"/>
+         <include name="org/hsqldb/persist/*.java"/>
+         <include name="org/hsqldb/resources/*.java"/>
+         <include name="org/hsqldb/rowio/*.java"/>
+         <include name="org/hsqldb/scriptio/*.java"/>
+         <include name="org/hsqldb/types/*.java"/>
+         <exclude name="org/hsqldb/HsqlSocketFactorySecure.java" unless="ant.java.hasjsse"/>
+         <exclude name="org/hsqldb/jdbc/jdbcBlob.java"/>
+         <exclude name="org/hsqldb/jdbc/jdbcClob.java"/>
+         <exclude name="org/hsqldb/jdbc/jdbcDataSourceFactory.java"/>
+         <exclude name="org/hsqldb/jdbc/jdbcParameterMetaData.java"/>
+         <exclude name="org/hsqldb/jdbc/jdbcSavepoint.java"/>
+         <exclude name="org/hsqldb/persist/NIOLockFile.java"/>
+         <exclude name="org/hsqldb/persist/ScaledRAFileNIO.java"/>
+         <exclude name="org/hsqldb/persist/ScaledRAFileHybrid.java"/>
+      </javac>
+      <copy todir="${basedir}/classes">
+        <fileset dir="${src}" includes="**/*.properties, **/*.text"/>
+      </copy>
+    </target>
+
+
+   <target name="classes14" depends="classes" if="ant.java.iscjava14"
+           description="compiles 1.4 specific classes">
+      <javac srcdir="${src}"
+             destdir="classes"
+                 debug="${build.debug}"
+                 optimize="${build.optimize}"
+       >
+      <include name="org/hsqldb/jdbc/jdbcDataSourceFactory.java"/>
+      <include name="org/hsqldb/jdbc/jdbcParameterMetaData.java"/>
+      <include name="org/hsqldb/jdbc/jdbcSavepoint.java"/>
+      <include name="org/hsqldb/persist/NIOLockFile.java"/>
+      <include name="org/hsqldb/persist/ScaledRAFileNIO.java"/>
+      <include name="org/hsqldb/persist/ScaledRAFileHybrid.java"/>
+      </javac>
+   </target>
+
+   <target name="-test14" if="ant.java.iscjava14"
+           description="compiles 1.4-specific test classes">
+      <javac srcdir="${src}"
+             destdir="classes"
+             debug="${build.debug}"
+             optimize="${build.optimize}"
+             classpath="lib/junit.jar"
+       >
+          <include name="org/hsqldb/test/TestJDBCSavepoints.java"/>
+          <include name="org/hsqldb/test/SqlToolHarness.java"/>
+          <include name="org/hsqldb/test/TestSqlTool*.java"/>
+      </javac>
+   </target>
+
+    <target name="util" depends="lib"
+            description="compiles the /util folder">
+      <javac srcdir="${src}"
+             destdir="classes"
+                 debug="${build.debug}"
+                 optimize="${build.optimize}"
+      >
+         <include name="org/hsqldb/util/**"/>
+         <exclude name="org/hsqldb/util/*Swing.java"/>
+         <exclude name="org/hsqldb/util/TableSorter.java"/>
+      </javac>
+      <copy todir="classes/org/hsqldb/util">
+          <fileset dir="${src}/org/hsqldb/util" includes='*.gif, *.png'/>
+      </copy>
+    </target>
+
+   <target name="swing" depends="util" unless="noswing"
+           description="compiles the swing based classes in the /util folder">
+      <javac srcdir="${src}"
+             destdir="classes"
+                 debug="${build.debug}"
+                 optimize="${build.optimize}"
+       >
+      <include name="org/hsqldb/util/*Swing.java"/>
+      <include name="org/hsqldb/util/TableSorter.java"/>
+      </javac>
+   </target>
+
+   <target name="test" depends="classes14"
+           description="compiles the /test folder">
+      <available property='_junit_available' file='lib/junit.jar' type='file'/>
+      <fail unless='_junit_available'
+            message="'junit.jar' must reside in the /lib directory in order to use this target"/>
+      <javac srcdir="${src}"
+             destdir="classes"
+                 debug="${build.debug}"
+                 optimize="${build.optimize}"
+         >
+         <classpath>
+            <pathelement location="lib/junit.jar"/>
+            <pathelement location="lib/dbunit.jar"/>
+         </classpath>
+         <include name="org/hsqldb/test/**"/>
+         <exclude name="org/hsqldb/test/TestJDBCSavepoints.java"/>
+         <exclude name="org/hsqldb/test/*SqlTool*.java"/>
+      </javac>
+      <antcall inheritall='true' target='-test14'/>
+   </target>
+
+    <target name="hsqldbz" depends="classes14,util"
+            description="Build the hsqldbz.jar for Zaurus">
+        <jar jarfile="lib/hsqldbz.jar"
+             basedir="classes"
+         >
+         <manifest>
+             <attribute name='Specification-Title' value='${hsqldb.title}'/>
+             <attribute name='Specification-Version' value='${hsqldb.version}'/>
+             <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+             <attribute name='Implementation-Title'
+                        value='Zaurus runtime'/>
+             <attribute name='Implementation-Version' value='${build.label}'/>
+             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+         </manifest>
+         <exclude name="org/hsqldb/jmx/**"/>
+         <exclude name="org/hsqldb/util/*Transfer*.*"/>
+         <exclude name="org/hsqldb/util/*Swing*.*"/>
+         <exclude name="org/hsqldb/util/DataAccess*.*"/>
+         <exclude name="org/hsqldb/util/*Helper*.*"/>
+         <exclude name="org/hsqldb/util/JDBCTypes.*"/>
+         <exclude name="org/hsqldb/util/SQLStatements.*"/>
+         <exclude name="org/hsqldb/util/QueryTool.*"/>
+         <exclude name="org/hsqldb/util/ShutdownServer.*"/>
+         <exclude name="org/hsqldb/util/CodeSwitcher.*"/>
+         <exclude name="org/hsqldb/test/*.*"/>
+         <exclude name="org/hsqldb/sample/*.*"/>
+         <exclude name="hsqlServlet.class"/>
+         <exclude name="org/hsqldb/Servlet.class"/>
+         <exclude name="org/hsqldb/HsqlServerFactory.class"/>
+         <exclude name="org/hsqldb/HsqlServerProperties.class"/>
+         <exclude name="org/hsqldb/HsqlSocketRequestHandler.class"/>
+         <exclude name="org/hsqldb/HsqlSocketRequestHandlerImpl.class"/>
+         <exclude name="org/hsqldb/jdbc/jdbcDataSource.class"/>
+         <exclude name="org/hsqldb/jdbc/jdbcDataSourceFactory.class"/>
+         <exclude name="org/hsqldb/Server.class"/>
+         <exclude name="org/hsqldb/ServerConnection.class"/>
+         <exclude name="org/hsqldb/WebServer.class"/>
+         <exclude name="org/hsqldb/WebServerConnection.class"/>
+         <exclude name="org/hsqldb/jdbc/jdbcStubs.class"/>
+         <exclude name="org/hsqldb/jdbc/Array.class"/>
+         <exclude name="org/hsqldb/jdbc/Blob.class"/>
+         <exclude name="org/hsqldb/jdbc/Clob.class"/>
+         <exclude name="org/hsqldb/jdbc/Ref.class"/>
+         <exclude name="org/hsqldb/jdbc/Map.class"/>
+       </jar>
+    </target>
+
+    <target name="hsqldbtest" depends="test,swing"
+            description="Build the hsqldbtest.jar (default plus test classes)">
+        <jar jarfile="lib/hsqldbtest.jar"
+             basedir="classes"
+         >
+         <manifest>
+             <attribute name='Specification-Title' value='${hsqldb.title}'/>
+             <attribute name='Specification-Version' value='${hsqldb.version}'/>
+             <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+             <attribute name='Implementation-Title'
+                        value='Test runtime'/>
+             <attribute name='Implementation-Version' value='${build.label}'/>
+             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+         </manifest>
+         <exclude name="org/hsqldb/jmx/**"/>
+         <exclude name="org/hsqldb/sample/*.*"/>
+         <exclude name="org/hsqldb/jdbc/jdbcStubs.class"/>
+         <exclude name="org/hsqldb/jdbc/Array.class"/>
+         <exclude name="org/hsqldb/jdbc/Blob.class"/>
+         <exclude name="org/hsqldb/jdbc/Clob.class"/>
+         <exclude name="org/hsqldb/jdbc/Ref.class"/>
+         <exclude name="org/hsqldb/jdbc/Map.class"/>
+      </jar>
+    </target>
+
+    <target name="hsqldbmain" depends="classes14"
+            description="Build the hsqldbmain.jar (no utilities) (use '-Dnoswing=true jarmain' to exclude swing classes)">
+        <jar jarfile="lib/hsqldbmain.jar"
+             basedir="classes"
+         >
+         <manifest>
+             <attribute name='Specification-Title' value='${hsqldb.title}'/>
+             <attribute name='Specification-Version' value='${hsqldb.version}'/>
+             <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+             <attribute name='Implementation-Title'
+                        value='Runtime without utilities'/>
+             <attribute name='Implementation-Version' value='${build.label}'/>
+             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+         </manifest>
+         <exclude name="org/hsqldb/jmx/**"/>
+         <exclude name="org/hsqldb/util/**"/>
+         <exclude name="org/hsqldb/test/**"/>
+         <exclude name="org/hsqldb/sample/**"/>
+         <exclude name="org/hsqldb/jdbc/jdbcStubs.class"/>
+         <exclude name="org/hsqldb/jdbc/Array.class"/>
+         <exclude name="org/hsqldb/jdbc/Blob.class"/>
+         <exclude name="org/hsqldb/jdbc/Clob.class"/>
+         <exclude name="org/hsqldb/jdbc/Ref.class"/>
+         <exclude name="org/hsqldb/jdbc/Map.class"/>
+      </jar>
+    </target>
+
+    <target name="hsqldbmin" depends="classes14"
+            description="Build the hsqldbmin.jar (no servers)">
+        <jar jarfile="lib/hsqldbmin.jar"
+             basedir="classes"
+         >
+         <manifest>
+             <attribute name='Specification-Title' value='${hsqldb.title}'/>
+             <attribute name='Specification-Version' value='${hsqldb.version}'/>
+             <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+             <attribute name='Implementation-Title'
+                 value='Runtime without utilities and servers'/>
+             <attribute name='Implementation-Version' value='${build.label}'/>
+             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+         </manifest>
+         <exclude name="org/hsqldb/jdbc/jdbcStubs.class"/>
+         <exclude name="org/hsqldb/jdbc/Array.class"/>
+         <exclude name="org/hsqldb/jdbc/Blob.class"/>
+         <exclude name="org/hsqldb/jdbc/Clob.class"/>
+         <exclude name="org/hsqldb/jdbc/Ref.class"/>
+         <exclude name="org/hsqldb/jdbc/Map.class"/>
+         <exclude name="org/hsqldb/jdbc/jdbcDataSourceFactory.class"/>
+         <exclude name="org/hsqldb/jmx/**"/>
+         <exclude name="org/hsqldb/util/**"/>
+         <exclude name="org/hsqldb/test/**"/>
+         <exclude name="org/hsqldb/sample/**"/>
+         <exclude name="**/*.properties"/>
+         <exclude name="hsqlServlet.class"/>
+         <exclude name="org/hsqldb/Servlet.class"/>
+         <exclude name="org/hsqldb/HsqlSocketFactory.class"/>
+         <exclude name="org/hsqldb/HsqlSocketFactorySecure.class"/>
+         <exclude name="org/hsqldb/HsqlServerFactory.class"/>
+         <exclude name="org/hsqldb/HsqlServerProperties.class"/>
+         <exclude name="org/hsqldb/HsqlSocketRequestHandler.class"/>
+         <exclude name="org/hsqldb/HsqlSocketRequestHandlerImpl.class"/>
+         <exclude name="org/hsqldb/Server.class"/>
+         <exclude name="org/hsqldb/ServerConnection.class"/>
+         <exclude name="org/hsqldb/WebServer.class"/>
+         <exclude name="org/hsqldb/WebServerConnection.class"/>
+         <exclude name="org/hsqldb/rowio/RowInputLegacy.class"/>
+         <exclude name="org/hsqldb/rowio/RowOutputLegacy.class"/>
+         <exclude name="org/hsqldb/DIProcedureInfo.class"/>
+         <exclude name="org/hsqldb/HSQLClientConnection.class"/>
+         <exclude name="org/hsqldb/HTTPClientConnection.class"/>
+         <fileset dir="classes"
+                includes="org/hsqldb/resources/sql-error-messages.properties"/>
+       </jar>
+    </target>
+
+    <target name="hsqldb" depends="classes14,util,swing"
+            description="Build the default hsqldb.jar">
+        <jar jarfile="lib/hsqldb.jar"
+             basedir="classes"
+             compress="true"
+         >
+         <manifest>
+             <attribute name='Specification-Title' value='${hsqldb.title}'/>
+             <attribute name='Specification-Version' value='${hsqldb.version}'/>
+             <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+             <attribute name='Implementation-Title'
+                        value='Standard runtime'/>
+             <attribute name='Implementation-Version' value='${build.label}'/>
+             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+             <!-- This attribute is completely ignored unless the user
+                  uses the jar like "java -jar .../hsqldb.jar" -->
+             <attribute name='Main-Class' value='org.hsqldb.util.SqlTool'/>
+         </manifest>
+         <exclude name="org/hsqldb/jmx/**"/>
+         <exclude name="org/hsqldb/util/*Swing.*" if="noswing"/>
+         <exclude name="org/hsqldb/util/*Transfer*.*"/>
+         <exclude name="org/hsqldb/util/DataAccess*.*"/>
+         <exclude name="org/hsqldb/util/*Helper*.*"/>
+         <exclude name="org/hsqldb/util/JDBCTypes.*"/>
+         <exclude name="org/hsqldb/util/SQLStatements.*"/>
+         <exclude name="org/hsqldb/util/QueryTool.*"/>
+         <exclude name="org/hsqldb/util/Zaurus*.*"/>
+         <exclude name="org/hsqldb/test/*.class"/>
+         <exclude name="org/hsqldb/sample/*.class"/>
+         <exclude name="org/hsqldb/jdbcStubs.class"/>
+         <exclude name="org/hsqldb/jdbc/Array.class"/>
+         <exclude name="org/hsqldb/jdbc/Blob.class"/>
+         <exclude name="org/hsqldb/jdbc/Clob.class"/>
+         <exclude name="org/hsqldb/jdbc/Ref.class"/>
+         <exclude name="org/hsqldb/jdbc/Map.class"/>
+      </jar>
+    </target>
+
+    <fileset id='jdbcclasses' dir='classes'
+        includes='org/hsqldb/lib/ArrayUtil*,
+                  org/hsqldb/lib/AsciiStringInputStream*,
+                  org/hsqldb/lib/HsqlByte*,
+                  org/hsqldb/lib/IntValueHashMap*,
+                  org/hsqldb/lib/InOutUtil*,
+                  org/hsqldb/lib/Iterator*,
+                  org/hsqldb/lib/HsqlHeap*,
+                  org/hsqldb/lib/HsqlArray*,
+                  org/hsqldb/lib/ObjectComparator*,
+                  org/hsqldb/lib/IntKeyHashMap*,
+                  org/hsqldb/lib/Collection*,
+                  org/hsqldb/lib/*List*,
+                  org/hsqldb/lib/Set*,
+                  org/hsqldb/lib/Hash*,
+                  org/hsqldb/lib/HsqlTimer*,
+                  org/hsqldb/lib/StringConverter*,
+                  org/hsqldb/lib/StringInputStream*,
+                  org/hsqldb/lib/java/JavaSystem*,
+                  org/hsqldb/jdbc/jdbc*,
+                  org/hsqldb/jdbc/Util*,
+                  org/hsqldb/rowio/RowOutputBase*,
+                  org/hsqldb/rowio/RowInputBase*,
+                  org/hsqldb/rowio/RowOutputBinary*,
+                  org/hsqldb/rowio/RowInputBinary*,
+                  org/hsqldb/rowio/RowOutputInterface*,
+                  org/hsqldb/rowio/RowInputInterface*,
+                  org/hsqldb/persist/HsqlDatabaseProperties*,
+                  org/hsqldb/persist/HsqlProperties*,
+                  org/hsqldb/store/ValuePool*,
+                  org/hsqldb/store/HashIndex*,
+                  org/hsqldb/store/BaseHashMap*,
+                  org/hsqldb/types/*,
+                  org/hsqldb/Column*,
+                  org/hsqldb/DatabaseURL*,
+                  org/hsqldb/HSQLClient*,
+                  org/hsqldb/HsqlDateTime*,
+                  org/hsqldb/HsqlException*,
+                  org/hsqldb/HsqlSocketFactory*,
+                  org/hsqldb/HTTPClientConnection*,
+                  org/hsqldb/jdbcDriver*,
+                  org/hsqldb/Library*,
+                  org/hsqldb/Record*,
+                  org/hsqldb/Result*,
+                  org/hsqldb/Result$*,
+                  org/hsqldb/Row*,
+                  org/hsqldb/SessionInterface*,
+                  org/hsqldb/Trace*,
+                  org/hsqldb/Types*,
+                  org/hsqldb/resources/*
+                  '/>
+
+    <fileset id='utilclasses' dir='classes'
+        includes='org/hsqldb/util/**,
+                  '/>
+
+    <fileset id='sqltoolclasses' dir='classes'
+        includes='org/hsqldb/util/SqlTool*,
+                  org/hsqldb/util/RCData*,
+                  org/hsqldb/util/RefCapablePropertyResourceBundle*,
+                  org/hsqldb/util/SqltoolRB*,
+                  org/hsqldb/util/ValidatingResourceBundle*,
+                  org/hsqldb/util/AppendableException*,
+                  org/hsqldb/util/SqlToolError*,
+                  org/hsqldb/util/SqlFile*
+                  org/hsqldb/lib/StringUtil*
+                  org/hsqldb/lib/FileAccess*
+                  '/>
+    <fileset id='sqltoolres' dir='classes'
+        includes='org/hsqldb/util/**/*.text,
+                  org/hsqldb/util/**/*.properties
+                  '/>
+
+<!-- classes referenced by the org.hsqldb.jdbc package classes -->
+<!-- or the org.hsqldb.jdbcDriver class are included here with some -->
+<!-- ommissions where the calling methods are not actually used -->
+    <target name="hsqljdbc" depends="classes14"
+             description="Build the hsqljdbc.jar">
+        <jar jarfile="lib/hsqljdbc.jar" compress="true">
+          <manifest>
+             <attribute name='Specification-Title' value='${hsqldb.title}'/>
+             <attribute name='Specification-Version' value='${hsqldb.version}'/>
+             <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+             <attribute name='Implementation-Title'
+                        value='JDBC client runtime'/>
+             <attribute name='Implementation-Version' value='${build.label}'/>
+             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+          </manifest>
+          <fileset refid='jdbcclasses'/>
+        </jar>
+    </target>
+
+    <target name="hsqltool" depends="classes14, util"
+            description="Build the hsqltool.jar">
+        <jar jarfile="lib/hsqltool.jar">
+            <manifest>
+                <attribute name='Specification-Title' value='${hsqldb.title}'/>
+                <attribute name='Specification-Version' value='${hsqldb.version}'/>
+                <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+                <attribute name='Implementation-Title'
+                           value='SqlTool runtime, with JDBC driver'/>
+                <attribute name='Implementation-Version' value='${build.label}'/>
+                <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+                <attribute name='Main-Class' value='org.hsqldb.util.SqlTool'/>
+            </manifest>
+            <!-- including 'org/hsqldb/jdbc*' just to be safe -->
+            <fileset refid='jdbcclasses'/>
+            <fileset refid='sqltoolclasses'/>
+            <fileset refid='sqltoolres'/>
+        </jar>
+    </target>
+
+    <target name="transfer" depends="classes14, util"
+            description="Build the transfer.jar">
+        <jar jarfile="lib/transfer.jar">
+            <manifest>
+                <attribute name='Specification-Title' value='${hsqldb.title}'/>
+                <attribute name='Specification-Version' value='${hsqldb.version}'/>
+                <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+                <attribute name='Implementation-Title'
+                           value='HSQLDB Transfer Tool classes'/>
+                <attribute name='Implementation-Version' value='${build.label}'/>
+                <attribute name='Class-Path' value='hsqldb.jar'/>
+                <attribute name='Main-Class' value='org.hsqldb.util.DatabaseManagerSwing'/>
+                <!-- If we prefer to encourage use of Transfer instead of
+                     using Transfer functionality from DatabaseManager, then
+                     change the Main-Class to org.hsqldb.util.Transfer. -->
+            </manifest>
+            <!-- including 'org/hsqldb/jdbc*' just to be safe -->
+            <fileset dir='classes'
+                includes='
+                    org/hsqldb/util/Transfer*,
+                    org/hsqldb/util/DataAccessPoint*,
+                    org/hsqldb/util/HelperFactory*
+                    org/hsqldb/util/*TransferHelper*
+                    org/hsqldb/util/JDBCTypes*
+                    org/hsqldb/util/SQLStatements*
+            '/>
+        </jar>
+    </target>
+
+    <target name="hsqldbutil" depends="util,swing"
+            description="Build the utility hsqldbutil.jar">
+        <jar jarfile="lib/hsqldbutil.jar" compress="true">
+         <manifest>
+             <attribute name='Specification-Title' value='${hsqldb.title}'/>
+             <attribute name='Specification-Version' value='${hsqldb.version}'/>
+             <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+             <attribute name='Implementation-Title'
+                        value='Utilities runtime, without JDBC driver'/>
+             <attribute name='Implementation-Version' value='${build.label}'/>
+             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+             <!-- N.b. Blaine removed the Main-Class because this jar is
+                  useless without a JDBC driver in the classpath, and you
+                  can't add to classpath if invoked with "-jar" -->
+         </manifest>
+         <fileset refid='utilclasses'/>
+      </jar>
+    </target>
+
+    <target name="javadoc" depends="-preparedoc"
+            description="Create javadoc for the distribution package">
+      <javadoc
+		   sourcefiles="${src}/org/hsqldb/jdbcDriver.java,
+                        ${src}/org/hsqldb/Trigger.java,
+		   				${src}/org/hsqldb/Server.java,
+		   				${src}/org/hsqldb/WebServer.java,
+		   				${src}/org/hsqldb/sample/TriggerSample.java,
+		   				${src}/org/hsqldb/util/RCData.java,
+		   				${src}/org/hsqldb/util/SqlTool.java"
+           destdir="${basedir}/doc/src"
+           classpath="/usr/share/java/servlet-api-3.1.jar;${basedir}/lib/junit.jar"
+           author="true"
+           version="false"
+           use="true"
+           public="true"
+           stylesheetfile="${basedir}/doc/src/hsqldbstylesheet.css"
+           windowtitle="${hsqldb.title} ${hsqldb.version} API"
+           doctitle="${hsqldb.title} ${hsqldb.version}"
+           bottom="&lt;i&gt;Copyright &#169; 2001 - 2005 HSQL Development Group. All Rights Reserved.&lt;/i&gt;">
+           <packageset dir='${src}'>
+               <include name='org/hsqldb/jdbc'/>
+           </packageset>
+
+     </javadoc>
+   </target>
+
+    <target name="javadocdev" depends="-preparedoc"
+            description="Create javadoc for developers">
+      <javadoc packagenames="org.hsqldb.*,org.hsqldb.jdbc.*,org.hsqldb.lib.*,org.hsqldb.util.*"
+           sourcepath="${src}"
+           destdir="${basedir}/doc/src"
+           classpath="/usr/share/java/servlet-api-3.1.jar;${basedir}/lib/junit.jar"
+           author="true"
+           version="false"
+           use="true"
+           public="true"
+           stylesheetfile="${basedir}/doc/src/hsqldbstylesheet.css"
+           windowtitle="${hsqldb.title} ${hsqldb.version} API"
+           doctitle="${hsqldb.title} ${hsqldb.version}"
+           bottom="&lt;i&gt;Copyright &#169; 2001 - 2005 HSQL Development Group. All Rights Reserved.&lt;/i&gt;">
+     </javadoc>
+   </target>
+
+   <!-- ******************************************************************* -->
+   <!--  From here down to the matching ******* line, DocBook-related stuff -->
+
+    <!-- Only do vigilant runtime checking for props for externally
+         executable targets.  Requirements for internals are just noted -->
+
+    <property name='fop-loglevel' value='error'/>
+    <property name='style.html' value='${docbook.xsl.home}/html/docbook.xsl'/>
+    <property name='style.chunk' value='${docbook.xsl.home}/html/chunk.xsl'/>
+    <property name='style.fo' value='${docbook.xsl.home}/fo/docbook.xsl'/>
+    <!-- This is default only for invoking some external docbook targets -->
+    <property name='outputType' value='html'/>
+
+    <!-- Note that we do not generate postscript by default -->
+    <target name='docbook'
+        description='Generate all DocBook docs in HTML and PDF formats'
+            depends='docbooks-html, docbooks-chunk, docbooks-pdf'/>
+
+    <target name='docbooks-html' depends='-initContrib'
+            description='Generate all DocBook non-chunk HTML output'>
+        <antcall inheritall='false' target='-ddIterate'>
+            <param name='outputType' value='html'/>
+        </antcall>
+    </target>
+    <target name='docbooks-chunk' depends='-initContrib'
+            description='Generate all DocBook Chunk HTML output'>
+        <antcall inheritall='false' target='-ddIterate'>
+            <param name='outputType' value='chunk'/>
+        </antcall>
+    </target>
+    <target name='docbooks-pdf' depends='-initContrib'
+            description='Generate all DocBook PDF output'>
+        <antcall inheritall='false' target='-ddIterate'>
+            <param name='outputType' value='pdf'/>
+        </antcall>
+    </target>
+    <target name='docbooks-ps' depends='-initContrib'
+            description='Generate all DocBook Postscript output'>
+        <antcall inheritall='false' target='-ddIterate'>
+            <param name='outputType' value='ps'/>
+        </antcall>
+    </target>
+
+    <target name='-ddIterate'>
+        <!-- Iterate through docsrc dirs, invoking condlGenbok for each -->
+        <!-- Internal caller MUST set 'outputType' -->
+        <pathconvert property='_docsrcdirs' targetos='unix' pathsep='|'
+                     setonempty='false'> <path>
+             <dirset dir='docsrc' includes='*'/>
+        </path> </pathconvert>
+        <!-- If is needed so that ant doesn't fail if there are no
+             DocDir documents -->
+        <if><isset property='_docsrcdirs'/><then>
+            <foreach list='${_docsrcdirs}' param='docdirpath' inheritall='false'
+                     target='-condlGenbook' delimiter='|'>
+                <param name='outputType' value='${outputType}'/>
+            </foreach>
+        </then></if>
+    </target>
+
+    <target name='-condlGenbook'>
+        <!-- Conditionally run target 'html' or 'chunked' or 'pdf' -->
+        <!-- Internal caller MUST set 'docdirpath' and 'outputType' -->
+        <!-- Invoke genbook target iff corresponding DocBook src file exists -->
+        <basename property='book' file='${docdirpath}'/>
+        <!-- Note that inheritall is true, so we pass through all vars, incl.
+             'book'.  N.b. This target (-condlGenbook) should be called
+             with inheritall false!! -->
+        <if> <available type='file' file='${docdirpath}/${book}.xml'/> <then>
+            <antcall target='${outputType}'/>
+        </then> </if>
+    </target>
+
+    <target name='-preDocbook'>
+        <!-- description='Run before generating docbook for a partic. dir -->
+        <!-- Required Props:  book -->
+        <mkdir dir='docwork/${book}/cdata'/>
+        <if><not><uptodate targetfile='docwork/${book}/cdata/.status'>
+            <!-- Mappers don't work with multiple patterns.
+            Therefore, have to use a timestamp file.  -->
+            <srcfiles dir='src/org/hsqldb/sample'
+             includes='*.java, *.txt, *.ksh, *.properties, *.rc, *.cfg, *.sql'/>
+        </uptodate></not><then>
+            <!-- This copies files matching the fileset below to the docwork
+                 dir w/ data so that DocBook may entity include them.
+                 For the time being, these files must reside in the main
+                 directory  for this specific book. -->
+            <pathconvert property='_virginfiles' targetos='unix' pathsep='|'
+                         setonempty='false'> <path>
+                 <fileset dir='src/org/hsqldb/sample'
+             includes='*.java, *.txt, *.ksh, *.properties, *.rc, *.cfg, *.sql'/>
+            </path> </pathconvert>
+            <if><isset property='_virginfiles'/><then>
+                <foreach list='${_virginfiles}' param='vfile' inheritall='false'
+                    target='-sandwich' delimiter='|'>
+                    <param name='book' value='${book}'/>
+                </foreach>
+            </then></if>
+        </then></if>
+        <touch file='docwork/${book}/cdata/.status'/>
+    </target>
+
+    <target name='-postDocbook'>
+        <!-- Run after generating docbook for a partic. dir -->
+        <!-- Property 'book' MUST be set before calling this target -->
+        <copy todir='doc'>
+            <fileset dir='docsrc' excludes='.*, *.css, *.java, *.sql, *.txt'/>
+        </copy>
+        <copy todir='doc/${book}'>
+            <fileset dir='docsrc/${book}'
+                     excludes='.*, *.css, *.java, *.sql, *.txt'/>
+        </copy>
+        <delete file='doc/${book}/${book}.bs'/>
+    </target>
+
+    <target name='chunk' description='Build one Chunk HTML DocBook book'
+            depends='-setXsltFilesets'>
+        <fail unless='book'
+              message="You must set property 'book' to use target 'chunk'"/>
+        <dependset>
+            <srcfileset refid='sharedXsltSrcFiles'/>
+            <srcfileset refid='bookXsltSrcFiles'/>
+              <!-- This messy because ant doesn't support wildcard
+              ch[0-9]*.html -->
+            <targetfileset  dir='doc/${book}'
+                includes='ch0*.html, ch1*.html, ch2*.html, ch3*.html,
+                         ch4*.html, ch5*.htlm, ch6*.html, ch7*.html,
+                         ch8*.html, ch9*.html, index.html'/>
+        </dependset>
+        <if><not><available type='file' file='doc/${book}/index.html'/></not>
+        <then>
+            <antcall target='-preDocbook'/>
+            <fail unless='style.chunk'
+                  message="You must set property 'style.chunk'"/>
+            <antcall target='-htmlXslt' inheritall='false'>
+                <param name='_stylesheet' value='${style.chunk}'/>
+                <param name='book' value='${book}'/>
+                <param name='_ext' value='.bs'/>
+            </antcall>
+            <antcall target='-postDocbook'/>
+        </then></if>
+        <copy todir='doc'>
+            <fileset dir='docsrc'
+                     includes='**/*.css, **/*.java, **/*.sql, **/*.txt'/>
+        </copy>
+    </target>
+    <target name='html' description='Build one single-page HTML DocBook book'
+            depends='-setXsltFilesets'>
+        <fail unless='book'
+              message="You must set property 'book' to use target 'html'"/>
+        <dependset>
+            <srcfileset refid='sharedXsltSrcFiles'/>
+            <srcfileset refid='bookXsltSrcFiles'/>
+            <targetfileset  dir='doc/${book}' includes='${book}.html'/>
+        </dependset>
+        <if><not><available type='file' file='doc/${book}/${book}.html'/></not>
+        <then>
+            <antcall target='-preDocbook'/>
+            <antcall target='-htmlXslt' inheritall='false'>
+                <param name='_stylesheet' value='${style.html}'/>
+                <param name='book' value='${book}'/>
+            </antcall>
+            <antcall target='-postDocbook'/>
+        </then></if>
+        <copy todir='doc'>
+            <fileset dir='docsrc'
+includes='**/*.css, **/*.java, **/*.sql, **/*.txt, **/*.properties, **/*.cfg'/>
+        </copy>
+    </target>
+    <target name='fo' description='Build one DocBook FO file'
+            depends='-initContrib, -setXsltFilesets'>
+        <fail unless='book'
+              message="You must set property 'book' to use target 'fo'"/>
+        <dependset>
+            <!-- Images and included files may be needed for .fo gen and
+                 pdf/ps gen.  Need to test that to optimize the dependsets. -->
+            <srcfileset refid='sharedXsltSrcFiles'/>
+            <srcfileset refid='bookXsltSrcFiles'/>
+              <!-- This messy because ant doesn't support wildcard
+              ch[0-9]*.html -->
+            <targetfilelist  dir='docwork/${book}' files='${book}.fo'/>
+        </dependset>
+        <if><not><available type='file'
+                            file='docwork/${book}/${book}.fo'/></not>
+        <then>
+            <antcall target='-preDocbook'/>
+            <fail unless='style.html'
+                  message="You must set property 'style.html'"/>
+            <antcall target='-foXslt' inheritall='false'>
+                <param name='book' value='${book}'/>
+            </antcall>
+            <antcall target='-postDocbook'/>
+        </then></if>
+    </target>
+    <target name='pdf' depends='fo'>
+        <!-- The depended-upon fo target will check required props -->
+        <dependset>
+            <!-- Images and included files may be needed for .fo gen and
+                 pdf/ps gen.  Need to test that to optimize the dependsets. -->
+            <srcfileset refid='sharedXsltSrcFiles'/>
+            <srcfileset refid='bookXsltSrcFiles'/>
+            <srcfilelist dir='docwork/${book}' files='${book}.fo'/>
+            <targetfilelist dir='doc/${book}' files='${book}.pdf'/>
+        </dependset>
+        <if><not><available type='file' file='doc/${book}/${book}.pdf'/></not>
+        <then>
+            <antcall target='-fop' inheritall='false'>
+                <param name='_lvl' value='${fop-loglevel}'/>
+                <param name='_fmt' value='application/pdf'/>
+                <param name='book' value='${book}'/>
+            </antcall>
+        </then></if>
+    </target>
+    <target name='ps' depends='fo'>
+        <!-- The depended-upon fo target will check required props -->
+        <dependset>
+            <!-- Images and included files may be needed for .fo gen and
+                 pdf/ps gen.  Need to test that to optimize the dependsets. -->
+            <srcfileset refid='sharedXsltSrcFiles'/>
+            <srcfileset refid='bookXsltSrcFiles'/>
+            <srcfilelist dir='docwork/${book}' files='${book}.fo'/>
+            <targetfilelist dir='doc/${book}' files='${book}.ps'/>
+        </dependset>
+        <if><not><available type='file' file='doc/${book}/${book}.ps'/></not>
+        <then>
+            <antcall target='-fop' inheritall='false'>
+                <param name='_lvl' value='${fop-loglevel}'/>
+                <param name='_fmt' value='application/postscript'/>
+                <param name='book' value='${book}'/>
+            </antcall>
+        </then></if>
+    </target>
+
+    <target name='-checkXslt' unless='_xsltChecked'>
+        <!-- Don't call this before -initContrib called -->
+        <if><not> <available
+            classname='org.apache.xalan.processor.TransformerFactoryImpl'/>
+        </not><then>
+        <fail message="XSLT library not available.  See 'readmedocbook.txt'"/>
+        </then></if>
+        <property name='_xsltChecked' value='true'/>
+    </target>
+
+    <target name='-setXsltFilesets'>
+        <!-- You MUST set property 'book' before calling this target -->
+        <fileset id='bookXsltSrcFiles' dir='docsrc/${book}'
+            includes='**/*.xml, **/*.png, **/*.jpg, **/*.txt, **/*.java,
+                      **/*.sql, **/*.properties, **/*.rc, **/*.cfg'/>
+        <fileset id='sharedXsltSrcFiles' dir='docsrc'
+                includes='*.xml, *.txt, *.png, *.java, *.jpg, *.html, *.sql'/>
+    </target>
+
+    <target name='-sandwich'>
+        <basename property='base' file='${vfile}'/>
+        <loadfile srcfile='${vfile}' property='content'/>
+        <dependset>
+            <srcfilelist dir='src/org/hsqldb/sample' files='${base}'/>
+            <targetfilelist dir='docwork/${book}/cdata' files='${base}'/>
+        </dependset>
+        <if><not><available file='docwork/${book}/cdata/${base}'/></not>
+        <then>
+            <mkdir dir='docwork/${book}/cdata'/>
+            <echo file='docwork/${book}/cdata/${base}'
+                  message='&lt;![CDATA[${content}]]&gt;'/>
+        </then></if>
+    </target>
+
+    <!-- I'm not sure that <fop> actually needs the Xslt libs, but it
+         probably does.  Test this sometime.  -->
+    <target name='-initFop' unless='_fop_initted' depends='-checkXslt'>
+        <fail unless='fop.home'
+  message="To build from DocBook FO files, you must set property 'fop.home'"/>
+        <if><not><available file='${fop.home}' type='dir'/></not><then>
+            <fail message="The &lt;fop&gt; target not found where expected under '${fop.home}'"/>
+        </then></if>
+        <taskdef name="fop" classname="org.apache.fop.tools.anttasks.Fop">
+            <classpath>
+                <fileset dir='${fop.home}/build' includes='fop*.jar'/>
+                <!-- See the FOP docs for why these are needed, and where
+                     to get them from -->
+                <fileset dir='${fop.home}/lib'
+                         includes='avalon*.jar, batik*.jar, jimi*.jar'/>
+            </classpath>
+        </taskdef>
+        <property name='_fop_initted' value='true'/>
+    </target>
+
+    <target name='-initContrib' unless='_contrib_initted'>
+        <!-- We use ant-contrib-X.jar (where X is a version).  Make sure
+             that this jar is located at path-to-ant-bin/../lib -->
+        <available property='_contrib_there'
+                   classname='net.sf.antcontrib.logic.ForTask'/>
+        <fail unless='_contrib_there' message="You must put a recent cut of ant-contrib-X.jar into 'path-to-ant-bin/../lib/' (or just put the jar into your CLASSPATH before running ant)"/>
+        <taskdef resource="net/sf/antcontrib/antcontrib.properties"/>
+        <property name='_contrib_initted' value='true'/>
+    </target>
+
+    <target name='-fop' depends='-initFop'>
+        <!-- Required properties:  book, _lvl, _fmt -->
+        <fop format="${_fmt}" outdir="doc/${book}" messagelevel="${_lvl}"
+            basedir='docsrc/${book}'>
+            <fileset file='docwork/${book}/${book}.fo'/>
+        </fop>
+    </target>
+
+    <target name='-htmlXslt' depends='-checkXslt'>
+        <!-- This does not check dependencies.  Do that before calling. -->
+        <!-- Required properties:  _stylesheet, book -->
+        <fail if='_css' message="Internal property '_css' set externally"/>
+        <fail unless='docbook.xsl.home' message="To use the DocBook targets, you must set property 'docbook.xsl.home"/>
+        <if><not><available type='file' file='${_stylesheet}'/></not><then>
+            <fail message="DocBook style sheet '${_stylesheet}' not found."/>
+        </then></if>
+        <available property='_css' value='${book}.css' type='file'
+                   file='docsrc/${book}/${book}.css'/>
+        <property name='_css' value='../shared.css'/>
+        <property name='_ext' value='.html'/>
+        <style
+               basedir='docsrc/${book}'
+               destdir='doc/${book}'
+               force='yes'
+               style='${_stylesheet}'
+               includes='${book}.xml'
+               extension='${_ext}'>
+            <param name='html.stylesheet' expression='${_css}'/>
+            <param name='navig.graphics' expression='true'/>
+            <param name='navig.graphics.path' expression='navicons/'/>
+            <param name='navig.graphics.extension' expression='.gif'/>
+            <param name='chunk.section.depth' expression='0'/>
+        </style>
+    </target>
+
+    <target name='-foXslt' depends='-checkXslt'>
+        <!-- This does not check dependencies.  Do that before calling. -->
+        <!-- Required props:  book -->
+        <fail unless='docbook.xsl.home' message="To use the DocBook targets, you must set property 'docbook.xsl.home"/>
+        <if><not><available type='file' file='${style.fo}'/></not><then>
+            <fail message="DocBook style sheet '${style.fo}' not found."/>
+        </then></if>
+        <style
+               basedir='docsrc/${book}'
+               destdir='docwork/${book}'
+               force='yes'
+               style='${style.fo}'
+               includes='${book}.xml'
+               extension='.fo'
+         >
+            <param name='use.extensions' expression='1'/>
+            <param name='tablecolumns.extension' expression='0'/>
+            <param name='textinsert.extension' expression='1'/>
+            <param name='fop.extensions' expression='1'/>
+         </style>
+    </target>
+
+    <target name='clean-doc' description='Remove derived documentation files'
+            depends='clean-docwork'>
+        <!-- All CVS-controlled are in docsrc directory.
+             At that point, doc will contain only derived files, and this
+             target can just wipe out the docwork and doc directories. -->
+        <delete quiet='true' includeEmptyDirs='true'>
+            <fileset dir='doc' includes='*.gif, *.css, guide/**'/>
+        </delete>
+        <delete dir='docwork' quiet='true' includeEmptyDirs='true'/>
+    </target>
+
+    <target name='clean-docwork' description='Remove temporary documentation files'>
+        <delete dir='docwork' quiet='true' includeEmptyDirs='true'/>
+        <delete quiet='true' includeEmptyDirs='true'>
+            <fileset dir='doc' includes='**/*.xml'/>
+        </delete>
+    </target>
+</project>
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/README.maintainer
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/README.maintainer
@@ -0,0 +1,7 @@
+Steps to produce a .orig tarball from the upstream distribution zips:
+
+unzip hsqldb_1_7_3_2.zip
+rm hsqldb/lib/hsqldb.jar
+rm hsqldb/lib/servlet.jar
+tar -c -f hsqldb_1.7.3.2.orig.tar hsqldb/
+gzip --best hsqldb_1.7.3.2.orig.tar
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/bin/Makefile
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/bin/Makefile
@@ -0,0 +1,16 @@
+scripts = $(addprefix hsqldb-,databasemanager databasemanagerswing transfer querytool sqltool)
+
+all: $(scripts)
+
+hsqldb-databasemanager: class=DatabaseManager
+hsqldb-databasemanagerswing: class=DatabaseManagerSwing
+hsqldb-transfer: class=Transfer
+hsqldb-querytool: class=QueryTool
+hsqldb-sqltool: class=SqlTool
+
+$(scripts): hsqldb.in
+	sed "s/@CLASS@/$(class)/g" $< >$@
+	chmod a+x $@
+
+clean:
+	rm -f $(scripts)
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/bin/hsqldb.in
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/bin/hsqldb.in
@@ -0,0 +1,5 @@
+#! /bin/sh
+
+set -e
+
+exec java -cp $CLASSPATH:/usr/share/java/hsqldbutil.jar:/usr/share/java/hsqldb.jar:/usr/share/java/postgresql.jar:/usr/share/java/mysql.jar "org.hsqldb.util.@CLASS@" "$@"
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/bin/hsqldb.xpm
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/bin/hsqldb.xpm
@@ -0,0 +1,193 @@
+/* XPM */
+static char *dummy[]={
+"32 32 158 2",
+"Qt c #000000",
+".v c #000101",
+".C c #010102",
+".N c #1a3040",
+".D c #1a313f",
+".# c #1b3242",
+".w c #1c3444",
+".l c #1d3748",
+".c c #1d3749",
+".9 c #1e3749",
+"aB c #2d536d",
+".a c #3c7094",
+"ab c #3d7296",
+".b c #3d7297",
+"#v c #3e7296",
+"a. c #3f7397",
+"#z c #437598",
+"#D c #447699",
+"#. c #4f91bd",
+"#e c #4f91be",
+".3 c #4f92bf",
+".O c #4f93c1",
+".m c #5091bd",
+".d c #5092bf",
+".W c #5093c1",
+".E c #5094c1",
+".x c #5193c0",
+".k c #549dcf",
+".0 c #559dcf",
+"#Z c #559ecf",
+".t c #569ecf",
+"#8 c #579ecf",
+"#q c #589ed0",
+"aj c #589fcf",
+"#4 c #589fd0",
+".R c #599fd0",
+"#H c #59a0d0",
+"#r c #5a9fd0",
+"#1 c #5aa0d1",
+".B c #5ba0d1",
+"#Q c #5ba1d1",
+".u c #5ca1d1",
+"aA c #5ea2d1",
+"#0 c #5ea2d2",
+"#l c #5fa2d2",
+"ax c #60a3d1",
+"#c c #60a3d2",
+"#W c #60a4d2",
+".j c #61a3d2",
+".S c #61a4d2",
+"ah c #61a4d3",
+"#y c #62a4d2",
+"#P c #63a5d3",
+".7 c #64a5d3",
+"#m c #64a6d3",
+".M c #65a5d4",
+"#O c #65a6d3",
+"#g c #65a6d4",
+"#C c #66a6d4",
+"#S c #66a7d4",
+"#Y c #67a7d4",
+"aw c #67a7d5",
+"aa c #68a7d4",
+".6 c #68a8d4",
+".i c #68a8d5",
+"#b c #69a9d4",
+"#N c #6aa8d5",
+"#K c #6aa9d5",
+"#I c #6ba9d5",
+"at c #6ba9d6",
+"aq c #6caad6",
+"#w c #6da9d6",
+".H c #6daad6",
+".s c #6eaad6",
+"ai c #6eabd6",
+"#L c #6fabd6",
+"#k c #70acd7",
+".h c #71acd7",
+"an c #72acd8",
+"am c #72add7",
+"#6 c #72add8",
+"#o c #73add8",
+"ao c #73aed8",
+".Z c #74aed8",
+".I c #74aed9",
+"#f c #75aed8",
+".e c #76afd9",
+".X c #76b0d9",
+".4 c #77afd8",
+"## c #77b0d9",
+"a# c #78b0d9",
+".1 c #79b0da",
+".T c #79b1da",
+"#E c #7ab1da",
+"ap c #7ab2da",
+"#u c #7bb1db",
+".P c #7bb2da",
+".n c #7cb2da",
+"ak c #7cb2db",
+"ae c #7cb3db",
+"#9 c #7db3da",
+".V c #7db3db",
+".A c #7eb3db",
+"#B c #7fb4db",
+".2 c #7fb4dc",
+"#U c #80b4db",
+"#s c #80b4dc",
+"af c #82b5dc",
+"az c #82b6dd",
+".g c #83b6dd",
+"#j c #83b7dc",
+"#h c #84b7dd",
+".G c #85b7dd",
+"ar c #86b7dd",
+"#7 c #86b8dd",
+".L c #87b8de",
+"#x c #87b9de",
+".f c #88b9de",
+"#T c #89b9df",
+"#i c #89badf",
+"#G c #8abadf",
+"#5 c #8bbadf",
+"ac c #8bbbdf",
+"#p c #8cbbdf",
+"#X c #8cbbe0",
+".Q c #8dbbe0",
+".J c #8dbce0",
+"#d c #8ebce0",
+"ag c #8fbde0",
+"#M c #8fbde1",
+"#J c #90bde0",
+"#R c #90bde1",
+"au c #90bee1",
+".r c #91bde1",
+"av c #91bee1",
+"#A c #92bee1",
+".8 c #93bee1",
+"#n c #93bfe1",
+".F c #93bfe2",
+".5 c #94bfe2",
+"#2 c #94c0e2",
+"ay c #95bfe2",
+".U c #95c0e2",
+"#V c #95c0e3",
+"as c #96c0e3",
+".K c #96c1e3",
+"#a c #97c1e3",
+".Y c #98c1e3",
+"#3 c #98c2e3",
+"#t c #98c2e4",
+"al c #99c2e3",
+".z c #99c2e4",
+".o c #9ac2e4",
+".y c #9ac3e4",
+".q c #9bc3e4",
+"#F c #9cc3e4",
+"ad c #9cc4e4",
+".p c #9cc4e5",
+"QtQtQtQtQtQtQtQtQt.#.a.b.b.b.b.b.b.b.b.b.b.b.b.b.b.b.b.b.b.b.b.b",
+"QtQtQtQtQtQtQtQt.c.d.e.f.f.f.f.f.f.f.f.f.f.f.f.f.f.g.h.i.i.i.j.k",
+"QtQtQtQtQtQtQt.l.m.n.o.p.p.p.p.p.p.p.p.p.p.p.p.p.p.q.r.s.t.k.u.k",
+"QtQtQtQtQt.v.w.x.n.y.p.p.p.p.p.p.p.p.p.p.p.p.p.p.p.p.p.z.A.B.u.k",
+"QtQtQtQt.C.D.E.n.y.p.p.p.y.F.G.e.h.H.I.A.J.K.q.p.p.p.p.p.q.L.M.k",
+"QtQtQt.v.N.O.P.q.p.p.q.Q.s.R.k.k.k.k.k.k.k.S.T.U.q.p.p.p.p.p.V.k",
+"QtQtQt.w.W.X.p.p.p.Y.Z.0.k.k.k.k.k.k.k.k.k.k.k.R.1.o.p.p.p.p.2.k",
+"QtQt.l.3.4.y.p.p.5.6.k.k.k.k.k.k.k.k.k.k.k.k.k.k.0.7.8.p.p.p.2.k",
+"Qt.9#.##.z.p.p#a#b.k.k.k.k.k.k.k.k.k.k.k.k.k.k.k.k.k#c#d.p.p.2.k",
+".##e##.z.p.p.q#f.0.k.k.k.k.t#g.T#h#i#j#k#l.0.k.k.k.k.k#m#n.p.2.k",
+".a#o.z.p.p.p#p#q.k.k.k.k#r#s#t.p.p.p.p.p.F#u.u.k.k.k.k.k#k.z.2.k",
+"#v.5.p.p.p.q#w.k.k.k.k#r#x.p.p.p.p.p.p.p.p.p.Q#y.k.k.k.k#q.L.2.k",
+"#z#a.p.p.p#A.0.k.k.k.t#B.p.p.p.p.p.p.p.p.p.p.p#A.S.k.k.k.k#C.A.k",
+"#D#a.p.p.p#E.k.k.k.k.6.y.p.p.p.p.p.p.p.p.p.p.p#F#G.0.k.k.k#H#k.k",
+"#D#a.p.p.o#I.k.k.k.0.g.p.p.p.p#J#K.u#L#M.q.p.p.p.o#N.k.k.k.k#O.k",
+"#D#a.p.p#a#P.k.k.k#Q#R.p.p.p.Y#S.k.k.k.B#T.q.p.p.p#U.k.k.k.k.S.k",
+"#D#a.p.p#V.B.k.k.k#W.K.p.p.p#X.R.k.k.k.k#Y.Y.p.p.p#d#Z.k.k.k#c.k",
+"#D#a.p.p.K#0.k.k.k#0.F.p.p.p#a#Y.k.k.k.k#1.F.p.p.p#2.t.k.k.k#c.k",
+"#D#a.p.p#3#C.k.k.k#4#5.p.p.p.p#2#N.k.k.k#Q.5.p.p.p.F.t.k.k.k#c.k",
+"#D#a.p.p.q.h.k.k.k.k#6.p.p.p.p.p.z#f.0.k#I.z.p.p.p.f.0.k.k.k#c.k",
+"#D#a.p.p.p#7.k.k.k.k#8#B.p.p.p.p.p.z#9#1#5#F.p.p.q##.k.k.k.k#y.k",
+"a..K.p.p.p#t.j.k.k.k.k.Ra##a.p.p.p.p#3#o.5.p.p.p#3.S.k.k.k.taa.k",
+"abac.p.p.pad.g.t.k.k.k.k.k#Pae#G#Xaf.i.k#Yag.q.q#h.k.k.k.k.u.e.k",
+"ab#L.y.p.p.p.q#o.0.k.k.k.k.k.k.k.k.k.k.k.k.Sac.Fah.k.k.k.kai.2.k",
+"abajac.p.p.p.p.z.h.0.k.k.k.k.k.k.k.k.k.k.k.k#c.h.k.k.k.k#4#G.2.k",
+"ab.k#Y#a.p.p.p.p.zak#4.k.k.k.k.k.k.k.k.k.k#4afalam.k.k.kan.q.2.k",
+"ab.k.kao.z.p.p.p.p.q#R#k#H.k.k.k.k.k.k.t.Hag.q.p.y.P.t.j.5.p.2.k",
+"ab.k.k.tap.z.p.p.p.p.p.y#2af#oaqaqai.Pag.o.p.p.p.p.qapar.q.p.2.k",
+"ab.k.k.k#8#o#t.p.p.p.p.p.p.p.p.p.p.p.p.p.p.p.p.p.pas#Iaa.r.p.2.k",
+"ab.k.k.k.k.katau.q.p.p.p.p.p.p.p.p.p.p.p.p.p.p.qavaw.k.k#P#p.A.k",
+"abax.S.S.Sax.k.u.P.5asasasasasasasasasasasasayaz#0.k.k.k.kaA.s.k",
+"aBababababababababababababababababababababababababababababababab"};
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/changelog
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/changelog
@@ -0,0 +1,336 @@
+hsqldb1.8.0 (1.8.0.10+dfsg-9) unstable; urgency=medium
+
+  * fix override disparity
+  * declare that we support multiple ResultSets (used by LO)
+  * rm debian/watch, there will be no new upstream versions here anyway
+
+ -- Rene Engelhard <rene@debian.org>  Sat, 03 Mar 2018 21:39:02 +0100
+
+hsqldb1.8.0 (1.8.0.10+dfsg-8) unstable; urgency=medium
+
+  * remove Implementation-{Vendor,Version} from MANIFEST.MK
+    and thus make it reproducible
+
+ -- Rene Engelhard <rene@debian.org>  Wed, 16 Aug 2017 21:55:08 +0200
+
+hsqldb1.8.0 (1.8.0.10+dfsg-7) unstable; urgency=medium
+
+  * [77412fc] move Maintainer: to Debian LibreOffice Maintainers
+    (as we keep this for LO only anyway.)
+
+ -- Rene Engelhard <rene@debian.org>  Wed, 07 Sep 2016 07:41:43 +0200
+
+hsqldb1.8.0 (1.8.0.10+dfsg-6) unstable; urgency=medium
+
+  * fix servlet depends (closes: #815562) 
+
+ -- Rene Engelhard <rene@debian.org>  Mon, 22 Feb 2016 19:52:14 +0100
+
+hsqldb1.8.0 (1.8.0.10+dfsg-5) unstable; urgency=medium
+
+  * also update jh_classpath call for servlet3.1 (closes: #804022) 
+
+ -- Rene Engelhard <rene@debian.org>  Sat, 07 Nov 2015 13:43:24 +0100
+
+hsqldb1.8.0 (1.8.0.10+dfsg-4) unstable; urgency=medium
+
+  * remove last remains of -gcj package (on kfreebsd). kfreebsd
+    is supposed to use OpenJDK, too now 
+
+  * update to libservlet3.1-java (closes: #801013) 
+
+ -- Rene Engelhard <rene@debian.org>  Sat, 31 Oct 2015 17:01:57 +0100
+
+hsqldb1.8.0 (1.8.0.10+dfsg-3) unstable; urgency=low
+
+  * upload to unstable
+  * actually move to oldlibs
+  * change Maintainer to debian-openoffice@lists.debian.org as we just keep
+    this for LO 
+
+ -- Rene Engelhard <rene@debian.org>  Fri, 19 Apr 2013 00:21:57 +0200
+
+hsqldb1.8.0 (1.8.0.10+dfsg-2) experimental; urgency=low
+
+  * reupload as hsqldb1.8.0 / libhsqldb1.8.0-java to make space
+    for non-ancient libhsqldb-java
+  * stop building -doc, -server, -utils
+  * move to oldlibs 
+  * remove maven stuff, this here is just shipped for LO... 
+
+ -- Rene Engelhard <rene@debian.org>  Mon, 18 Mar 2013 23:40:35 +0100
+
+hsqldb (1.8.0.10+dfsg-1) unstable; urgency=low
+
+  * remove lib/servlet.jar and make the build actually use
+    /usr/share/java/servlet-api-2.5.jar...
+
+ -- Rene Engelhard <rene@debian.org>  Mon, 18 Mar 2013 22:30:20 +0100
+
+hsqldb (1.8.0.10-14) unstable; urgency=low
+
+  * revert -13 changes, apply fix from upstream to fix preprocessing,
+    thanks Lionel Elie Mamane 
+
+ -- Rene Engelhard <rene@debian.org>  Tue, 17 Jul 2012 21:21:27 +0200
+
+hsqldb (1.8.0.10-13) unstable; urgency=low
+
+  * explicitly build with openjdk-7 as the Java7 patch doesn't
+    seem to be working with gcj (closes: #675834). Thus ...
+  * ... disable -gcj 
+
+ -- Rene Engelhard <rene@debian.org>  Wed, 20 Jun 2012 11:45:35 +0200
+
+hsqldb (1.8.0.10-12) unstable; urgency=low
+
+  * add patch to fix build with Java 7 
+
+ -- Rene Engelhard <rene@debian.org>  Fri, 01 Jun 2012 19:41:24 +0200
+
+hsqldb (1.8.0.10-11) unstable; urgency=low
+
+  * add maven.publishedRules (patch by twerner, closes: #641691)
+  * stop building -gcj - except on kfreebsd-* 
+
+ -- Rene Engelhard <rene@debian.org>  Mon, 26 Sep 2011 16:14:57 +0000
+
+hsqldb (1.8.0.10-10) unstable; urgency=low
+
+  * fix builddep: s/default-jdk-builddep/default-jdk, gcj-native-helper/ 
+  * libhsqldb-java-gcj: libs->java 
+  * add missing run to mh_clean 
+  * build-depend on javahelper and add Class-Path: to hsqldb-1.8.0.10.jar... 
+  * stop depending on a jre on libhsqldb-java 
+
+ -- Rene Engelhard <rene@debian.org>  Fri, 19 Aug 2011 20:54:56 +0000
+
+hsqldb (1.8.0.10-9) unstable; urgency=low
+
+  * oops, readd lost changes of -6.1 and fix changelog snafu 
+
+ -- Rene Engelhard <rene@debian.org>  Mon, 21 Jun 2010 18:51:08 +0200
+
+hsqldb (1.8.0.10-8) unstable; urgency=low
+
+  * hardcode JAVA_EXECUTABLE to /usr/lib/jvm/java-gcj/bin/java
+    (closes: #579740) 
+  * add $remote_fs to Required-Stop:
+  * build with libservlet2.5-java
+
+ -- Rene Engelhard <rene@debian.org>  Mon, 21 Jun 2010 12:03:42 +0200
+
+hsqldb (1.8.0.10-6.1) unstable; urgency=low
+
+  * Non-maintainer upload.
+  * Install POM file for hsqldb.jar. (Closes: #581851)
+
+ -- Torsten Werner <twerner@debian.org>  Sun, 16 May 2010 23:08:11 +0200 
+
+hsqldb (1.8.0.10-6) unstable; urgency=low
+
+  * split utilities (hsqldb-*) into hsqldb-utils to allow
+    co-installation of libraries of different versions
+
+ -- Rene Engelhard <rene@debian.org>  Sun, 25 Oct 2009 02:19:13 +0200
+
+hsqldb (1.8.0.10-5) unstable; urgency=low
+
+  * add i104901.patch from OOo to fix autoincrement behaviour which
+    otherwise can cause db corruption 
+  * bin/hsqldb: Provides: hsqldb-server, thanks lintian 
+
+ -- Rene Engelhard <rene@debian.org>  Sat, 19 Sep 2009 00:56:41 +0200
+
+hsqldb (1.8.0.10-4) unstable; urgency=low
+
+  * fix hsqldb-init-tempfile to actually be applied
+  * readd WebServer support
+  * use template for hsqldb.conf which has more info
+  * add SERVER_JVMARGS=-Dhsqldb.method_class_names=\"\" to hsqldb.conf to
+    disallow execution of Java code inside SQL per default
+  * import default server.properties and webserver.properties and
+    default sqltool.rc from Fedora
+
+ -- Rene Engelhard <rene@debian.org>  Mon, 17 Aug 2009 22:33:02 +0200
+
+hsqldb (1.8.0.10-3) unstable; urgency=medium
+
+  * add patch from http://www.openoffice.org/issues/show_bug.cgi?id=103528
+    to fix BITXOR
+  * build with target/source for 1.5 as default-jdk is now OpenJDK 1.6
+  * remove old hsqldb-server.init. Use bin/hsqldb. Add /etc/hsqldb.conf.
+    Make it work. Finetuning probably still needed but it at least now
+    has working (re)start/stop/status.
+    (closes: #466421)
+  * move libhsqldb-java to java and hsqldb-server to databases
+  * fix doc-base section
+
+ -- Rene Engelhard <rene@debian.org>  Mon, 17 Aug 2009 21:05:08 +0200
+
+hsqldb (1.8.0.10-2) unstable; urgency=low
+
+  * fix creation of .lock file for OOo (from OOo svn)
+
+ -- Rene Engelhard <rene@debian.org>  Wed, 25 Feb 2009 13:44:50 +0100
+
+hsqldb (1.8.0.10-1) unstable; urgency=low
+
+  * New upstream release
+
+ -- Rene Engelhard <rene@debian.org>  Tue, 12 Aug 2008 10:49:33 -0300
+
+hsqldb (1.8.0.9-3) unstable; urgency=low
+
+  * make myself Maintainer: and remove Peter, by Peterss request
+  * use default-jdk-builddep (closes: #477862)
+
+ -- Rene Engelhard <rene@debian.org>  Sun, 27 Apr 2008 00:17:18 +0200
+
+hsqldb (1.8.0.9-2) unstable; urgency=low
+
+  * upload to unstable
+  * mention CVE-2007-4575 in previous release
+
+ -- Rene Engelhard <rene@debian.org>  Tue, 27 Nov 2007 11:37:11 +0100
+
+hsqldb (1.8.0.9-1) experimental; urgency=high
+
+  * New upstream release
+    - fixes CVE-2007-4575
+
+ -- Rene Engelhard <rene@debian.org>  Sun, 04 Nov 2007 19:20:16 +0100
+
+hsqldb (1.8.0.8.dfsg-2) unstable; urgency=low
+
+  * get regression fix from upstream
+  * merge from Ubuntu:
+    - build -gcj subpackage (closes: #437629)
+
+ -- Rene Engelhard <rene@debian.org>  Sun, 04 Nov 2007 19:03:03 +0100
+
+hsqldb (1.8.0.8.dfsg-1) unstable; urgency=high
+
+  * oops, we need to remove servlet.jar from the .orig 
+
+ -- Rene Engelhard <rene@debian.org>  Mon, 24 Sep 2007 10:26:49 +0200
+
+hsqldb (1.8.0.8-1) unstable; urgency=low
+
+  * New upstream release
+    - includes all Ooo 2.3 patches (closes: #437630)
+  * switch to java-gcj-compat-dev as jikes can't build us anymore but
+    ecj can
+  * add myself to Uploaders
+  * make hsqldb-server depend on libhsqldb-java (= ${binary:Version})
+    as $|Source-Version} is deprecated
+  * Apps/Databases -> Applications/Data Management for the new menu policy
+
+ -- Rene Engelhard <rene@debian.org>  Fri, 31 Aug 2007 11:30:39 +0200
+
+hsqldb (1.8.0.7-3) unstable; urgency=low
+
+  * Changed dependencies to libservlet2.4-java (closes: #422555)
+
+ -- Peter Eisentraut <petere@debian.org>  Mon, 07 May 2007 16:03:36 +0200
+
+hsqldb (1.8.0.7-2) unstable; urgency=low
+
+  * Corrected URL in hsqldb-sqltool man page
+  * Added sqltool.rc example to installation
+  * Improved start order dependencies of init script
+
+ -- Peter Eisentraut <petere@debian.org>  Fri, 13 Apr 2007 01:54:00 +0200
+
+hsqldb (1.8.0.7-1) unstable; urgency=low
+
+  * New upstream release
+  * Updated watch file
+  * Removed hsqldb-nio.patch, which is no longer needed
+
+ -- Peter Eisentraut <petere@debian.org>  Fri, 27 Oct 2006 09:59:02 +0200
+
+hsqldb (1.8.0.5-2) unstable; urgency=low
+
+  * Fixed dependency information in init script LSB header
+
+ -- Peter Eisentraut <petere@debian.org>  Wed, 13 Sep 2006 19:18:37 +0200
+
+hsqldb (1.8.0.5-1) experimental; urgency=low
+
+  * New upstream release
+  * Fixed Build-Depends vs. Build-Depends-Indep
+  * Updated standards version
+  * debian/rules simplifications facilitated by newer cdbs
+  * Removed outdated OpenOffice patches
+  * Create /var/run/hsqldb in the init script rather than in the package
+  * Changed to Debhelper level 5
+  * Fixed su invocation in init script
+
+ -- Peter Eisentraut <petere@debian.org>  Thu, 31 Aug 2006 12:57:30 +0200
+
+hsqldb (1.8.0.2-2) unstable; urgency=low
+
+  * Added hsqldbutil.jar to re-add Transfer and QueryTool tools, which
+    were removed from the main jar (closes: #341427)
+  * Do not allow tools to create prefs file automatically
+
+ -- Peter Eisentraut <petere@debian.org>  Sun, 11 Dec 2005 14:43:02 +0100
+
+hsqldb (1.8.0.2-1) unstable; urgency=low
+
+  * New upstream release
+  * Updated hsqldb-gcj-access-problems.patch for new release
+  * Changed watch file to version 3 format
+  * Added dependency on adduser
+  * Changed init script to LSB style
+  * Changed build dependency to ant
+
+ -- Peter Eisentraut <petere@debian.org>  Sat, 24 Sep 2005 23:07:44 +0200
+
+hsqldb (1.8.0.0-2) experimental; urgency=low
+
+  * Moved java-virtual-machine to a suggestion (closes: #316986)
+  * Made hsqldb-server depend on the library of the same version
+    (closes: #316987)
+  * Applied bug fix patch from OOo2 (hsqldb-ooo2.patch) (closes: #316937)
+  * Applied patch by Rene Engelhard to work with GCJ in OOo2
+    (hsqldb-gcj-access-problems.patch) (closes: #316937)
+  * Now using simple-patchsys.mk for patches
+
+ -- Peter Eisentraut <petere@debian.org>  Mon, 11 Jul 2005 22:40:39 +0200
+
+hsqldb (1.8.0.0-1) experimental; urgency=low
+
+  * New upstream release
+  * Updated standards version
+
+ -- Peter Eisentraut <petere@debian.org>  Mon,  4 Jul 2005 18:03:23 +0200
+
+hsqldb (1.7.3.3-3) unstable; urgency=low
+
+  * Changed maintainer address
+  * Added server mode
+
+ -- Peter Eisentraut <petere@debian.org>  Thu,  9 Jun 2005 16:02:21 +0200
+
+hsqldb (1.7.3.3-2) experimental; urgency=low
+
+  * Disabled use of NIO locking (doesn't work with kaffe)
+  * Changed run-time dependencies to kaffe
+  * Moved to main
+  * Added PostgreSQL and MySQL JDBC drivers to classpath of GUI applications
+  
+ -- Peter Eisentraut <peter_e@gmx.net>  Fri,  6 May 2005 13:22:03 +0200
+
+hsqldb (1.7.3.3-1) experimental; urgency=low
+
+  * New upstream release
+
+ -- Peter Eisentraut <peter_e@gmx.net>  Wed, 30 Mar 2005 10:39:03 +0200
+
+hsqldb (1.7.3.2-1) experimental; urgency=low
+
+  * Initial release (closes: #121613)
+
+ -- Peter Eisentraut <peter_e@gmx.net>  Sun,  6 Feb 2005 13:05:40 +0100
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/compat
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/compat
@@ -0,0 +1 @@
+5
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/control
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/control
@@ -0,0 +1,24 @@
+Source: hsqldb1.8.0
+Section: oldlibs
+Priority: optional
+Maintainer: Debian LibreOffice Maintainers <debian-openoffice@lists.debian.org>
+Uploaders: Rene Engelhard <rene@debian.org>
+Build-Depends: cdbs (>= 0.4.39), debhelper (>= 5), default-jdk, ant (>= 1.7), libservlet3.1-java, maven-repo-helper, javahelper
+Standards-Version: 3.7.2
+
+Package: libhsqldb1.8.0-java
+Architecture: all
+Depends: libservlet3.1-java, ${misc:Depends}
+Suggests: java-virtual-machine, libhsqldb1.8.0-java-gcj
+Conflicts: openoffice.org-base (<< 1:2.3.1~m8)
+Description: Java SQL database engine
+ HSQLDB is an SQL relational database engine written in Java.  It has a
+ JDBC driver and supports a rich subset of SQL-92 (BNF tree format) plus
+ SQL:1999 and SQL:2003 enhancements.  It offers a small, fast database
+ engine that offers both in-memory and disk-based tables.  Embedded and
+ server modes are available.  Additionally, it includes tools such as a
+ minimal web server, in-memory query and management tools (can be run as
+ applets), and a number of demonstration examples.
+ .
+ Web site: http://hsqldb.org/
+
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/copyright
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/copyright
@@ -0,0 +1,72 @@
+This Debian package was created by Peter Eisentraut <peter_e@gmx.net>
+on 5 Feb 2005.
+
+The source was downloaded from <http://hsqldb.sourceforge.net/>.  The
+hsqldb.xpm icon was created by Peter Eisentraut from the file logo.gif
+available in the HSQLDB CVS repository.
+
+Upstream authors: Fred Toussi <fredt@users.sourceforge.net> and others
+
+Copyright:
+
+  Copyright (c) 2001-2004, The HSQL Development Group
+  All rights reserved.
+
+  Redistribution and use in source and binary forms, with or without
+  modification, are permitted provided that the following conditions are met:
+
+  Redistributions of source code must retain the above copyright notice, this
+  list of conditions and the following disclaimer.
+
+  Redistributions in binary form must reproduce the above copyright notice,
+  this list of conditions and the following disclaimer in the documentation
+  and/or other materials provided with the distribution.
+
+  Neither the name of the HSQL Development Group nor the names of its
+  contributors may be used to endorse or promote products derived from this
+  software without specific prior written permission.
+
+  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+  AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+  IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+  ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
+  OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
+  EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
+  PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
+  LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+  (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
+  SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+
+
+  Copyright (c) 1995-2000, The Hypersonic SQL Group.
+  All rights reserved.
+
+  Redistribution and use in source and binary forms, with or without
+  modification, are permitted provided that the following conditions are met:
+
+  Redistributions of source code must retain the above copyright notice, this
+  list of conditions and the following disclaimer.
+
+  Redistributions in binary form must reproduce the above copyright notice,
+  this list of conditions and the following disclaimer in the documentation
+  and/or other materials provided with the distribution.
+
+  Neither the name of the Hypersonic SQL Group nor the names of its
+  contributors may be used to endorse or promote products derived from this
+  software without specific prior written permission.
+
+  THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+  AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+  IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+  ARE DISCLAIMED. IN NO EVENT SHALL THE HYPERSONIC SQL GROUP,
+  OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
+  EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
+  PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
+  LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
+  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
+  (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
+  SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+
+  This software consists of voluntary contributions made by many individuals
+  on behalf of the Hypersonic SQL Group.
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/etc/server.properties
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/etc/server.properties
@@ -0,0 +1,21 @@
+# Hsqldb Server cfg file.
+# See the Advanced Topics chapter of the Hsqldb User Guide.
+
+server.database.0   file:data/db0
+server.dbname.0     firstdb
+server.urlid.0      db0-url
+server.silent       true
+server.trace        false
+
+server.port         9001
+server.no_system_exit         true
+
+# Until the following setting is changed, the HSQLDB service will not accept
+# remote connections. Failing to set a value for server.address at all will
+# result in the service binding itself to 0.0.0.0 and accepting remote
+# connections.
+#
+# IT IS STRONGLY ADVISED that before doing this you alter the password of
+# the default account (username "sa"). By default, no password is required
+# to connect to HSQLDB with the "sa" account.
+server.address      localhost
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/etc/sqltool.rc
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/etc/sqltool.rc
@@ -0,0 +1,97 @@
+# $Id: hsqldb-1.73.0-standard-sqltool.rc,v 1.1 2004/12/23 22:21:08 fnasser Exp $
+# This is a sample SqlTool configuration file, a.k.a. rc file.
+
+# You can run SqlTool right now by copying this file to your home directory
+# and running
+#    java -jar /path/to/hsqldb.jar mem
+# This will access the first urlid definition below in order to use a
+# personal Memory-Only database.
+
+# If you have the least concerns about security, then secure access to
+# your sqltool.rc file.
+# See the documentation for SqlTool for various ways to use this file.
+
+# A personal Memory-Only database.
+urlid mem
+url jdbc:hsqldb:mem:memdbid
+username sa
+password
+
+# This is for a hsqldb Server running with default settings on your local
+# computer (and for which you have not changed the password for "sa").
+urlid db0-url
+url jdbc:hsqldb:hsql://localhost/firstdb
+username sa
+password
+
+
+###########################################################################
+# Template for a urlid for an Oracle database.
+# You will need to put the oracle.jdbc.OracleDriver class into your
+# classpath.
+# In the great majority of cases, you want to use the file classes12.zip
+# (which you can get from the directory $ORACLE_HOME/jdbc/lib of any
+# Oracle installation compatible with your server).
+# Since you need to add to the classpath, you can't invoke SqlTool with
+# the jar switch, like "java -jar .../hsqldb.jar..." or
+# "java -jar .../hsqlsqltool.jar...".
+# Put both the HSQLDB jar and classes12.zip in your classpath (and export!)
+# and run something like "java org.hsqldb.util.SqlTool...".
+
+#urlid cardiff2
+#url jdbc:oracle:thin:@aegir.admc.com:1522:TRAFFIC_SID
+#username blaine
+#password secretpassword
+#driver oracle.jdbc.OracleDriver
+###########################################################################
+
+
+###########################################################################
+# Template for a urlid for a Postgresql database.
+# You will need to put the org.postgresql.Driver class into your
+# classpath.
+# The postgresql jar will be named postgresql.jar (if you built Postgresql
+# from source), or something like pg73b1jdbc3.jar or jdbc7.2x-1.2.jar.
+# You can obtain it from a client or server Postgresql installation, or
+# download it from http://jdbc.postgresql.org/download.html.
+# Notice that the jar file names (other than "postgresql.jar") contain both
+# the target Postgresql server version and the client-side JDBC level (which
+# is determined by your client-side Java version, as explained at
+# http://jdbc.postgresql.org/download.html).
+# I recommend the latest production version for your JDBC version.  The
+# later JDBC drivers work better even with older Postgresql servers.
+# (E.g. \dt won't list owners with an older driver).
+# N.b.: Suse Linux 9.1 users should download a new driver from the PG site,
+# since Suse distributes the 7.3 drivers with Postgresql 7.4 (why???).
+# Since you need to add to the classpath, you can't invoke SqlTool with
+# the jar switch, like "java -jar .../hsqldb.jar..." or
+# "java -jar .../hsqlsqltool.jar...".
+# Put both the HSQLDB jar and the Postgresql jar in your classpath (and
+# export!) and run something like "java org.hsqldb.util.SqlTool...".
+# N.b.:  I notice that Postgresql is unusual in that it does not do an
+# implicit commit before DDL commands.  If you get an error message
+# "... cannot run inside a transaction block", just run "commit;" and retry.
+
+#urlid commerce
+#url jdbc:postgresql://dbsvr2/commercedb
+#username blaine
+#password obscured
+#driver org.postgresql.Driver
+###########################################################################
+
+
+###########################################################################
+# Template for a TLS-encrypted HSQLDB Server.
+# Remember that the hostname in hsqls (and https) JDBC URLs must match the
+# CN of the server certificate (the port and instance alias that follows
+# are not part of the certificate at all).
+# You only need to set "truststore" if the server cert is not approved by
+# your system default truststore (which a commercial certificate probably
+# would be).
+
+#urlid tls
+#url jdbc:hsqldb:hsqls://db.admc.com:9001/lm2
+#username blaine
+#password asecret
+#truststore /home/blaine/ca/db/db-trust.store
+###########################################################################
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/etc/webserver.properties
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/etc/webserver.properties
@@ -0,0 +1,13 @@
+# Hsqldb Server cfg file.
+# See the Advanced Topics chapter of the Hsqldb User Guide.
+
+server.database.0   file:data/db0
+server.dbname.0     firstdb
+server.urlid.0      db0-url
+server.silent       true
+server.trace        false
+
+server.port         80
+server.default_page index.html
+server.root             ./
+.html=text/html
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb-server.default
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb-server.default
@@ -0,0 +1,5 @@
+# Set to 'WebServer' to start a HSQLDB WebServer instead of a Server.
+# Defaults to 'Server'.
+TARGET_CLASS=Server
+#TARGET_CLASS=WebServer
+
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb-server.dirs
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb-server.dirs
@@ -0,0 +1 @@
+var/lib/hsqldb
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb-server.docs
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb-server.docs
@@ -0,0 +1 @@
+NEWS
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb-server.install
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb-server.install
@@ -0,0 +1,3 @@
+debian/etc/server.properties etc/hsqldb
+debian/etc/webserver.properties etc/hsqldb
+debian/etc/sqltool.rc etc/hsqldb
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb-server.links
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb-server.links
@@ -0,0 +1,2 @@
+etc/hsqldb/server.properties var/lib/hsqldb/server.properties
+etc/hsqldb/webserver.properties var/lib/hsqldb/webserver.properties
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb-server.postinst
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb-server.postinst
@@ -0,0 +1,11 @@
+#!/bin/sh
+
+set -e
+
+getent passwd hsqldb >/dev/null 2>&1 ||
+	adduser --system --shell /bin/bash --no-create-home --home /var/lib/hsqldb --group --gecos "HSQLDB system user" hsqldb
+
+chown hsqldb:hsqldb /var/lib/hsqldb
+chmod 600 /etc/hsqldb/sqltool.rc
+
+#DEBHELPER#
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb-utils.examples
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb-utils.examples
@@ -0,0 +1 @@
+src/org/hsqldb/sample/sqltool.rc
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb-utils.manpages
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb-utils.manpages
@@ -0,0 +1,5 @@
+debian/man/hsqldb-databasemanager.1
+debian/man/hsqldb-databasemanagerswing.1
+debian/man/hsqldb-querytool.1
+debian/man/hsqldb-sqltool.1
+debian/man/hsqldb-transfer.1
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb-utils.menu
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb-utils.menu
@@ -0,0 +1,31 @@
+?package(hsqldb-utils):\
+	needs="X11"\
+	section="Applications/Data Management"\
+	title="HSQLDB Database Manager"\
+	command="/usr/bin/hsqldb-databasemanager"\
+	icon="/usr/share/pixmaps/hsqldb.xpm"\
+	hints="HSQLDB"
+
+?package(hsqldb-utils):\
+	needs="X11"\
+	section="Applications/Data Management"\
+	title="HSQLDB Database Manager (Swing)"\
+	command="/usr/bin/hsqldb-databasemanagerswing"\
+	icon="/usr/share/pixmaps/hsqldb.xpm"\
+	hints="HSQLDB"
+
+?package(hsqldb-utils):\
+	needs="X11"\
+	section="Applications/Data Management"\
+	title="HSQLDB Query Tool"\
+	command="/usr/bin/hsqldb-querytool"\
+	icon="/usr/share/pixmaps/hsqldb.xpm"\
+	hints="HSQLDB"
+
+?package(hsqldb-utils):\
+	needs="X11"\
+	section="Applications/Data Management"\
+	title="HSQLDB Transfer Tool"\
+	command="/usr/bin/hsqldb-transfer"\
+	icon="/usr/share/pixmaps/hsqldb.xpm"\
+	hints="HSQLDB"
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/hsqldb.conf
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/hsqldb.conf
@@ -0,0 +1,140 @@
+# $Id: sample-hsqldb.cfg,v 1.16 2005/07/24 18:33:13 unsaved Exp $
+
+# Sample configuration file for HSQLDB database server.
+# See the "UNIX Quick Start" chapter of the Hsqldb User Guide.
+
+# N.b.!!!!  You must place this in the right location for your type of UNIX.
+# See the init script "hsqldb" to see where this must be placed and
+# what it should be renamed to.
+
+# This file is "sourced" by a Bourne shell, so use Bourne shell syntax.
+
+# This file WILL NOT WORK until you set (at least) the non-commented
+# variables to the appropriate values for your system.
+# Life will be easier if you avoid all filepaths with spaces or any other
+# funny characters.  Don't ask for support if you ignore this advice.
+
+# Thanks to Meikel Bisping for his contributions.  -- Blaine
+
+JAVA_EXECUTABLE=/usr/bin/java
+
+# Unless you copied a hsqldb.jar file from another system, this typically
+# resides at $HSQLDB_HOME/lib/hsqldb.jar, where $HSQLDB_HOME is your HSQLDB
+# software base directory.
+HSQLDB_JAR_PATH=/usr/share/java/hsqldb.jar
+
+# Where the file "server.properties" resides.
+SERVER_HOME=/var/lib/hsqldb
+
+# What UNIX user the server will run as.
+# (The shutdown client is always run as root or the invoker of the init script).# Runs as root by default, but you should take the time to set database file
+# ownerships to another user and set that user name here.
+HSQLDB_OWNER=hsqldb
+
+# The HSQLDB jar file specified in HSQLDB_JAR_PATH above will automatically
+# be in the class path.  This arg specifies additional classpath elements.
+# To embed your own application, add your jar file(s) or class base
+# directories here, and add your main class to the INVOC_ADDL_ARGS setting
+# below.
+#SERVER_ADDL_CLASSPATH=/usr/local/dist/currencybank.jar
+
+# We require all Server/WebServer instances to be accessible within
+# $MAX_START_SECS from when the Server/WebServer is started.
+# Defaults to 60.
+# Raise this is you are running lots of DB instances or have a slow server.
+#MAX_START_SECS=200
+# Time to allow for JVM to die after all HSQLDB instances stopped.
+# Defaults to 1.
+#MAX_TERMINATE_SECS=0
+
+# These are "urlid" values from a SqlTool authentication file
+# ** IN ADDITION TO THOSE IN YOUR server.properties OR webserver.properties **
+# file.  All server.urlid.X values from your properties file will automatically
+# be started/stopped/tested.  $SHUTDOWN_URLIDS is for additional urlids which
+# will stopped.  (Therefore, most users will not set this at all).
+# Separate multiple values with white space.  NO OTHER SPECIAL CHARACTERS!
+# Make sure to quote the entire value if it contains white space separator(s).
+# Defaults to none (i.e., only urlids set in properties file will be stopped).
+#SHUTDOWN_URLIDS='sa mygms'
+
+# SqlTool authentication file used only for shutdown.
+# The default value will be sqltool.rc in root's home directory, since it is
+# root who runs the init script.
+# (See the SqlTool chapter of the HSQLDB User Guide if you don't understand
+# this).
+AUTH_FILE=/etc/hsqldb/sqltool.rc
+
+# Set this to either 'WebServer' or 'Server'.  Defaults to Server.
+# The JVM that is started can invoke many classes (see the following item
+# about that), but this is the Server that is used (1) to check status,
+# (2) to shut down the JVM, (3) to get urlids for #1 from the
+# server's server/webserver.properties file.
+#TARGET_CLASS=WebServer
+# Note that you don't specify the org.hsqldb package, since you have no
+# choice in the matter (you can only run org.hsqldb.Server or
+# org.hsqldb.WebServer).  If you specify additional classes with
+# INVOC_ADDL_ARGS (described next), you do need to specify the
+# full class name with package name.
+
+# This is where you specify exactly what your HSQLDB JVM will run.
+# The class org.hsqldb.util.MainInvoker will run the TARGET_CLASS
+# specified above with any arguments supplied here + any other classes
+# and arguments.  Every additional class (in addition to the TARGET_CLASS)
+# must be preceded with an empty string, so that MainInvoker will know
+# you are giving a class name.  MainInvoker will invoke the normal
+# static main(String[]) method of each such class.
+# By default, MainInvoker will just run TARGET_CLASS with no args.
+# Example that runs just the TARGET_CLASS with the specified arguments:
+#INVOC_ADDL_ARGS='-silent false'
+# Example that runs the TARGET_CLASS plus a WebServer:
+#INVOC_ADDL_ARGS='"" org.hsqldb.WebServer'
+# Note the empty string preceding the class name.
+# Example that starts TARGET_CLASS with an argument + a WebServer +
+# your own application with its args (i.e., the HSQLDB Servers are
+# "embedded" in your application).  (Set SERVER_ADDL_CLASSPATH too).:
+#INVOC_ADDL_ARGS='-silent false "" org.hsqldb.WebServer "" com.acme.Stone --env prod localhost'
+# Example to run a non-TLS server in same JVM with a TLS server.  In this
+# case, TARGET_CLASS is Server which will run in TLS mode by virtue of
+# setting TLS_KEYSTORE and TLS_PASSWORD above.  The "additional" Server
+# here overrides the 'tls' and 'port' settings:
+#INVOC_ADDL_ARGS="'' org.hsqldb.Server -port 9002 -tls false"
+# Note that you use nested quotes to group arguments and to specify the
+# empty-string delimiter.
+
+# For TLS encryption for your Server, set these two variables.
+# N.b.:  If you set these, then make this file unreadable to non-root users!!!!
+# See the TLS chapter of the HSQLDB User Guide, paying attention to the
+# security warning(s).
+# If you are running with a private server cert, then you will also need to
+# set "truststore" in the your SqlTool config file (location is set by the
+# AUTH_FILE variable in this file, or it must be at the default location for
+# HSQLDB_OWNER).
+#TLS_KEYSTORE=/path/to/jks/server.store
+#TLS_PASSWORD=password
+
+# Any JVM args for the invocation of the JDBC client used to verify DB
+# instances and to shut them down (SqlToolSprayer).
+# This example specifies the location of a private trust store for TLS
+# encryption.
+# For multiple args, put quotes around entire value.
+#CLIENT_JVMARGS=-Djavax.net.debug=ssl
+
+# Any JVM args for the server.
+# For multiple args, put quotes around entire value.
+#
+# N.B.!
+# The default value of SERVER_JVMARGS sets the system property
+# hsqldb.method_class_names to be empty. This is in order to lessen the
+# security risk posed by HSQLDB allowing Java method calls in SQL statements.
+# The implications of changing this value (as explained by the authors of
+# HSQLDB) are as follows:
+#     If [it] is not set, then static methods of all available Java classes
+#     can be accessed as functions in HSQLDB. If the property is set, then
+#     only the list of semicolon seperated method names becomes accessible.
+#     An empty property value means no class is accessible.
+# Regardless of the value of hsqldb.method_class_names, methods in
+# org.hsqldb.Library will be accessible.
+# Before making changes to the value below, please be advised of the possible
+# dangers involved in allowing SQL queries to contain Java method calls.
+SERVER_JVMARGS=-Dhsqldb.method_class_names=\"\"
+
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/libhsqldb-java-doc.doc-base
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/libhsqldb-java-doc.doc-base
@@ -0,0 +1,15 @@
+Document: hsqldb-guide
+Title: Hsqldb User Guide
+Author: The HSQLDB Development Group
+Abstract: HSQLDB is an SQL relational database engine written in Java.  It has a
+ JDBC driver and supports a rich subset of SQL-92 (BNF tree format) plus
+ SQL:1999 and SQL:2003 enhancements.  It offers a small, fast database
+ engine that offers both in-memory and disk-based tables.  Embedded and
+ server modes are available.  Additionally, it includes tools such as a
+ minimal web server, in-memory query and management tools (can be run as
+ applets), and a number of demonstration examples.
+Section: Data Management
+
+Format: HTML
+Index: /usr/share/doc/libhsqldb-java-doc/guide/index.html
+Files: /usr/share/doc/libhsqldb-java-doc/guide/*.html
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/libhsqldb-java-doc.docs
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/libhsqldb-java-doc.docs
@@ -0,0 +1,4 @@
+NEWS
+doc/guide/
+doc/src/
+doc/databaseinjar.txt
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/libhsqldb-java-doc.examples
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/libhsqldb-java-doc.examples
@@ -0,0 +1,4 @@
+demo/localhost_clientserver.html
+demo/memorydbmanager.html
+demo/memoryquery.html
+demo/servletdemo.html
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/libhsqldb-java-doc.links
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/libhsqldb-java-doc.links
@@ -0,0 +1 @@
+usr/share/java/hsqldb.jar usr/share/doc/libhsqldb-java-doc/examples/hsqldb.jar
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/libhsqldb-java.docs
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/libhsqldb-java.docs
@@ -0,0 +1 @@
+NEWS
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/man/hsqldb-databasemanager.1
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/man/hsqldb-databasemanager.1
@@ -0,0 +1,35 @@
+.TH HSQLDB-DATABASEMANAGER "1" "March 2005" "HSQLDB 1.7.3.3"
+.SH NAME
+hsqldb-databasemanager \- GUI database management tool
+.SH SYNOPSIS
+\fBhsqldb-databasemanager\fR [\fIoptions\fR]
+.SH DESCRIPTION
+\fBhsqldb-databasemanager\fR is a GUI tool to manage databases via
+their JDBC interface.
+.SH OPTIONS
+.TP
+\fB\-driver\fR \fIclassname\fR
+JDBC driver class to use
+.TP
+\fB\-url\fR \fIurl\fR
+JDBC URL to connect to
+.TP
+\fB\-user\fR \fIname\fR
+user name used for connection
+.TP
+\fB\-password\fR \fIpassword\fR
+password for this user
+.TP
+\fB\-dir\fR \fIpath\fR
+default directory
+.TP
+\fB\-script\fR \fIfile\fR
+reads from script file
+.TP
+\fB\-noexit\fR
+do not call system.exit()
+.TP
+\fB\-?\fR
+show a brief help
+.SH AUTHOR
+This manual page was written by Peter Eisentraut for the Debian project.
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/man/hsqldb-databasemanagerswing.1
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/man/hsqldb-databasemanagerswing.1
@@ -0,0 +1,35 @@
+.TH HSQLDB-DATABASEMANAGERSWING "1" "March 2005" "HSQLDB 1.7.3.3"
+.SH NAME
+hsqldb-databasemanagerswing \- GUI database management tool
+.SH SYNOPSIS
+\fBhsqldb-databasemanagerswing\fR [\fIoptions\fR]
+.SH DESCRIPTION
+\fBhsqldb-databasemanagerswing\fR is a GUI tool to manage databases via
+their JDBC interface.
+.SH OPTIONS
+.TP
+\fB\-driver\fR \fIclassname\fR
+JDBC driver class to use
+.TP
+\fB\-url\fR \fIurl\fR
+JDBC URL to connect to
+.TP
+\fB\-user\fR \fIname\fR
+user name used for connection
+.TP
+\fB\-password\fR \fIpassword\fR
+password for this user
+.TP
+\fB\-dir\fR \fIpath\fR
+default directory
+.TP
+\fB\-script\fR \fIfile\fR
+reads from script file
+.TP
+\fB\-noexit\fR
+do not call system.exit()
+.TP
+\fB\-?\fR
+show a brief help
+.SH AUTHOR
+This manual page was written by Peter Eisentraut for the Debian project.
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/man/hsqldb-querytool.1
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/man/hsqldb-querytool.1
@@ -0,0 +1,34 @@
+.TH HSQLDB-QUERYTOOL "1" "March 2005" "HSQLDB 1.7.3.3"
+.SH NAME
+hsqldb-querytool \- GUI database management tool
+.SH SYNOPSIS
+\fBhsqldb-querytool\fR [\fIoptions\fR]
+.SH DESCRIPTION
+\fBhsqldb-querytool\fR is a GUI tool to issue SQL statements via JDBC.
+.SH OPTIONS
+.TP
+\fB\-driver\fR \fIclassname\fR
+JDBC driver class to use
+.TP
+\fB\-url\fR \fIname\fR
+first part of the JDBC URL to connect to
+.TP
+\fB\-database\fR \fIname\fR
+second part of the JDBC URL to connect to
+.TP
+\fB\-user\fR \fIname\fR
+user name used for connection
+.TP
+\fB\-password\fR \fIpassword\fR
+password for this user
+.TP
+\fB\-test\fR [\fBtrue\fR|\fBfalse\fR]
+insert test data
+.TP
+\fB\-log\fR [\fBtrue\fR|\fBfalse\fR]
+write log to system out
+.TP
+\fB\-?\fR
+show a brief help
+.SH AUTHOR
+This manual page was written by Peter Eisentraut for the Debian project.
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/man/hsqldb-sqltool.1
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/man/hsqldb-sqltool.1
@@ -0,0 +1,20 @@
+.TH HSQLDB-SQLTOOL "1" "April 2007" "HSQLDB 1.8.0.7"
+.SH NAME
+hsqldb-sqltool \- JDBC database console frontend
+.SH SYNOPSIS
+\fBhsqldb-sqltool\fR [\fIoptions\fR]
+.SH DESCRIPTION
+The main purpose of \fBhsqldb-sqltool\fR is to read your SQL text file
+or stdin, and execute the SQL commands therein against a JDBC database.
+There are also a great number of features to facilitate both interactive
+use (such as command-line editing and aliases) and automation (such as
+scripting variables and SQL transaction control and error handling).
+.P
+Please see the documentation at
+.I /usr/share/doc/libhsqldb-java-doc/guide/ch08.html
+for more information.
+.SH OPTIONS
+\fB\-\-help\fR
+show a brief help
+.SH AUTHOR
+This manual page was written by Peter Eisentraut for the Debian project.
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/man/hsqldb-transfer.1
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/man/hsqldb-transfer.1
@@ -0,0 +1,10 @@
+.TH HSQLDB-TRANSFER "1" "March 2005" "HSQLDB 1.7.3.3"
+.SH NAME
+hsqldb-transfer \- transfers data from one JDBC database to another
+.SH SYNOPSIS
+\fBhsqldb-transfer\fR
+.SH DESCRIPTION
+\fBhsqldb-querytool\fR is a GUI tool to manage transferring data from
+one JDBC database to another.
+.SH AUTHOR
+This manual page was written by Peter Eisentraut for the Debian project.
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/bitxor2.diff
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/bitxor2.diff
@@ -0,0 +1,15 @@
+# This patch file was generated by NetBeans IDE
+# This patch can be applied using context Tools: Apply Diff Patch action on respective folder.
+# It uses platform neutral UTF-8 encoding.
+# Above lines and this line are ignored by the patching process.
+--- hsqldb/src/org/hsqldb/Library.java
++++ hsqldb/src/org/hsqldb/Library.java
+@@ -1957,7 +1957,7 @@
+         functionMap.put("bitand", bitand);
+         functionMap.put("bitlength", bitLength);
+         functionMap.put("bitor", bitor);
+-        functionMap.put("bitxor", bitor);
++        functionMap.put("bitxor", bitxor);
+         functionMap.put("character", character);
+         functionMap.put("concat", concat);
+         functionMap.put("cot", cot);
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/fix-lock.patch
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/fix-lock.patch
@@ -0,0 +1,10 @@
+--- hsqldb/src/org/hsqldb/persist/HsqlDatabaseProperties.java	2008-03-17 17:05:41.000000000 +0100
++++ hsqldb/src/org/hsqldb/persist/HsqlDatabaseProperties.java	2009-01-21 13:09:24.493470142 +0100
+@@ -429,6 +429,7 @@
+             setProperty(hsqldb_log_size, 10);
+             setProperty(sql_enforce_strict_size, true);
+             setProperty(hsqldb_nio_data_file, false);
++			setProperty(hsqldb_lock_file, true);
+         }
+ 
+         // OOo end
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/hsqldb-demos.patch
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/hsqldb-demos.patch
@@ -0,0 +1,45 @@
+# Adjust the path to the hsqldb.jar file for the demo applications.
+--- hsqldb-1.8.0.0.orig/demo/localhost_clientserver.html
++++ hsqldb-1.8.0.0/demo/localhost_clientserver.html
+@@ -2,7 +2,7 @@
+ <head><title>HSQL Database Engine</title></head>
+ <body bgcolor=#FFFFFF>
+ <h2>HSQL Database Engine Client/Server Demo</h2>
+-<applet code="org.hsqldb.util.QueryTool" archive="hsqldb.jar" width="460" height="400" codebase="../lib/">
++<applet code="org.hsqldb.util.QueryTool" archive="hsqldb.jar" width="460" height="400" codebase=".">
+ <param name="database" value="http://localhost">
+ </applet>
+ 
+--- hsqldb-1.8.0.0.orig/demo/memorydbmanager.html
++++ hsqldb-1.8.0.0/demo/memorydbmanager.html
+@@ -2,7 +2,7 @@
+ <head><title>HSQL Database Engine</title></head>
+ <body bgcolor=#FFFFFF>
+ <h2>In-Memory Applet: Database Manager</h2>
+-<applet code="org.hsqldb.util.DatabaseManager" archive="hsqldb.jar" width="0" height="0" codebase="../lib/">
++<applet code="org.hsqldb.util.DatabaseManager" archive="hsqldb.jar" width="0" height="0" codebase=".">
+ <param name="database" value=".">
+ </applet>
+ <p>
+--- hsqldb-1.8.0.0.orig/demo/memoryquery.html
++++ hsqldb-1.8.0.0/demo/memoryquery.html
+@@ -2,7 +2,7 @@
+ <head><title>HSQL Database Engine</title></head>
+ <body bgcolor=#FFFFFF>
+ <h2>In-Memory Applet: QueryTool</h2>
+-<applet code="org.hsqldb.util.QueryTool" archive="hsqldb.jar" width="460" height="400" codebase="../lib/">
++<applet code="org.hsqldb.util.QueryTool" archive="hsqldb.jar" width="460" height="400" codebase=".">
+ <param name="database" value=".">
+ </applet>
+ <p>
+--- hsqldb-1.8.0.0.orig/demo/servletdemo.html
++++ hsqldb-1.8.0.0/demo/servletdemo.html
+@@ -2,7 +2,7 @@
+ <head><title>HSQL Database Engine</title></head>
+ <body bgcolor=#FFFFFF>
+ <h2>HSQL Database Engine Servlet Demo</h2>
+-<applet code="org.hsqldb.util.QueryTool" archive="hsqldb.jar" width="460" height="400" codebase="../lib/">
++<applet code="org.hsqldb.util.QueryTool" archive="hsqldb.jar" width="460" height="400" codebase=".">
+ <param name="database" value="http://localhost:8080/examples/servlet/hsqlServlet">
+ </applet>
+ <p>
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/hsqldb-init-provides.diff
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/hsqldb-init-provides.diff
@@ -0,0 +1,11 @@
+--- bin/hsqldb-old	2009-09-19 00:53:21.000000000 +0200
++++ bin/hsqldb	2009-09-19 00:53:40.000000000 +0200
+@@ -47,7 +47,7 @@
+ # config: /etc/sysconfig/hsqldb
+ 
+ ### BEGIN INIT INFO
+-# Provides:          HSQLDB-Server
++# Provides:          hsqldb-server
+ # Required-Start:    $syslog $remote_fs $network $named
+ # Required-Stop:
+ # Default-Start:     3 5
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/hsqldb-init-restart.diff
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/hsqldb-init-restart.diff
@@ -0,0 +1,17 @@
+--- hsqldb-1.8.0.10/bin/hsqldb-old	2009-08-17 21:03:33.000000000 +0200
++++ hsqldb-1.8.0.10/bin/hsqldb	2009-08-17 21:04:14.000000000 +0200
+@@ -461,11 +461,11 @@
+         echo "Successful shutdown ${SHUTDOWN_OPTION} (for the $TARGET_CLASS process)!"
+         exit 0
+     ;;
+-    restart|restartcompacted)
++    restart|restartcompacted|force-reload)
+         STOP_COMMAND=stop
+         [ "$COMMAND" = restartcompacted ] && STOP_COMMAND=stopcompact
+-        "${INVOC_PATH}"hsqldb $STOP_COMMAND || exit $?
+-        exec "${INVOC_PATH}"/hsqldb start
++        $0 $STOP_COMMAND || exit $?
++        $0 start
+     ;;
+     *)
+         echo "$SYNTAX_MSG" 1>&2
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/hsqldb-init-tempfile.diff
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/hsqldb-init-tempfile.diff
@@ -0,0 +1,11 @@
+--- hsqldb-1.8.0.10.orig/bin/hsqldb
++++ hsqldb-1.8.0.10/bin/hsqldb
+@@ -110,7 +110,7 @@
+ SU_ECHO_SECS=1
+ # File used as semaphore.  If file is removed, a running pid checker
+ # process will exit.
+-PIDCHECKER_FLAGFILE=/tmp/pidchecker.run
++PIDCHECKER_FLAGFILE=`mktemp /tmp/hsqldb.XXXXXXXX`
+ # The following settings get overridden by optional setting in the config file.
+ # Time to allow for JVM to die after all HSQLDB instances stopped.
+ MAX_TERMINATE_SECS=1
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/hsqldb-prefs-file.patch
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/hsqldb-prefs-file.patch
@@ -0,0 +1,12 @@
+diff -Nur hsqldb-1.8.0.2/src/org/hsqldb/util/ConnectionDialogCommon.java hsqldb-1.8.0.2.new/src/org/hsqldb/util/ConnectionDialogCommon.java
+--- hsqldb-1.8.0.2/src/org/hsqldb/util/ConnectionDialogCommon.java	2005-12-11 14:47:11.000000000 +0100
++++ hsqldb-1.8.0.2.new/src/org/hsqldb/util/ConnectionDialogCommon.java	2005-12-11 14:47:25.000000000 +0100
+@@ -178,7 +178,7 @@
+                 recentSettings = new File(homedir, fileName);
+ 
+                 if (!recentSettings.exists()) {
+-                    JavaSystem.createNewFile(recentSettings);
++//                    JavaSystem.createNewFile(recentSettings);
+ 
+                     // Changed back to what I recived from you
+ //                  recentSettings.createNewFile();
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/i104901.patch
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/i104901.patch
@@ -0,0 +1,27 @@
+--- hsqldb/src/org/hsqldb/Table.java	2007-10-19 23:59:07.000000000 +0200
++++ hsqldb/src/org/hsqldb/Table.java	2009-09-11 13:45:42.939231519 +0200
+@@ -149,10 +149,10 @@
+     Constraint[]      constraintList;                 // constrainst for the table
+     HsqlArrayList[]   triggerLists;                   // array of trigger lists
+     private int[]     colTypes;                       // fredt - types of columns
+-    private int[]     colSizes;                       // fredt - copy of SIZE values for columns
++    int[]     	      colSizes;                       // fredt - copy of SIZE values for columns
+     private int[]     colScales;                      // fredt - copy of SCALE values for columns
+     private boolean[] colNullable;                    // fredt - modified copy of isNullable() values
+-    private Expression[] colDefaults;                 // fredt - expressions of DEFAULT values
++    Expression[] 	  colDefaults;                 // fredt - expressions of DEFAULT values
+     private int[]        defaultColumnMap;            // fred - holding 0,1,2,3,...
+     private boolean      hasDefaultValues;            //fredt - shortcut for above
+     boolean              sqlEnforceSize;              // inherited from the database -
+--- hsqldb/src/org/hsqldb/TableWorks.java	2007-01-14 06:48:16.000000000 +0100
++++ hsqldb/src/org/hsqldb/TableWorks.java	2009-09-11 13:47:50.328667463 +0200
+@@ -670,7 +670,8 @@
+             // default expressions can change
+             oldCol.setType(newCol);
+             oldCol.setDefaultExpression(newCol.getDefaultExpression());
+-            table.setColumnTypeVars(colIndex);
++			table.colSizes[colIndex]    = oldCol.getSize();
++            table.colDefaults[colIndex] = oldCol.getDefaultExpression();
+             table.resetDefaultsFlag();
+ 
+             return;
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/insserv-defaults.diff
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/insserv-defaults.diff
@@ -0,0 +1,19 @@
+--- hsqldb-1.8.0.10.orig/bin/hsqldb
++++ hsqldb-1.8.0.10/bin/hsqldb
+@@ -46,13 +46,12 @@
+ # pidfile: /var/run/hsqldb.pid
+ # config: /etc/sysconfig/hsqldb
+ 
+-# This stuff for SuSE Linux.  Contributed by M. Bisping.
+ ### BEGIN INIT INFO
+ # Provides:          hsqldb-server
+ # Required-Start:    $syslog $remote_fs $network $named
+-# Required-Stop:
++# Required-Stop:     $remote_fs
+-# Default-Start:     3 5
+-# Default-Stop:      0 1 2 6
++# Default-Start:     2 3 4 5
++# Default-Stop:      0 1 6
+ # Short-Description: HSQLDB-Server
+ # Description:       Hsqldb, A High Performance Java Database Server
+ ### END INIT INFO
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/java7-jdbc-4.1.patch
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/java7-jdbc-4.1.patch
@@ -0,0 +1,314 @@
+--- hsqldb/build/build.xml	2012-07-12 10:58:11.000000000 +0200
++++ hsqldb/build/build.xml	2012-07-12 10:49:28.000000000 +0200
+@@ -98,16 +98,24 @@
+       <echo message="ant.java.hasjsse=${ant.java.hasjsse}" />
+    </target>
+ 
+-   <target name="javaversion6">
++   <target name="javaversion7" unless="ant.java.iscjavaset">
++      <available classname="java.util.Objects" property="ant.java.iscjava17"/>
++      <available classname="java.util.Objects" property="ant.java.iscjavaset"/>
++   </target>
++
++   <target name="javaversion6" depends="javaversion7" unless="ant.java.iscjavaset">
+       <available classname="java.net.IDN" property="ant.java.iscjava16"/>
++      <available classname="java.net.IDN" property="ant.java.iscjavaset"/>
+    </target>
+ 
+-   <target name="javaversion4" depends="javaversion6" unless="ant.java.iscjava16">
++   <target name="javaversion4" depends="javaversion6" unless="ant.java.iscjavaset">
+       <available classname="java.nio.Buffer" property="ant.java.iscjava14"/>
++      <available classname="java.nio.Buffer" property="ant.java.iscjavaset"/>
+    </target>
+ 
+-   <target name="javaversion2" depends="javaversion4" unless="ant.java.iscjava14">
++   <target name="javaversion2" depends="javaversion4" unless="ant.java.iscjavaset">
+       <available classname="java.lang.ref.Reference" property="ant.java.iscjava12"/>
++      <available classname="java.lang.ref.Reference" property="ant.java.iscjavaset"/>
+    </target>
+ 
+    <target name="-prepare" depends="init,javaversion2">
+@@ -166,6 +174,7 @@
+       <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+         <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
+         <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
++        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcStatement.java"/>
+         <arg file="${src}/org/hsqldb/persist/LockFile.java"/>
+         <arg file="${src}/org/hsqldb/persist/Logger.java"/>
+@@ -183,6 +192,7 @@
+       <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+         <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
+         <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
++        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcBlob.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcDatabaseMetaData.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcDataSource.java"/>
+@@ -210,6 +220,7 @@
+         <arg value="+JAVA2FULL"/>
+         <arg value="-JAVA4"/>
+         <arg value="-JAVA6"/>
++        <arg value="-JAVA7"/>
+        </java>
+     </target>
+ 
+@@ -218,6 +229,7 @@
+       <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+         <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
+         <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
++        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcBlob.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcDatabaseMetaData.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcDataSource.java"/>
+@@ -244,6 +256,7 @@
+         <arg value="+JAVA2FULL"/>
+         <arg value="+JAVA4"/>
+         <arg value="-JAVA6"/>
++        <arg value="-JAVA7"/>
+        </java>
+     </target>
+ 
+@@ -253,6 +266,43 @@
+       <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
+         <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
+         <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
++        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcBlob.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcDatabaseMetaData.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcDataSource.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcCallableStatement.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcClob.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcConnection.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcParameterMetaData.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcPreparedStatement.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSet.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcResultSetMetaData.java"/>
++        <arg file="${src}/org/hsqldb/jdbc/jdbcStatement.java"/>
++        <arg file="${src}/org/hsqldb/persist/LockFile.java"/>
++        <arg file="${src}/org/hsqldb/persist/Logger.java"/>
++        <arg file="${src}/org/hsqldb/persist/ScaledRAFile.java"/>
++        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
++        <arg file="${src}/org/hsqldb/util/DatabaseManager.java"/>
++        <arg file="${src}/org/hsqldb/util/ConnectionDialogCommon.java"/>
++        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
++        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
++        <arg file="${src}/org/hsqldb/lib/SimpleLog.java"/>
++        <arg file="${src}/org/hsqldb/rowio/RowInputTextLog.java"/>
++        <arg file="${src}/org/hsqldb/HsqlDateTime.java"/>
++        <arg value="+JAVA2"/>
++        <arg value="+JAVA2FULL"/>
++        <arg value="+JAVA4"/>
++        <arg value="+JAVA6"/>
++        <arg value="-JAVA7"/>
++      </java>
++    </target>
++
++    <target name="switchtojdk17" depends="switchtojdk16"
++            description="self explanatory" if="ant.java.iscjava17">
++      <java classname="org.hsqldb.util.CodeSwitcher" classpath="classes" >
++        <arg file="${src}/org/hsqldb/lib/java/JavaSystem.java"/>
++        <arg file="${src}/org/hsqldb/lib/HsqlTimer.java"/>
++        <arg file="${src}/org/hsqldb/jdbcDriver.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcBlob.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcDatabaseMetaData.java"/>
+         <arg file="${src}/org/hsqldb/jdbc/jdbcDataSource.java"/>
+@@ -279,10 +329,11 @@
+         <arg value="+JAVA2FULL"/>
+         <arg value="+JAVA4"/>
+         <arg value="+JAVA6"/>
++        <arg value="+JAVA7"/>
+       </java>
+     </target>
+ 
+-    <target name="store" depends="switchtojdk16"
++    <target name="store" depends="switchtojdk17"
+             description="compiles the /store folder">
+       <javac srcdir="${src}"
+              destdir="classes"
+--- hsqldb/src/org/hsqldb/jdbc/jdbcCallableStatement.java	2012-02-08 15:14:42.802123563 +0000
++++ hsqldb/src/org/hsqldb/jdbc/jdbcCallableStatement.java	2012-02-08 15:47:35.842635642 +0000
+@@ -3375,4 +3375,18 @@
+     }
+ 
+ //#endif JAVA6
++
++//#ifdef JAVA7
++    public <T> T getObject(String columnLabel, Class<T> type) throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++    public <T> T getObject(int ColumnIndex, Class<T> type) throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++
++//#endif JAVA7
+ }
+--- hsqldb/src/org/hsqldb/jdbc/jdbcConnection.java	2012-02-08 15:14:42.802123563 +0000
++++ hsqldb/src/org/hsqldb/jdbc/jdbcConnection.java	2012-02-08 15:47:35.851635628 +0000
+@@ -48,6 +48,12 @@
+ import java.sql.SQLXML;
+ 
+ //#endif JAVA6
++
++//#ifdef JAVA7
++import java.util.concurrent.Executor;
++
++//#endif JAVA7
++
+ import java.sql.PreparedStatement;
+ import java.sql.SQLException;
+ import java.sql.SQLWarning;
+@@ -2793,4 +2799,31 @@
+     }
+ 
+ //#endif JAVA6
++
++//#ifdef JAVA7
++    public int getNetworkTimeout() throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++    public void setNetworkTimeout(Executor executor, int millis) throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++    public void abort(Executor executor) throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++    
++    public String getSchema() throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++    public void setSchema(String schema) throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++//#endif JAVA7
+ }
+--- hsqldb/src/org/hsqldb/jdbc/jdbcDatabaseMetaData.java	2012-02-08 15:14:42.802123563 +0000
++++ hsqldb/src/org/hsqldb/jdbc/jdbcDatabaseMetaData.java	2012-02-08 15:47:35.835635654 +0000
+@@ -5693,4 +5693,21 @@
+     }
+ 
+ //#endif JAVA6
++
++
++//#ifdef JAVA7
++    public boolean generatedKeyAlwaysReturned() throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++    public ResultSet getPseudoColumns(String catalog, String schemaPattern,
++                                      String tableNamePattern, String columnNamePattern) throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++
++//#endif JAVA7
++
+ }
+--- hsqldb/src/org/hsqldb/jdbc/jdbcDataSource.java	2012-02-08 15:14:42.802123563 +0000
++++ hsqldb/src/org/hsqldb/jdbc/jdbcDataSource.java	2012-02-08 15:47:35.836635653 +0000
+@@ -47,6 +47,11 @@
+ //#endif JAVA4
+ import org.hsqldb.jdbcDriver;
+ 
++//#ifdef JAVA7
++import java.sql.SQLFeatureNotSupportedException;
++import java.util.logging.Logger;
++//#endif JAVA7
++
+ // boucherb@users 20040411 - doc 1.7.2 - javadoc updates toward 1.7.2 final
+ 
+ /**
+@@ -323,4 +328,12 @@
+     }
+ 
+ //#endif JAVA6
++
++//#ifdef JAVA7
++    public Logger getParentLogger() throws SQLFeatureNotSupportedException
++    {
++        throw new SQLFeatureNotSupportedException("Not supported yet.");
++    }
++
++//#endif JAVA7
+ }
+--- hsqldb/src/org/hsqldb/jdbc/jdbcResultSet.java	2012-02-08 15:14:42.802123563 +0000
++++ hsqldb/src/org/hsqldb/jdbc/jdbcResultSet.java	2012-02-08 15:47:35.866635606 +0000
+@@ -5324,4 +5324,19 @@
+     }
+ 
+ //#endif JAVA6
++
++//#ifdef JAVA7
++
++    public <T> T getObject(String columnLabel, Class<T> type) throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++    public <T> T getObject(int columnNum, Class<T> type) throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++//#endif JAVA7
++
+ }
+--- hsqldb/src/org/hsqldb/jdbc/jdbcStatement.java	2012-02-08 15:14:42.802123563 +0000
++++ hsqldb/src/org/hsqldb/jdbc/jdbcStatement.java	2012-02-08 15:47:35.872635595 +0000
+@@ -1608,4 +1608,16 @@
+         throw new UnsupportedOperationException("Not supported yet.");
+     }
+ //#endif JAVA6
++
++//#ifdef JAVA7
++    public boolean isCloseOnCompletion() throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++
++    public void closeOnCompletion() throws SQLException
++    {
++        throw new UnsupportedOperationException("Not supported yet.");
++    }
++//#endif JAVA7
+ }
+--- hsqldb/src/org/hsqldb/jdbcDriver.java	2012-02-08 15:14:42.800123566 +0000
++++ hsqldb/src/org/hsqldb/jdbcDriver.java	2012-02-08 15:47:35.826635667 +0000
+@@ -42,6 +42,11 @@
+ import org.hsqldb.persist.HsqlDatabaseProperties;
+ import org.hsqldb.persist.HsqlProperties;
+ 
++//#ifdef JAVA7
++import java.sql.SQLFeatureNotSupportedException;
++import java.util.logging.Logger;
++//#endif JAVA7
++
+ // fredt@users 20011220 - patch 1.7.0 by fredt
+ // new version numbering scheme
+ // fredt@users 20020320 - patch 1.7.0 - JDBC 2 support and error trapping
+@@ -321,4 +326,12 @@
+             DriverManager.registerDriver(new jdbcDriver());
+         } catch (Exception e) {}
+     }
++
++//#ifdef JAVA7
++    public Logger getParentLogger() throws SQLFeatureNotSupportedException
++    {
++        throw new SQLFeatureNotSupportedException("Not supported yet.");
++    }
++
++//#endif JAVA7
+ }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/multipleResultSets.diff
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/multipleResultSets.diff
@@ -0,0 +1,25 @@
+From 856159b3913976c68c8a04b7e939a6cc64477f6a Mon Sep 17 00:00:00 2001
+From: Julien Nabet <serval2412@yahoo.fr>
+Date: Thu, 22 Feb 2018 21:33:20 +0100
+Subject: tdf#115828: hsqldb supports multiple resultSets
+
+Regression from 3c567e55e6aed9e0da892d8b9fc09f8a0c784fcc
+Thank you to Lionel for this suggestion
+
+Change-Id: I5eeadc1968e57d586e55a7aa5488b2ab3ee43724
+Reviewed-on: https://gerrit.libreoffice.org/50202
+Reviewed-by: Lionel Elie Mamane <lionel@mamane.lu>
+Tested-by: Jenkins <ci@libreoffice.org>
+
+--- misc/hsqldb/src/org/hsqldb/jdbc/jdbcDatabaseMetaData.java	2012-02-08 15:14:42.802123563 +0000
++++ misc/build/hsqldb/src/org/hsqldb/jdbc/jdbcDatabaseMetaData.java	2012-02-08 15:47:35.835635654 +0000
+@@ -1347,7 +1347,7 @@
+      * @exception SQLException if a database access error occurs
+      */
+     public boolean supportsMultipleResultSets() throws SQLException {
+-        return false;
++        return true;
+     }
+
+     /**
+
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/no-implementation-vendor-and-version.diff
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/no-implementation-vendor-and-version.diff
@@ -0,0 +1,91 @@
+--- a/build/build.xml-old	2017-08-16 20:19:37.151003005 +0000
++++ b/build/build.xml	2017-08-16 20:20:02.071356282 +0000
+@@ -21,8 +21,6 @@
+                locale="en"/>
+    </tstamp>
+ 
+-   <property name="build.label" value="private-${_tmpstamp}"/>
+-   <property name="build.vendor" value="${user.name}"/>
+    <property name="hsqldb.title" value="HSQLDB"/>
+    <property name="hsqldb.vendor" value="The HSQLDB Development Group"/>
+    <property name="src" value="${basedir}/src"/>
+@@ -481,8 +479,6 @@
+              <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+              <attribute name='Implementation-Title'
+                         value='Zaurus runtime'/>
+-             <attribute name='Implementation-Version' value='${build.label}'/>
+-             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+          </manifest>
+          <exclude name="org/hsqldb/jmx/**"/>
+          <exclude name="org/hsqldb/util/*Transfer*.*"/>
+@@ -528,8 +524,6 @@
+              <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+              <attribute name='Implementation-Title'
+                         value='Test runtime'/>
+-             <attribute name='Implementation-Version' value='${build.label}'/>
+-             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+          </manifest>
+          <exclude name="org/hsqldb/jmx/**"/>
+          <exclude name="org/hsqldb/sample/*.*"/>
+@@ -553,8 +547,6 @@
+              <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+              <attribute name='Implementation-Title'
+                         value='Runtime without utilities'/>
+-             <attribute name='Implementation-Version' value='${build.label}'/>
+-             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+          </manifest>
+          <exclude name="org/hsqldb/jmx/**"/>
+          <exclude name="org/hsqldb/util/**"/>
+@@ -580,8 +572,6 @@
+              <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+              <attribute name='Implementation-Title'
+                  value='Runtime without utilities and servers'/>
+-             <attribute name='Implementation-Version' value='${build.label}'/>
+-             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+          </manifest>
+          <exclude name="org/hsqldb/jdbc/jdbcStubs.class"/>
+          <exclude name="org/hsqldb/jdbc/Array.class"/>
+@@ -629,8 +619,6 @@
+              <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+              <attribute name='Implementation-Title'
+                         value='Standard runtime'/>
+-             <attribute name='Implementation-Version' value='${build.label}'/>
+-             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+              <!-- This attribute is completely ignored unless the user
+                   uses the jar like "java -jar .../hsqldb.jar" -->
+              <attribute name='Main-Class' value='org.hsqldb.util.SqlTool'/>
+@@ -740,8 +728,6 @@
+              <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+              <attribute name='Implementation-Title'
+                         value='JDBC client runtime'/>
+-             <attribute name='Implementation-Version' value='${build.label}'/>
+-             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+           </manifest>
+           <fileset refid='jdbcclasses'/>
+         </jar>
+@@ -756,8 +742,6 @@
+                 <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+                 <attribute name='Implementation-Title'
+                            value='SqlTool runtime, with JDBC driver'/>
+-                <attribute name='Implementation-Version' value='${build.label}'/>
+-                <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+                 <attribute name='Main-Class' value='org.hsqldb.util.SqlTool'/>
+             </manifest>
+             <!-- including 'org/hsqldb/jdbc*' just to be safe -->
+@@ -776,7 +760,6 @@
+                 <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+                 <attribute name='Implementation-Title'
+                            value='HSQLDB Transfer Tool classes'/>
+-                <attribute name='Implementation-Version' value='${build.label}'/>
+                 <attribute name='Class-Path' value='hsqldb.jar'/>
+                 <attribute name='Main-Class' value='org.hsqldb.util.DatabaseManagerSwing'/>
+                 <!-- If we prefer to encourage use of Transfer instead of
+@@ -805,8 +788,6 @@
+              <attribute name='Specification-Vendor' value='${hsqldb.vendor}'/>
+              <attribute name='Implementation-Title'
+                         value='Utilities runtime, without JDBC driver'/>
+-             <attribute name='Implementation-Version' value='${build.label}'/>
+-             <attribute name='Implementation-Vendor' value='${build.vendor}'/>
+              <!-- N.b. Blaine removed the Main-Class because this jar is
+                   useless without a JDBC driver in the classpath, and you
+                   can't add to classpath if invoked with "-jar" -->
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/patches/use-system-servlet.jar.diff
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/patches/use-system-servlet.jar.diff
@@ -0,0 +1,29 @@
+--- hsqldb-1.8.0.10+dfsg.orig/build/build.xml
++++ hsqldb-1.8.0.10+dfsg/build/build.xml
+@@ -313,7 +313,7 @@
+                  optimize="${build.optimize}"
+        >
+          <classpath>
+-            <pathelement location="lib/servlet.jar"/>
++            <pathelement location="/usr/share/java/servlet-api-3.1.jar"/>
+          </classpath>
+          <include name="*.java"/>
+          <include name="org/hsqldb/*.java"/>
+@@ -775,7 +775,7 @@
+ 		   				${src}/org/hsqldb/util/RCData.java,
+ 		   				${src}/org/hsqldb/util/SqlTool.java"
+            destdir="${basedir}/doc/src"
+-           classpath="${basedir}/lib/servlet.jar;${basedir}/lib/junit.jar"
++           classpath="/usr/share/java/servlet-api-3.1.jar;${basedir}/lib/junit.jar"
+            author="true"
+            version="false"
+            use="true"
+@@ -796,7 +796,7 @@
+       <javadoc packagenames="org.hsqldb.*,org.hsqldb.jdbc.*,org.hsqldb.lib.*,org.hsqldb.util.*"
+            sourcepath="${src}"
+            destdir="${basedir}/doc/src"
+-           classpath="${basedir}/lib/servlet.jar;${basedir}/lib/junit.jar"
++           classpath="/usr/share/java/servlet-api-3.1.jar;${basedir}/lib/junit.jar"
+            author="true"
+            version="false"
+            use="true"
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/debian/rules
+++ hsqldb1.8.0-1.8.0.10+dfsg/debian/rules
@@ -0,0 +1,59 @@
+#!/usr/bin/make -f
+
+include /usr/share/cdbs/1/rules/debhelper.mk
+include /usr/share/cdbs/1/class/ant.mk
+include /usr/share/cdbs/1/rules/simple-patchsys.mk
+
+include /usr/share/dpkg/architecture.mk
+
+JAVA_HOME = /usr/lib/jvm/default-java
+DEB_JARS = servlet-api
+DEB_ANT_BUILDFILE = build/build.xml
+DEB_ANT_BUILD_TARGET = hsqldb hsqldbutil
+DEB_ANT_ARGS += -Dant.build.javac.target=1.5 -Dant.build.javac.source=1.5
+
+DEB_INSTALL_DOCS_ALL = -X .cvsignore
+DEB_INSTALL_CHANGELOGS_ALL = changelog.combined
+
+common-build-indep:: changelog.combined NEWS
+
+define combine-changelog
+( \
+    set -e; \
+    set `echo $^ | tr ' ' '\n' | sort -r`; \
+    for f; do \
+        if [ $$f != $$1 ]; then \
+            echo; echo; \
+            for i in `seq 80`; do echo -n '='; done; \
+            echo; echo; \
+        fi; \
+        fold -s $$f; \
+   done \
+) >$@
+endef
+
+changelog.combined: $(wildcard doc/changelist_*.txt)
+	$(combine-changelog)
+
+NEWS: $(wildcard doc/changelog_*.txt)
+	$(combine-changelog)
+
+
+define install-jar
+install -m 644 -D lib/$(1).jar $(DEB_FINALDIR)/usr/share/java/$(1)1.8.0-$(DEB_UPSTREAM_VERSION).jar
+dh_link /usr/share/java/$(1)1.8.0-$(DEB_UPSTREAM_VERSION).jar /usr/share/java/$(1)1.8.0.jar
+endef
+
+install/libhsqldb1.8.0-java:: DEB_FINALDIR=$(CURDIR)/debian/libhsqldb1.8.0-java/
+install/libhsqldb1.8.0-java::
+	$(call install-jar,hsqldb)
+	$(call install-jar,hsqldbutil)
+	jh_classpath -plibhsqldb1.8.0-java --classpath=/usr/share/java/servlet-api-3.1.jar \
+		$(CURDIR)/debian/libhsqldb1.8.0-java/usr/share/java/hsqldb1.8.0-$(DEB_UPSTREAM_VERSION).jar
+
+clean::
+	rm -f lib/hsqldb*.jar
+	$(MAKE) -C debian/bin clean
+	rm -f changelog.combined NEWS
+	mh_clean
+
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcBlob.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcBlob.java
@@ -462,7 +462,6 @@
     }
 
 //#ifdef JAVA6
-/*
     public void free() throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -472,7 +471,6 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 
 //#endif JAVA6
 
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcCallableStatement.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcCallableStatement.java
@@ -37,11 +37,9 @@
 import java.sql.CallableStatement;
 import java.sql.Date;
 //#ifdef JAVA6
-/*
 import java.sql.NClob;
 import java.sql.RowId;
 import java.sql.SQLXML;
-*/
 //#endif JAVA6
 import java.sql.Time;
 import java.sql.Timestamp;
@@ -3106,7 +3104,6 @@
     
 //#endif JAVA4
 //#ifdef JAVA6
-/*
     public void setPoolable(boolean poolable) throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -3376,7 +3373,6 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 
 //#endif JAVA6
 }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcClob.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcClob.java
@@ -464,7 +464,6 @@
     }
 
 //#ifdef JAVA6
-/*
     public void free() throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -474,6 +473,5 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 //#endif JAVA6
 }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcConnection.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcConnection.java
@@ -43,11 +43,9 @@
 import java.sql.DatabaseMetaData;
 
 //#ifdef JAVA6
-/*
 import java.sql.NClob;
 import java.sql.SQLClientInfoException;
 import java.sql.SQLXML;
-*/
 
 //#endif JAVA6
 import java.sql.PreparedStatement;
@@ -2729,7 +2727,6 @@
     }
 
 //#ifdef JAVA6
-/*
     public Clob createClob() throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -2794,7 +2791,6 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 
 //#endif JAVA6
 }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcDataSource.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcDataSource.java
@@ -312,7 +312,6 @@
     }
 
 //#ifdef JAVA6
-/*
     public <T> T unwrap(Class<T> iface) throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -322,7 +321,6 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 
 //#endif JAVA6
 }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcDatabaseMetaData.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcDatabaseMetaData.java
@@ -37,9 +37,7 @@
 import java.sql.SQLException;
 
 //#ifdef JAVA6
-/*
 import java.sql.RowIdLifetime;
-*/
 
 //#endif JAVA6
 import org.hsqldb.Column;
@@ -5650,7 +5648,6 @@
     }
 
 //#ifdef JAVA6
-/*
     public RowIdLifetime getRowIdLifetime() throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -5694,7 +5691,6 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 
 //#endif JAVA6
 }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcParameterMetaData.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcParameterMetaData.java
@@ -383,7 +383,6 @@
     }
 
 //#ifdef JAVA6
-/*
     public <T> T unwrap(Class<T> iface) throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -393,7 +392,6 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 
 //#endif JAVA6
 }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcPreparedStatement.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcPreparedStatement.java
@@ -39,11 +39,9 @@
 import java.sql.Date;
 
 //#ifdef JAVA6
-/*
 import java.sql.NClob;
 import java.sql.RowId;
 import java.sql.SQLXML;
-*/
 
 //#endif JAVA6
 import java.sql.PreparedStatement;
@@ -2293,7 +2291,6 @@
     }
 
 //#ifdef JAVA6
-/*
     public void setPoolable(boolean poolable) throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -2403,7 +2400,6 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 
 //#endif JAVA6
 }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcResultSet.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcResultSet.java
@@ -76,11 +76,9 @@
 import java.sql.ResultSetMetaData;
 
 //#ifdef JAVA6
-/*
 import java.sql.RowId;
 import java.sql.NClob;
 import java.sql.SQLXML;
-*/
 
 //#endif JAVA6
 import java.sql.SQLException;
@@ -5075,7 +5073,6 @@
     }
 
 //#ifdef JAVA6
-/*
     public RowId getRowId(int columnIndex) throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -5325,7 +5322,6 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 
 //#endif JAVA6
 }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcResultSetMetaData.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcResultSetMetaData.java
@@ -1145,7 +1145,6 @@
         }
     }
 //#ifdef JAVA6
-/*
     public <T> T unwrap(Class<T> iface) throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -1155,6 +1154,5 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 //#endif JAVA6
 }
--- hsqldb1.8.0-1.8.0.10+dfsg.orig/src/org/hsqldb/jdbc/jdbcStatement.java
+++ hsqldb1.8.0-1.8.0.10+dfsg/src/org/hsqldb/jdbc/jdbcStatement.java
@@ -1588,7 +1588,6 @@
         }
     }
 //#ifdef JAVA6
-/*
     public void setPoolable(boolean poolable) throws SQLException
     {
         throw new UnsupportedOperationException("Not supported yet.");
@@ -1608,6 +1607,5 @@
     {
         throw new UnsupportedOperationException("Not supported yet.");
     }
-*/
 //#endif JAVA6
 }