May 11th, 2013
· Do not unicode compress strings which are longer than 1024 chars. Fixes bug 94.
February 19th, 2013
· Add info to the Column to support MEMO columns which are HYPERLINKS. jahlborn
· Add optional support for enforcing foreign-key constraints/cascading. This is disabled by default (for backwards compatibility), but can be controlled globally via a system property and/or on a per-Database basis using setEnforceForeignKeys() method. Fixes 22.
October 17th, 2012
· Add some more functionality to Joiner to facilitate integrity enforcement (hasRows and deleteRows).
· Added DatabaseBuilder in for more convenient and flexible Database open/create.
· Added the MemFileChannel (and associated support in DatabaseBuilder) to enable working with Database files completely in memory.
· Fix some more edge cases in date/time conversions. Fixes bug 92.
July 12th, 2012
· Add osgi header information to the manifest. Fixes 3523179.
· Add ImportUtil.toColumns to enable more advanced Table creation implementations. Fixes 3523181.
· Fix NPE when running unit tests with db format MSISAM. Fixes 3529534.
· Fix writing partial pages when CodecHandler is in use. Note, this fix involves a backwards incompatible change to the CodecHandler interface (Jackcess Encrypt 1.0.3 or later is compatible with this version of Jackcess). Fixes 3532250.
April 4th, 2012
· Rename and refactor the Cursor find methods to improve usability.
· Add initial support for linked tables. Linked tables will now be loaded by the normal Database.getTable method. Linked tables can be created using the new Database.createLinkedTable method. Linked table resolution can be customized per Database by supplying a custom LinkResolver. Fixes 3479560.
December 21st, 2011
· Add support for reading/writing complex column data (version history, attachments, multi-value columns). Fixes 3358272.
· Fix problem with creating tables with indexes where ms access could not open the created table.
· Fix problem with reading row from table with deleted/added columns. Fixes 3435774.
· Reuse previously written memo/ole values when updating other values in a row in order to reduce unnecessary data duplication.
· Allow ImportFilter and ExportFilter to return null from filterRow() to indicate that a row should be skipped.
· Add option to import file without headers to existing table.
· Add ImportUtil.Builder and ExportUtil.Builder to simplify import/export operations.
May 24th, 2011
· Refactor table loading to use indexes. Do not load all table names at database startup (should make startup faster).
· Add support for reading properties blobs. Add methods for accessing database, summary, and user-defined properties from the Database. Add methods to Table and Column for accessing their respective properties.
· Add support for Access 2010, including new "General" sort order (support for super-long text index entries still needs work).
· Access expects a row to be at least big enough to hold all fixed values, even if they are null. Fixes 3287626 .
· Add Index.getReferencedIndex for retrieving the referenced Index for a foreign key index.
March 9th, 2011
· Add support for writing all fixed length column types into variable length fields.
· More fixes related to reading and interpreting index information.
· Handle multiple logical indexes backed by the same index data.
· Interpret foreign key constraint information.
· Add support for creating indexes when creating a new table.
· Normal indexes and primary key indexes are currently supported.
· Foreign key indexes are not yet supported.
· Allow MSISAM files to be written (experimental).
December 1st, 2010
· Add support for specifying a quote character on import from flat files.
· Add support for reading database password.
· Add support for plugging in implementations of various page encoding/decoding algorithms. See the Jackcess Encrypt project for a CodecProvider implementation which supports a few of the Access encodings. (thanks to Vladimir Berezniker). Fixes 3065010 .
· Implement some tweaks which allow jackcess to be used on the Android platform. See the FAQ for more details. (thanks to Miha Pirnat). Fixes 3101578 .
· Allow output column order in tables to be configured. Fixes 3097387 .
· Add support for custom column value matching when finding rows using a Cursor. Fixes 3105829 .
· Ignore usagemap inconsistencies in certain (safe) situations.
August 3rd, 2010
· Add ExportUtil and associated utilities for exporting tables to flat files (thanks to F. Gerbig). Fixes 3005272 .
· Fix some places where table/columns names were not being handled case-insensitively. Fixes 3011084 .
· Make Database.escapeIdentifier public; add methods to TableBuilder and ColumnBuilder to optionally escape names. Fixes 3029500 .
· Add support for overriding charset and tiemzone used when reading/writing database. Fixes 2997751 .
· Add support for reading Access 97 (jet format 3) databases (thanks to F. Gerbig). Fixes 3003375 .
January 20th, 2010
· Add support for indexing strings containing any characters from BMP 0. Fixes 2920092
· Set overflow info in header row, not in last data row. Fixes 2919216
· Handle more binary/character input types (Blob, Clob, InputStream, Reader), based on user submitted patch.
· Refactor import/copy methods from Database into ImportUtil. Allow reuse of existing tables. make behavior/naming of copy and import methods consistent. (ideas from submitted patch).
· Further improvements to date handling. Fixes 2899605
June 16th, 2009
· Add support for reading MS Access queries
· Be more forgiving for input column length. Fixes #2788029