I have an unfortunate need to use an Access DB with Lucee as a once off. I have followed through others posts in the forums to get the UCanAccess driver installed on Lucee 5. I am able to get the Lucee administrator to add a datasource, having set the appropriate UCANACCESS_HOME environment variable, however once added, any atttempt to use the datasource results in a NPE within Lucee’s DCStack.java
I am wondering if this has anything to do with just adding the UCanAccess JARs to the lucee/lib folder rather than using an OSGI packaged bundle. Can anyone advise if JARS for JDBC drivers can just be added to the lucee/lib folder or if something special needs to be done for this.
Has anyone successfully got UCanAccess running with Lucee 5, and do you have any war stories to share?
Exception after adding the datasource or attempting to use the datasource in a query
Stacktrace The Error Occurred in /admin/services.datasource.list.cfm: line 142 called from /admin/services.datasource.cfm: line 82 called from /admin/web.cfm: line 399
Java Stacktrace lucee.runtime.exp.NativeException: java.lang.NullPointerException at lucee.runtime.db.DCStack.openConnectionsIn(DCStack.java:104) at lucee.runtime.db.DCStack.openConnections(DCStack.java:117) at lucee.runtime.db.DatasourceConnectionPool.openConnections(DatasourceConnectionPool.java:272) at lucee.runtime.db.DatasourceConnectionPool.openConnections(DatasourceConnectionPool.java:280) at lucee.runtime.tag.Admin.doGetDatasources(Admin.java:4398) at lucee.runtime.tag.Admin._doStartTag(Admin.java:590) at lucee.runtime.tag.Admin.doStartTag(Admin.java:339) at services_datasource_list_cfm1334$cf.call(/admin/services.datasource.list.cfm:142)
The datasource is created successfully in lucee-web.xml.cfm, but once added I have to manually remove the entry and restart to be able to use the Lucee administrator datasource page due to the above stack trace.
<data-source allow="511" blob="false" class="net.ucanaccess.jdbc.UcanaccessDriver" clob="false" connectionLimit="1" connectionTimeout="1" custom="" database="mydb" dbdriver="Other" dsn="jdbc:ucanaccess:/Users/phil/dev/ucanaccess/database/mydb.mdb" host="" metaCacheTimeout="60000" name="mydb" param-delimiter="&" param-leading-delimiter="?" param-separator="=" password="" port="-1" storage="false" username="" validate="false"/>