Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo


Jackcess / News: Recent posts

Jackcess 2.0.8 released

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).
Posted by James Ahlborn 2014-12-27

Jackcess 2.0.7 released

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.
Posted by James Ahlborn 2014-11-23

Jackcess 2.0.6 released

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.
Posted by James Ahlborn 2014-10-04

Jackcess 2.0.5 released

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.
Posted by James Ahlborn 2014-09-18

Jackcess 2.0.4 released

Jackcess 2.0.4 Release

  • Add ColumnValidator interface which allows column values to be easily manipulated/validated as they are written into the database.
Posted by James Ahlborn 2014-04-06

Jackcess 2.0.3 released

Jackcess 2.0.3 Release

  • Fix NullPointerException in RowImpl.toString() when value is null
Posted by James Ahlborn 2014-01-31

Jackcess 2.0.2 released

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.
Posted by James Ahlborn 2013-12-01

Jackcess 2.0.1 released

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.
Posted by James Ahlborn 2013-10-14

Jackcess released

Jackcess Release

  • Ignore invalid column usage map definitions.
  • Make reading long value columns more lenient (MEMO/OLE).
Posted by James Ahlborn 2013-10-14

Jackcess 2.0.0 released

Jackcess 2.0.0 Release

Posted by James Ahlborn 2013-08-26

Jackcess released

Jackcess Release

  • Fix reading of Properties with multiple value blocks.
Posted by James Ahlborn 2013-08-26

Jackcess released

Jackcess Release

  • Remove extra object flags before checking query type.
Posted by James Ahlborn 2013-08-11

Jackcess 1.2.14 released

Jackcess 1.2.14 Release

  • Implement handling of usagemaps for long value (MEMO/OLE) columns.
Posted by James Ahlborn 2013-07-25

Jackcess 1.2.13 released

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.
Posted by James Ahlborn 2013-06-19

Jackcess 1.2.12 released

Jackcess 1.2.12 Release

  • Do not unicode compress strings which are longer than 1024 chars.
Posted by James Ahlborn 2013-05-11

Jackcess 1.2.10 released

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.
Posted by James Ahlborn 2013-02-19

Jackcess 1.2.9 released

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.
Posted by James Ahlborn 2013-01-12

Jackcess 1.2.8 release

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.
Posted by James Ahlborn 2012-07-11

Jackcess 1.2.7 released

Jackcess 1.2.7 Release

  • 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.
  • Rename and refactor the Cursor find methods to improve usability.
Posted by James Ahlborn 2012-04-03

Jackcess 1.2.6 released

Jackcess 1.2.6 Release

  • Add support for reading/writing complex column data (version history, attachments, multi-value columns).
  • 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
  • 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
Posted by James Ahlborn 2011-12-17

Jackcess 1.2.5 released

Jackcess 1.2.5 Release

  • Try multiple classloaders when loading resources as streams
  • Add the Joiner utility and some new methods to IndexCursor to make it easier to join tables using pre-defined (index backed) relationships
  • Enable basic handling of unsupported data types as binary content.
  • Add methods to approximate table size.
  • Add Database.getSystemTableNames to enable retrieving the list of system/hidden tables.
  • Fix issue with reading Access 97 database with large number of fields.
Posted by James Ahlborn 2011-10-20

Jackces 1.2.4 Released

Jackcess 1.2.4 Release

  • 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.
Posted by James Ahlborn 2011-05-15

Jackcess 1.2.3 released

Jackcess 1.2.3 Release

  • Add support for writing all fixed length column types into variable length fields. Fixes 3181334
  • More fixes related to reading and interpreting index information. Handle multiple logical indexes backed by the same index data. Interpret foreign key constraint information. Fixes 3192058
  • 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).
Posted by James Ahlborn 2011-03-05

Jackcess 1.2.2 released

Jackcess 1.2.2 Release Notes

  • 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 (http://jackcessencrypt.sourceforge.net/) 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.
Posted by James Ahlborn 2010-11-30

Jackcess 1.2.1 Released

Jackcess 1.2.1

  • 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.
Posted by James Ahlborn 2010-08-02