ucanaccess and GraalVM's native-image tool

[TPeterson94070]

I'm trying to port my app to a native exe using GraalVM's native-image tool, but ucanaccess throws an error message about not finding java.home and then doesn't provide access to my mdb. Here are the specific errors I'm seeing:

ERROR: table does not exist or database file is not writeable. UCAExc:::4.x.x java.lang.Error: Can't find java.home ??

ERROR: CaptureDataManager.makeDebugDataTable: UcanaccessSQLException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.x.x java.lang.NoClassDefFoundError: Could not initialize class org.hsqldb.lib.FileUtil

I see that the current version of ucanaccess is newer than the 5.0.1 version I'm using. Would updating likely help with this issue?

[sengsational]

There's a test project here with the 5.1.3 version: https://github.com/sengsational/TestUca/blob/master/TestUca.jar

[TPeterson94070]

Thanks @sengsational, that did solve the issue!

[spannm]

Hi @TPeterson94070,

I'm glad to hear that updating the dependency resolved the issue so quickly.

What you're working on is undoubtedly interesting to other developers and users. Feel free to leave a few pointers or observations here — they could well be helpful to others.

Cheers,
Markus

P.S.: This repo is the maintained fork of the original UCanAccess you were using. You can read more about it here.

[TPeterson94070]

Hi @spannm !

@sengsational and I are developers of the Cliff Watson EPG Program published in the Windows Store. Much of it is written in Delphi object pascal, but it has a significant Java component as well. We've long suspected that needing a JRE installation has been a (perhaps small, but real) barrier to our app's adoption. So we are trying to use GraalVM native-image to make the Java component free standing and simplify the app's installation. Getting UCanAccess compatible with native-image was a big step forward in that process.