Terri Babcock - 2022-05-25

My project is updating to ColdFusion 2018 and uses Hibernate and obviously has Access databases (planning to migrate to SQL in the future). We have installed the UCanAccess driver and configured our data sources in the ColdFusion Administrator to use the driver. Now we need to get the UCanAccess dialect working. No one in the group has Java development experience so we are learning as we go. We have compiled the UCanAccessDialect.java file but where do we go from here? We created a jar file containing the UCanAccessDialect.class. We have tried putting this jar file in the /ColdFusion2018/cfusion/lib folder where the Hibernate jar files reside. We have tried putting the jar file in the /wwwroot/WEB-INF/classes folder and the /wwwroot/WEB-INF/lib folder and have set the ColdFusion Class Path in the administrator. We've set the dialect in the ColdFusion Application.cfc to be net.ucanaccess.hibernate.dialect. When we try to run our application we get an error with a stack trace and the error to note is :

Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
caused by:
org.hibernate.boot.registry.selector.spi.StrategySelectionException: Unable to resolve name [net.ucanaccess.hibernate.dialect.UCanAccessDialect] as strategy [org.hibernate.dialect.Dialect]

Any help/thoughts/ideas would be greatly appreciated.