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

Jackcess 1.2.0 Released

Jackcess 1.2.0

  • Add support for access 2002/2003/2007 databases!
  • Enable "large" index support by default. It can still be disabled via a variety of means, see the Database javadoc for more details.
  • Fix BigIndexTest to work in IDE's w/out sys.prop.
Posted by James Ahlborn 2010-04-19

Jackcess 1.1.21 Released

Jackcess 1.1.21

  • 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
Posted by James Ahlborn 2010-01-20

Jackcess 1.1.20 released

Jackcess 1.1.20

  • Add support for updating GUID indexes and for auto-number GUID fields.
  • Add support for updating rows in a table.
  • Support reading/writing fixed length text fields.
Posted by James Ahlborn 2009-11-19

Jackcess 1.1.19 released

Jackcess 1.1.19

  • Add support for reading MS Access queries
  • Be more forgiving for input column length. Fixes #2788029
Posted by James Ahlborn 2009-06-14

Jackcess 1.1.18 released

Jackcess 1.1.18

  • Add ErrorHandler utility for customizing error handling during row parsing.
  • Add RowFilter contributed by Patricia Donaldson.
  • Add Database.getSystemTable method for accessing system tables.
Posted by James Ahlborn 2008-11-08

Jackcess 1.1.17 released

Jackcess 1.1.17

  • Fix simple index handling of tail index pages
Posted by James Ahlborn 2008-09-24

Jackcess 1.1.16 released

Jackcess 1.1.16

  • Reserve minimum space for memo/ole fields so that greedy inline row usage does not cause spurious write failures for wide tables.
  • Better column type translation for very large MEMO/OLE types in the Database.copyTable logic.
  • Add some more limit checking into table creation based on what access supports (max rows per table, max identifier lengths).
  • Share out-of-line long value pages in order to generate more compact database files.
  • Add primitive support for writing unicode compressed text columns.
  • Add compression code for possible future use; add compression unit tests.
Posted by James Ahlborn 2008-07-25

Jackcess 1.1.15 released

Jackcess 1.1.15

  • Fix writing of large memo/ole fields. Apparently Access does not like long value fields longer than 4076 bytes. Fixes 1998225.
  • Reduce maximum row size to what Access considers valid.
Posted by James Ahlborn 2008-06-28

Jackcess 1.1.14 released

Jackcess 1.1.14

  • Need to store auto-number values back into row so that indexes can be updated correctly.
  • Access seems to limit data pages to a max of 255 rows.
  • Added experimental support for "large" indexes. The current support is optional. It can be enabled via a variety of means, see the Database javadoc for more details.
Posted by James Ahlborn 2008-04-29

Jackcess 1.1.13 released

Jackcess 1.1.13

  • More fixes for index parsing. Believe index names are now correctly matched up with indexes. Fixes 1913775
  • Simplify comparison algorithms for RowId and Index.Entry using type attributes
  • Expand the characters supported in index updates to all of the ISO-8859-1 character set. Fixes 1906160
  • Fix bug caused by sign extension when reading single-byte row numbers.
  • Modify Index update support so that it honors the "unique" and "ignoreNulls" properties for the Index.
  • Add support for reading table relationships.
  • Fix creation of tables with auto-number columns.
    Completely fix problems with sporadic usage map corruption. Fixes 1832723
  • Add some soft buffer caching in various places to avoid excessive buffer reallocation.
  • Add some builder-style utilities for table creation (ColumnBuilder, TableBuilder).
Posted by James Ahlborn 2008-03-21

Jackcess 1.1.12 Released

Jackcess 1.1.12

  • Resolve more edge cases around date handling.
  • Fix writing of large memo/ole fields. Apparently Access does not like "inline" fields longer than 64 bytes. Fixes 1899076
  • Fix generation of security access control entries. Use userIds already existing in the database file instead of hard-coded userIds, if possible. Fixes 1898793
Posted by James Ahlborn 2008-02-27

Jackcess 1.1.11 Released

Users of versions 1.1.9 and above are recommended to upgrade to this version due to the possible file corruption bug fixed in this release.

- Support reading inline usage maps with more than 512 pages.
- Fix some problems with sporadic usage map corruption.
- Move from cvs to subversion.

Posted by James Ahlborn 2008-01-21

Jackcess 1.1.10 released

Release 1.1.10

  • Add index based table traversal support to Cursor with optional sub-range narrowing. Add position save/restore, row find, and a variety of other features.
  • Move table iteration out of Table and into Cursor. First stage in offering more complicated table access.
  • Update table row count correctly on row deletion or bulk row addition, bug #1681954..
  • Add experimental support for auto-number columns, feature request #1565216.
  • Move project to maven2 and change project groupId to com.healthmarketscience.jackcess.
Posted by James Ahlborn 2007-12-26

jackcesss 1.1.10 moving to maven 2 and new groupId

Just wanted to let everyone know that the 1.1.10 release of jackcess will be built using maven 2. for now, the maven 1 project.xml will be left in the project, but it may disappear in a future release.

