Charles Elliott - 2020-09-29

I am trying to use ucanaccess 5.0.0 after a long hiatus. I want to store file CRS32s in an Access db (FileCRCs.accdb) which has two tables: FolderTable with two columns FolderNumber (long int) and Folder Name (String) and FileTable with three colums FolderNumber (long int) and FileName (String) and CRC (long int). The Java connection statement is:
Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); // Optional, same error occurs with or w/o it
Connection conn; // In data section
conn = DriverManager.getConnection("jdbc:ucanaccess://E:/Databases/FileCRCs.accdb;memory=true","","");
I have put several hours into this, and the error always has the same stack:
java.lang.ExceptionInInitializerError
at com.healthmarketscience.jackcess.impl.GeneralLegacyIndexCodes.getCharHandler(GeneralLegacyIndexCodes.java:291)
15 lines of jackcess.impl calls
at net.ucanaccess.jdbc.DefaultJackcessOpener.open(DefaultJackcessOpener.java:34)
at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:170)
at net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:51)
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:91)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at FilesCRC.init(FilesCRC.java:52)
at FilesCRC.main(FilesCRC.java:66)
Caused by: java.lang.NullPointerException
at com.healthmarketscience.jackcess.impl.DatabaseImpl.getResourceAsStream(DatabaseImpl.java:2175)
at com.healthmarketscience.jackcess.impl.GeneralLegacyIndexCodes.loadCodes(GeneralLegacyIndexCodes.java:318)
at com.healthmarketscience.jackcess.impl.GeneralLegacyIndexCodes$Codes.<clinit>(GeneralLegacyIndexCodes.java:267)
... 24 more</clinit></init>

In the exception catch block exception.getMessage() returns null.

I am using Eclipse Version: 2020-09 (4.17.0), Build id: 20200910-1200 and Java jdk1.8.0_261 either 32- or 64-bit.  All the ucanaccess jar files are on the command line
P:\Program Files (x86)\Java\jdk1.8.0_261-32\bin\javaw.exe -Dfile.encoding=Cp1252 "-Xbootclasspath/a:B:\J\UCanAccess\5.0.0\UCanAccess-5.0.0-bin\lib\commons-lang3-3.8.1.jar;B:\J\UCanAccess\5.0.0\UCanAccess-5.0.0-bin\lib\commons-logging-1.2.jar;B:\J\UCanAccess\5.0.0\UCanAccess-5.0.0-bin\lib\hsqldb-2.5.0.jar;B:\J\UCanAccess\5.0.0\UCanAccess-5.0.0-bin\lib\jackcess-3.0.1.jar;B:\J\UCanAccess\5.0.0\UCanAccess-5.0.0-bin\ucanaccess-5.0.0.jar" -classpath "E:\Development\Eclipse2\FilesCRC\bin" FilesCRC.

Platform is Windows 8.1 Pro 64-bit on an Intel Xeon CPU E3-1270 v3 @ 3.50GHz, 3492 Mhz, 4 Core(s), 8 Logical Processors.

Can you please tell me where the error is?

 
FilesCRC.java