First I'd like to thank you for continued development of this library. Due to security requirements at our company we were forced to look into solutions for supporting Java 8 and your library saved a lot of time and headaches.
The only requirement we were unable to fulfill was the support of creating indexes on our pre-generated access databases. This seemed like it wasn't an issue and we went ahead without them. Now we are realizing this is causing Crystal Reports to run much slower.
I did some digging and it seems that in the latest version of jackcess creating indexes is now supported on existing tables as well as foreign keys. I may have to use the jackcess library directly to accomplish this in the short term, but I thought I would bring it up here in hopes that it can be implemented in a future release.
Jackcess
Release 2.1.5 – 2016-10-03
Change multi-value complex columns so that they return all relevant column properties.
Add some initial support for Table metadata modification. Columns and Indexes can now be added to an existing table (using ColumnBuilder.addToTable and IndexBuilder.addToTable respectively).
Add the ability to create Relationships using RelationshipBuilder. With this support finally brings the ability to create foreign key indexes (aka integrity enforcement in Relationships).
Last edit: Jonathan Montwell 2016-12-27
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
First I'd like to thank you for continued development of this library. Due to security requirements at our company we were forced to look into solutions for supporting Java 8 and your library saved a lot of time and headaches.
The only requirement we were unable to fulfill was the support of creating indexes on our pre-generated access databases. This seemed like it wasn't an issue and we went ahead without them. Now we are realizing this is causing Crystal Reports to run much slower.
I did some digging and it seems that in the latest version of jackcess creating indexes is now supported on existing tables as well as foreign keys. I may have to use the jackcess library directly to accomplish this in the short term, but I thought I would bring it up here in hopes that it can be implemented in a future release.
Jackcess
Release 2.1.5 – 2016-10-03
Last edit: Jonathan Montwell 2016-12-27
Yes, yes, I'm working on a full DDL implementation for the next release. Cheers Marco
Thanks for the quick reply. Great to hear.