Also, as part of the integration with the OpenHMS project, the maven groupId for jackcess will be changing to com.healthmarketscience.jackcess. This change should be fairly painless through the magic of maven (ibiblio will be updated so that it should automagically forward to the new groupId).

Posted by James Ahlborn 2007-12-05

Jackcess 1.1.9 released

Release 1.1.9 done on 2007-07-12

Changes in this release:
- fix - Add support for writing large table definitions, bug #1675522.
- fix - Fix handling of usage maps for large tables, bug #1748827.
- fix - Fixed some edge cases for reading numeric columns, bug #1672071.

Posted by James Ahlborn 2007-07-13

Jackcess 1.1.8 released

Release 1.1.8 done on 2007-02-13

Changes in this release:

  • update - Additional info in DataType to support better type validation (scale/precision range). Add "unit size" concept.
  • update - Add CLOB support in JDBC handling. Add general support for large types (BLOB/CLOB).
  • update - Enhance Database.copyTable/importReader to allow for better control over column definitions and row values through the ImportFilter. Change default type translation to handle large and variable length types better.
Posted by James Ahlborn 2007-02-14

Jackcess 1.1.7 released

Release 1.1.7 done on 2006-10-02

Changes in this release:

  • update - Refactored DataType class, cleaned up a lot of "custom" data type code springled throughout the codebase.
  • update - Added sanity checking on table creation (check column/table properties for validity).
  • update - Clean up index reading/writing of text columns, add support for more characters
  • update - Support reading 'compressed' indexes (fix 1563654)
  • update - Implement "overflow" row reading.
  • fix - Allow multi-page long value reading.
  • update - Implement multi-page long value writing.
  • fix - Fix decimal data type writing.
  • update - Add support for opening files read-only (fix 1545857)
Posted by James Ahlborn 2006-10-02

Jackcess 1.1.6 released

Release 1.1.6 done on 2006-08-07

Changes in this release:

  • fix - Handle more tables with more index slots than actual indexes (fix bug
    Change made by jahlborn.
  • fix - Clean up reading/writing 3-byte ints; long value length is 3-bytes
    (fix bug 1449812)
    Change made by jahlborn.
  • fix - Fix handling of skipped rows
    Change made by jahlborn.
  • fix - When reading multi-page table def, flip buffer before parsing (fix bug
    Change made by jahlborn.
  • update - Treat table names as case insensitive; use stored table names when
    instantiating tables
    Change made by jahlborn.
  • update - Make Database and Table Iterable
    Change made by jahlborn.
  • fix - Use uppercase names when adding text columns to indexes, which fixes
    long standing problem with table names starting with lowercase
    characters (and other situations where tables could not be opened in
    Access). Remove hack which forced every table name to have uppercase
    first character.
    Change made by jahlborn.
  • update - Clean up compressed text handling.
    Change made by jahlborn.
  • update - Implement reading multi-page long binary values
    Change made by jahlborn.
Posted by James Ahlborn 2006-08-07

Jackcess 1.1.5 released

Release 1.1.5 done on 2006-07-25

Changes in this release:

  • update - Add support for currency columns (thanks to James Schopp).
    Change made by jahlborn.
  • fix - Handle tables with no variable length columns correctly.
    Change made by jahlborn.
  • fix - Handle reading with deleted columns.
    Change made by jahlborn.
  • update - Read information on primary keys and include in Index.
    Change made by jahlborn.
  • fix - Fix some issues around reading indexes.
    Change made by jahlborn.
  • update - Add write support for numeric/GUID columns.
    Change made by jahlborn.
  • update - Added getRowCount(), getName(), updated toString() on Table.
    Change made by javajedi.
Posted by James Ahlborn 2006-07-25

Jackcess 1.1.4 released.

Release 1.1.4 done on 2006-6-15

Changes in this release:

  • fix - Missing break in switch condition.
    Change made by jahlborn.
  • fix - Fixes to reading/writing MEMO/OLE columns.
    Change made by jahlborn.
  • update - Made exceptions thrown when opening empty or nonexistent files more
    Change made by jahlborn.
  • fix - Apply patch from Jon Iles for handilng variable length columns.
    Change made by jahlborn.
  • fix - Apply patch from Jon Iles for handling dates.
    Change made by jahlborn.
  • fix - Apply patch from Jon Iles for reading GUIDs.
    Change made by jahlborn.
Posted by James Ahlborn 2006-06-15

1.1.2 released

Fixed bug where writing null values into fixed-width columns was failing.

Posted by Tim McCune 2005-08-26

1.1.1 Released

Fixed bug in reading index count from table definition. Skip overflow rows.

Posted by Tim McCune 2005-08-20

1.1 released

  • JDK 1.5 upgrades
  • Applied Mitchell Friedman's patch for support of additional JDBC data types.
  • Added support for deleted rows.
Posted by Tim McCune 2005-08-12

1.0 released

Jackess is a pure Java library for reading & writing MS Access databases. This is our initial release.

Posted by Tim McCune 2005-04-07