Error using Ucanaccess Driver installed in Lucee admin

#1

Error message is :
com/healthmarketscience/jackcess/util/ErrorHandler

I have installed Ucanaccess driver (ucanaccess-4.0.4.jar) Under Lucee 5.3
on Linux Debian 10 and Apache 2.4

Ucanacces driver have appeared in the datasource driver list.
(also, I can see Ucanacces files in the Lucee file structure, the jar, the lex)

When declaring a new datasource I can choose the Ucanacces driver in the driver list,
great, Then I create and get the datasource full form.
I give the mdb file (database file) address in the “database” field , like : /var/www/C006/database/cinema.mdb

I am wondering if this is the right place to point to the mdb file,
and the right path designation ?

Error is message :
com/healthmarketscience/jackcess/util/ErrorHandler

Thanks, if anybody can help me with this blocking factor using Lucee/Linux
instead Coldfusion/Windows.

I believe , this is a Ucanaccess/Lucee link problem.

Pierre.

datasource_ucanaccess
datasource_ucanaccess.jpg794×516 46.3 KB
datasource_error
datasource_error.jpg1030×566 72.4 KB

#2

Hi @Pierre_Larde the UcanAccess extension is maintained by a member of the community @michaelborn_me and not the Lucee dev team. I’ve pinged him so hopefully he can chime in and help.

#3

OK, thanks,
by the way, what means : in Info Bundle (jar)
"active or not loaded" , how to load a bundle ?
Is that done by application installation ?

See the screenshot I have, I should have a version problem.

Thanks for advise.
Pierre.

bundles_load_view
bundles_load_view.jpg1030×390 69.4 KB

#4

Can you click show details on the error page?

#5

Hey Pierre,
You seem to have found the root issue - Lucee doesn’t want to load the jackcess library, which is the main jar that adds Access database capability in this extension.

I’ve actually unpublished the extension for now, because I can replicate this issue and it’s keeping the extension from working at all.

Brad, do you have any clue on why Lucee would show the jar but set it to “not loaded”? Pierre’s screenshot is showing two versions of jackcess, one active and one not. When I test it after installing the extension, I only see a single version (3.0.1) and it is “not loaded”.

Also, Pierre, I haven’t tested using the Lucee admin UI for adding a datasource. For using the extension, you’ll need to manually create the datasource in code - see https://michaelborn.me/entry/creating-an-ms-access-lucee-extension#Using-the-UCanAccess-Lucee-Extension.

#6

there maybe two versions of the extension bundle under bundles?

I think the extension handling logic doesn’t always remove older versions…

#7

TBH, I don’t recall what the words on that screen mean. I know they had specific, OSGI-related meanings and Micha explained them to me, but I forget.