Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Driver class not found with latest MSSQL extension

Description

I'm trying to upgrade my SQL Server driver.
Using https://ext.lucee.org/org.lucee.mssql-7.4.1.jre8.lex, my app works fine.
Using https://ext.lucee.org/org.lucee.mssql-8.4.1.jre8.lex, I get an error:

lucee.commons.lang.ClassException: cannot load class through its string name, because no definition for the class with the specified name [com.microsoft.sqlserver.jdbc.SQLServerDriver] could be found caused by (java.lang.ClassNotFoundException:com.microsoft.sqlserver.jdbc.SQLServerDriver;java.lang.ClassNotFoundException:com.microsoft.sqlserver.jdbc.SQLServerDriver not found by lucee.core [48];

Environment

Docker image: lucee:5.3.8.206-light-tomcat9.0-jdk8-openjdk

Activity

Show:

Pothys - MitrahSoft 10 February 2022 at 12:35

I've checked this ticket and confirmed the issue happened with using a lucee-light jar. Deploying the mssql-8.4.1 lex file in lucee-server/deploy folder doesn't get installed and logs the error in deploy.log. Using mssql datasource throws the error ClassNotFoundException.

Stacktrace from Deploy.log

main","02/10/2022","17:40:42","Extension","Unable to resolve org.lucee.mssql [50](R 50.0): missing requirement [org.lucee.mssql [50](R 50.0)] osgi.wiring.package; (osgi.wiring.package=org.bouncycastle.jce.provider) Unresolved requirements: [[org.lucee.mssql [50](R 50.0)] osgi.wiring.package; (osgi.wiring.package=org.bouncycastle.jce.provider)];lucee.runtime.exp.NativeException: Unable to resolve org.lucee.mssql [50](R 50.0): missing requirement [org.lucee.mssql [50](R 50.0)] osgi.wiring.package; (osgi.wiring.package=org.bouncycastle.jce.provider) Unresolved requirements: [[org.lucee.mssql [50](R 50.0)] osgi.wiring.package; (osgi.wiring.package=org.bouncycastle.jce.provider)] at org.apache.felix.framework.Felix.resolveBundleRevision(Felix.java:4368) at org.apache.felix.framework.Felix.startBundle(Felix.java:2281) at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:998) at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:984) at lucee.loader.osgi.BundleUtil.start(BundleUtil.java:112) at lucee.loader.osgi.BundleUtil.start(BundleUtil.java:108) at lucee.runtime.osgi.OSGiUtil._start(OSGiUtil.java:1216) at lucee.runtime.osgi.OSGiUtil._startIfNecessary(OSGiUtil.java:1169) at lucee.runtime.osgi.OSGiUtil.startIfNecessary(OSGiUtil.java:1164) at lucee.runtime.osgi.OSGiUtil._loadBundle(OSGiUtil.java:540) at lucee.runtime.osgi.OSGiUtil.loadBundle(OSGiUtil.java:492) at lucee.commons.lang.ClassUtil.loadClassByBundle(ClassUtil.java:155) at lucee.transformer.library.ClassDefinitionImpl.getClazz(ClassDefinitionImpl.java:110) at lucee.runtime.config.XMLConfigAdmin.setClass(XMLConfigAdmin.java:6611) at lucee.runtime.config.XMLConfigAdmin._updateJDBCDriver(XMLConfigAdmin.java:1799) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:5003) at lucee.runtime.config.XMLConfigAdmin.updateRHExtension(XMLConfigAdmin.java:4692) at lucee.runtime.config.XMLConfigAdmin._updateRHExtension(XMLConfigAdmin.java:4674) at lucee.runtime.config.DeployHandler.deploy(DeployHandler.java:88)
Duplicate

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Affects versions

Created 20 December 2021 at 16:19
Updated 10 February 2022 at 21:06
Resolved 10 February 2022 at 21:06

Flag notifications