Yep, Jackcess is pure Java. It will work on any Java Virtual Machine (1.5+).
As of the 1.2.4 release, Jackcess supports Access database versions 2000-2010 read/write and Access 97 read-only.
Basic password protection (Access 2003 or earlier) is merely software enforced, and Jackcess does not do any password checking at this point. So, a password protected database can be used the same as any other.
Data validation in Access is controlled via a variety of mechanisms, not all of which are supported by Jackces. See the table below for details:
|Data Validation Type||Support|
|Data types (Text, Number, etc.)||Yes|
|Field sizes (min/max length, precision, etc.)||Yes|
|Unique constraints (indexes)||Yes|
|"Enforce Referential Integrity" (aka foreign key constraints)||Off by default, optional support available in 1.2.10 release.|
|Field/Table Properties (Validation rules, Input masks, etc)||No|
We want to give a lot of credit to mdbtools. They have been around much longer than Jackcess, and, along with POI, inspired us that a project like this could be done. mdbtools is written in C. There is a Java port of it, but if you've ever read or used a Java port of a C library, you can appreciate the difference between such a library and one written from scratch in Java.
At the time of this writing, mdbtools could only read Access databases. Jackcess can also write to them. According to their web site, "Write support is currently being worked on and the first cut is expected to be included in the 0.6 release." This status hasn't changed since we first started work on Jackcess.
mdbtools supports Access 97 databases, which Jackcess does not. The Java port of mdbtools also includes an implementation of a small subset of the JDBC APIs. Jackcess does not currently, but a pure Java JDBC driver for Access could certainly be written on top of Jackcess.
POI is released under The Apache License. Jackcess is released under The GNU Lesser General Public License. The Apache license allows closed-source and/or commercial forks. The LGPL does not. If you change or enhance Jackcess, you must contribute your changes back to the project.
Version 1.0 requires JDK 1.4 or higher. The version in SVN trunk and all future releases will require JDK 1.5 or higher.
However, some users have contributed patches to make later versions compatible with JDK 1.4. Please check the contributions/ directory in the source repository for any such patches. Note that any code in this directory is untested and unsupported, so please use at your own risk and do not file bugs based on that code.
Probably because you're missing a jar that Jackcess depends on from your classpath. Take a look at the dependencies list. The "compile" and "runtime" dependencies are necessary for using Jackcess in your application. One great place to track down these dependencies is in the Ibiblio Maven Repository.
In general, the focus of Jackcess is functionality, not speed. However, one major speed factor is whether or not all writes are automatically forced to disk. By default, "autoSync" is enabled, which keeps the database file in a more consistent state, but can be very slow for large updates. Disabling "autoSync" can dramatically increase update speed, but exceptions during update can leave the file in an unusable state (when disabled, you can call Database.flush() manually to force updates to disk). Modifying this option essentially trades off speed for recoverability.
Additionally, adding rows in batches instead of one at a time can increase insert speed.
Finally, always make sure you are using the latest release, as speed improvements are happening periodically.
Update: As of the 1.1.21 release, the text index handling supports the entire Basic Multilingual Plane 0 (i.e. any unicode character 0x0000-0xFFFF). Consequently table names can (as of this release) contain any character in this character set. Therefore, the rest of this answer should no longer be an issue, but keeping it here for reference.
Jackcess cannot currently update a text column index with values which contain non-ascii characters. This situation often arises when tables are created with names which contain international characters. Access stores the table names in another table which has an index on the table name column. The index encoding is not simple to reverse engineer, so it is not likely that Jackcess will support this anytime soon.
Update: As of the 1.1.13 release, the text index handling supports the entire ISO-8859-1 character set. Consequently table names can (as of this release) contain any character in this character set.
Some suggestions (for older releases):
There are 2 issues which need to be dealt with when using Jackcess on the Android platform. The first is that non-class resources need to be in a special location. The second is that the nio implementation has some "weaknesses".
The following steps will make Jackcess compatible with the Android platform.
HMS is a small company located in suburban Philadelphia. Using proprietary matching and consolidation software, HMS scientifically manufactures the most comprehensive and accurate healthcare data sets in the market today.
Ok, that wasn't a question, but we'll try to respond anyway. :) As you might imagine, it's kind of hard to test, simply by its nature. There are bugs that we are aware of, and certainly many more that we are not. If you find what looks like a bug, please report it. Even better, fix it, and submit a patch.