Tweet
** This thread discusses the article: TechTip: Let IBM i Apps Access Microsoft Access with Jackcess **
In your article you mention that the javadoc is a bit sketchy in areas and that you would have liked more examples. The API for jackcess is fairly large, and I completely agree that the javadoc is a bit lacking in some areas. When people ask for examples, I generally point them to the unit tests because a large portion of the API is tested in the unit tests.
**** In your code example for importing using jackcess, you should make sure to _always_ close the database, otherwise file corruption could occur (and you only need to use create() or open(), not both). E.g.:
Database db = Database.create(Database.FileFormat.V2010,new File(accessFileName));
db.copyTable(accessExportTableName, resultSet);
db.close();
In your article you mention that the javadoc is a bit sketchy in areas and that you would have liked more examples. The API for jackcess is fairly large, and I completely agree that the javadoc is a bit lacking in some areas. When people ask for examples, I generally point them to the unit tests because a large portion of the API is tested in the unit tests.
**** In your code example for importing using jackcess, you should make sure to _always_ close the database, otherwise file corruption could occur (and you only need to use create() or open(), not both). E.g.:
Database db = Database.create(Database.FileFormat.V2010,new File(accessFileName));
db.copyTable(accessExportTableName, resultSet);
db.close();