UltraLiteJ new features

Following is a list of additions to UltraLiteJ introduced in version 11.0.1.

  • Additional SQL support   UltraLiteJ provides additional SQL support as follows:

    • ALTER TABLE

    • CREATE TABLE

    • CREATE INDEX

    • DROP INDEX

    • DROP TABLE

    • TRUNCATE TABLE

    In addition, the following restrictions have been removed:

    • HAVING is supported.

    • DISTINCT within aggregate functions is supported.

    • CURRENT TIME, CURRENT TIMESTAMP and CURRENT DATE are supported.

    See UltraLite SQL statements.

  • New DatabaseInfo methods   Two new methods, getPageReads() and getPageWrites, have been added to the DatabaseInfo interface. These methods return the number of page reads and writes at the time a DatabaseInfo object was created. See DatabaseInfo.getPageReads method [UltraLiteJ] and DatabaseInfo.getPageWrites method [UltraLiteJ].

  • Updated UltraLiteJ Database Transfer utility   The UltraLiteJ Database Transfer utility now provides the ability to delete a database, display database information, or view or email the database transfer log, as well as transfer a database from the client. See UltraLite Java Edition Database Transfer utility (ULjDbT).