Upgrade to HSQLDB 2.3.4

The UUID type for columns is now supported. SYNONYM for tables and functions, PERIOD predicates, and auto-updated TIMESTAMP columns on row updates are some of the new features. Ability to cancel long-running statements from JDBC, as well as from admin sessions has been added. UTF-16 files are now supported for text table sources, in addition to 8-bit text files. MySQL compatibility for REPLACE, INSERT IGNORE and ON DUPLICATE KEY UPDATE statements has been improved further. This release incorporates extensive code reviews, enhancements and bug fixes.

HSQLDB (HyperSQL DataBase) is the leading SQL relational database software written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes. It includes a powerful command line SQL tool and simple GUI query tools.

HSQLDB supports the widest range of SQL Standard features seen in any open source database engine: SQL:2011 core language features and an extensive list of SQL:2011 optional features. It supports nearly full Advanced ANSI-92 SQL (BNF format). Many extensions to the Standard, including syntax compatibility modes and features of other popular database engines, are also supported.

Version 2.3.4 is fully multithreaded and supports high performance 2PL and MVCC (multiversion concurrency control) transaction control models.

See http://hsqldb.org/web/features200.html