Installing UCanAccess JDBC driver on Lucee

[cjsfmgr]

I am trying to figure our how to install the UCanAccess JDBC driver for MS Access on Lucee 5.4

I have tried a couple of methods and

Moving the UcanAccess jars to the /lucee/lib folder and restarted Lucee.

This didn’t add anything to the list of available drivers but I gave the Other JDBC Driver (deprecated option a try anyway.
I put in the Class and Connection String from the developers site: Bitbucket - with my own path to the access db (data.mdb)

…and got this error:
lucee.commons.lang.ClassException: cannot load class through its string name, because no definition for the class with the specified name [net.ucanaccess.jdbc.UcanaccessDriver] could be found caused by (java.lang.ClassNotFoundException:net.ucanaccess.jdbc.UcanaccessDriver;java.lang.ClassNotFoundException:net.ucanaccess.jdbc.UcanaccessDriver not found by lucee.core [41]

I am not surewhat this error is telling me.

Thanks for any help.

Magnus
Don’t forget to tell us about your stack!

OS:Win 10
Java Version: 20.0.1
Tomcat Version:10
Lucee Version: 5.4.0.80-SNAPSHOT

[andreas]

Welcome to the Lucee community!!!

Have you seen this post? You may need to adapt it to your installation/application.

Access databases (mdb) on Windows Server 2019

Ok, it took about 30min to try this, and I was able to make an access database work with an Lucee Express Version 5.3.10.97 on my Windows 10 Lap. You need to translate that to your installed server. But this works!!! If you have populated your Lucee installation with some other files, please restart from scratch. Here is a solution and the steps you need to make: Download Lucee Express Version 5.3.10.97 and unzip it. (If you are installing it to a Windows Server 2019 use the Lucee Installer,…