I’m a new lucee user (old time cf user) trying to add the UCanAccess driver to my Windows 11 desktop install. While I have ForgeBox listed as an extension provider, UCanAccess does NOT appear as a “Not Installed” extension. Any tips on how to get it to appear in my “Not Installed” list? Or perhaps finding it with some other provider?
Solved problem on my own.
- Downloaded UCanAccess-5.0.1.bin.zip from sourceforge.net
- Opened zip and extracted files as follows:
This was in root dir of zip; I installed under /lucee/lib:
ucanaccess-5.0.1.jar
These were found in the zip’s /lib subdir: I installed in /lucee/lib:
commons-lang3-3.8.1.jar
commons-logging-1.2.jar
hsqldb-2.5.0.jar
jackcess-3.0.1.jar
and from a the “loader” subdir, I added this jar to the /lucee/lib folder
ucanload.jar
Under /lucee/tomcat/bin, I created the setenv.sh file and added two lines:
UCANACCESS_HOME=/opt/lucee/lib
export UCANACCESS_HOME
Stopped lucee service and restarted.
Created datasource using Other JDBC driver
used:
JDBC Driver Class: net.ucanaccess.jdbc.UcanaccessDriver
Connection String: jdbc:ucanaccess:///path/to/your/database.mdb
Works!
1 Like