First cut at support for hsqldb 2.x:
- Add upgrade class that removes GRANT ALL ON CLASS line from syndie.script
- Add user detection in connect() that works on 2.x
- Add SET FILES BACKUP INCREMENT TRUE for 2.x to speed shutdown
- Compact DB after upgrade

Also:
- Prevent dup connections, connection leaks, and changing login without disconnecting

Todo:
- Better handling of upper/lowercase login/password issues,
  as database logins were mapped to upper case but nym logins
  were at lower case. Fix reconnect()
- DBUpgrade logging cleanups
- Attempt to migrate syndie.log file too, instead of just deleting it
- Add hsqldb version to bug report
- Add hsqldb.jar 2.2.9 (same license)
- Bump build, plugin, and install requirements to Java 1.6, since the
  released hsqldb.jar is for 1.6. We could recompile it for 1.5, but not worth it.
- Include hsqldb.jar in plugin updates
2.x fixes:
- Fix message attachment size calculation breaking attachment tab in message view
- Fix query breaking NymChannelTree display
- Reduce log level in postConnect()
- Refactor db initialization and update out of DBClient to new class
drop unused hsqldb_changes.txt
- Store the DB user/pw in separate fields from the nym user/pw,
  to complete the fixes required by hsqldb 2.x recognizing case
  in DB login/pw.
- Simplify DB init code by renaming ddl.txt to ddl_update0.txt
  and removing buildDB() method
propagate errors correctly from db init/upgrade methods
- More DBInit cleanup and error propagation
propagate from branch 'i2p.syndie' (head 97b5364e00b704dacfe9287819c638827bf5c9ec)
            to branch 'i2p.syndie.hsqldb2' (head 00679e34efe34db5159150960e22d8ebdc0b5c16)
- Implement offline database backup
- Backup database before upgrading to hsqldb 2.x
add script for the hsqldb database manager tool
classpath fix
- Use DataHelper.loadProps() to deserialize properties UTF-8-safely
- Fix NPE when using 1.8 jar
- Fix, or maybe just move, NPE in addURI/getURI
- More db things package private
SQLTab tweaks
- Shutdown compact immediately after upgrade, then reconnect,
  as recommended by hsqldb
- Add code to migrate large things to LOBs, which didn't work
  in 2.2.9, due to hsqldb bug:
  http://sourceforge.net/projects/hsqldb/forums/forum/73674/topic/5519631
  LOB code disabled for now, needs testing with 2.3.1
- Update to DB version 25:
  - Add LOBs for attachments and pages
  - Increase length limits on cancelledURI, headerValue, and others
- Enable migration of large attachments and pages to LOBs
- Implement retrieval of pages and attachments from LOBs
- Implement getAttachmentAsStream for real (unused yet)
- Implement storage to LOBs in ImportPost
- Sleep a while before SHUTDOWN COMPACT
- Ignore SHUTDOWN COMPACT error after upgrade, just reopen anyway,
  but unlikely to work
- Use attachment size from messageAttachment table,
  not actual size from messageAttachmentData table
- Don't let one dup cancel URI make us skip processing the rest of them
- Set next version to be 1.104b in @since
hsqldb 2.3.1 modified as follows, compiled with:

java version "1.6.0_27"
OpenJDK Runtime Environment (IcedTea6 1.12.6) (6b27-1.12.6-1ubuntu0.13.04.2)
OpenJDK 64-Bit Server VM (build 20.0-b12, mixed mode)

---------
Diff with release is from SVN base/trunk from sourceforge:

diff src/org/hsqldb/persist/HsqlDatabaseProperties.java.orig src/org/hsqldb/persist/HsqlDatabaseProperties.java
152,153c152,153
<     public static final String THIS_VERSION         = "2.3.0";
<     public static final String THIS_FULL_VERSION    = "2.3.0";
---
>     public static final String THIS_VERSION         = "2.3.1";
>     public static final String THIS_FULL_VERSION    = "2.3.1";
158c158
<                                REVISION             = 0;
---
>                                REVISION             = 1;

---------

email:

---------

From: Fred Toussi <fredt@users.sourceforge.net>
Re: 2.3.1 version wrong

You are welcome to use the current SVN /base/trunk head which has the
correction and compile the jar yourself.

We decided not to release an update.

Regards

Fred

On Tue, Oct 15, 2013, zzz wrote:
>

> ...in the sourceforge hsqldb-2.3.1.zip download.
> This must be fixed for our upgrade logic to work correctly.
> Please fix it and re-release, thanks.