Ucanacces with Lucee 5 under Linux

I have installed Linux Debian 10 with Apache and Lucee 5

I need now to install Ucanaccess.

Under Lucee version 4, I did it with success, by adding/replacing Ucanaccess jar files in the lucee/lib directory (under Windows).
But now, in Lucee V5, there is only a single file : lucee-5.3.3.62.jar
in directory opt/lucee/lib (under Linux)
So where to place the Ucanaccess JAR files now ?

Thanks for help on Ucanaccess and Lucee 5
Pierre

In Lucee 5.3 you should see that a free Ucanaccess data source extension is available in the Administrator under Extension > Applications.

If you don’t see it then make sure you’ve got https://www.forgebox.io as an extension provider.

Here’s more detail about the extension (by Michael Born).

Thanks a lot for this Usefull information.
I found Ucanaccess extension in Lucee admin extensions/applications
not installed.

I did the installation, it proposed the version 0.8.3
Then, I found it in “installed extensions”

In datasource, I find “UCanAccess” in the driver list choice. Great.

When using datasource creation,
It seems that Lucee does not find the Ucanaccess driver: Error message is:

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 not found by lucee.core [46];java.lang.ClassNotFoundException:net.ucanaccess.jdbc.UcanaccessDriver;)

I tried, manually, by choosing : Other JDBC driver
And I put the Class : net.ucanaccess.jdbc.UcanaccessDriver
Then the mdb file path:
jdbc:ucanaccess:///var/www/site/database/mymdb.mdb

Then I got the same Error message than above.

It seems that The driver is not installed ? Lucce cannot find it.
Where should be located the directory with Ucanacces files ?

Thanks for your help.
I am very near to make it work, and that’s GREAT for me.

Pierre.

It shouldn’t be necessary with extensions but try restarting your Lucee instance.

Otherwise probably best to ask Michael, the extension author, if he can help:

https://bitbucket.org/michaelborn_me/ucanaccess/issues