Jackcess / News: Recent posts

Jackcess 2.1.4 Release

• Fix missing column names in AppendQuery SQL strings.
• Add Database.getTableMetaData method to enable getting basic info about a Table (by name) without actually loading it.
• Allow null values in foreign key fields when enforcing referential integrity.
• Add support for cascade null on delete relationships.
• Add support for the required flag for an index.

Jackcess 2.1.3 Release

• Throw a prettier exception when maxing out the row size during row creation
• Add FileFormat.GENERIC_JET4 in order to support getting the file format for jet4 databases with no AccessVersion property (e.g. those created programmatically using ADOX)
• Update Add some utility methods (DatabaseBuilder.createDateFormat and DatabaseBuilder.toCompatibleCalendar) for handling Dates in an Access compatible manner
• New site style!

For those who prefer using GitHub, i've created a mirror of the Jackcess project repository on GitHub: https://github.com/jahlborn/jackcess

Jackcess 2.1.2 Release

• Handle reading null calculated values
• Fix handling of dateTimes before the access epoch

Jackcess 2.1.1 Release

• Load linked table info from system table when reading databases with unsupported sort orders
• Allow optional direct insert/update of autonumber values. This is disabled by default, but can be selectively enabled per-jvm (using system property), per-database, and per-table

Jackcess 2.1.0 Release

• OpenHMS relicenses to Apache License, 2.0!

Jackcess 2.0.9 Release

• Make ColumnBuilder.setMaxLength do the right thing regardless of column type
• Handle input String boolean values
• Added Database.isLinkedTable method to identify if the given Table is linked to the database
• Added TableIterableBuilder for advanced Table iteration. This allows selectively including different table types when iterating the tables in a Database
• Lowered the log level for certain warnings related to system tables which do not generally affect jackcess functionality
• Added contextual information to many errors and warnings
• Implement support for indexes on BINARY fields
• Remove useless warning for fixed length columns lengths with longer length. Cleanup some other stuff related to copying existing columns in ColumnBuilder

Jackcess 2.0.8 Release

• Add newer sql type to access type mappings if the jvm supports them.
• Fix table name quoting for append and make table queries.
• Don't double quote already quoted identifiers.
• Better validation of identifier names (disallow invalid characters according to Access naming rules).

Jackcess 2.0.7 Release

• Unicode compression support was not correct for all possibly compressed characters.
• Currency columns will now return an accurate scale and precision.

Jackcess 2.0.6 Release

• IndexCursor can early exit when searching based on indexed values.
• Fix regression where empty memo values are returned as null.

Jackcess 2.0.5 Release

• Add Cursor.findRow(RowId) for moving to a specific Table row using only the RowId.
• Add support for reading and writing calculated column values. Jackcess will not evaluate the actual expressions, but the column values can be written directly. Fixes 105.
• Add the ability to set properties in DatabaseBuilder, TableBuilder, and ColumnBuilder.
• Add the ability to create tables with calculated fields.

Jackcess 2.0.4 Release

• Add ColumnValidator interface which allows column values to be easily manipulated/validated as they are written into the database.

Jackcess 2.0.3 Release

• Fix NullPointerException in RowImpl.toString() when value is null

Jackcess 2.0.2 Release

• Rework row add/update so that constraint violations do not leave behind partially written rows.
• Add ConstraintViolationException to distinguish exceptions due to violating database constraints from other random errors.

Jackcess 2.0.1 Release

• Add initial support for creating/parsing ole content.
• Ignore invalid column usage map definitions.
• Make reading long value columns more lenient (MEMO/OLE).
• Add support for modifying PropertyMaps.

Jackcess 1.2.14.3 Release

• Ignore invalid column usage map definitions.
• Make reading long value columns more lenient (MEMO/OLE).

Jackcess 2.0.0 Release

• Brand new API! This release is not backwards compatible with 1.x releases. See Migration Guide at http://jackcess.sourceforge.net/jackcess-2.html for more details.

Jackcess 1.2.14.2 Release

• Fix reading of Properties with multiple value blocks.

Jackcess 1.2.14.1 Release

• Remove extra object flags before checking query type.

Jackcess 1.2.14 Release

• Implement handling of usagemaps for long value (MEMO/OLE) columns.

Jackcess 1.2.13 Release

• Fix partial page updates when using CodecHandlers which can only do full page encoding
• Add more methods to Database for retrieving Relationships
• Implement attachment decoding, thanks to Lorenzo Carrara.

Jackcess 1.2.12 Release

• Do not unicode compress strings which are longer than 1024 chars.

Jackcess 1.2.10 Release

• 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.
• Add info to the Column to support MEMO columns which are HYPERLINKS.

Jackcess 1.2.9 Release

• 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.

Jackcess 1.2.8 Release

• 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.