Creating Datasource in server admin for MSSQL failing

dev support
1

New install of LUCEE (see details below) and getting this:

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 not found by lucee.core [46];java.lang.ClassNotFoundException:com.microsoft.sqlserver.jdbc.SQLServerDriver;)

In extensions - Applications I see Microsoft SQL Server… but cannot install it.
I tried version 9.3.1 then the last jre8 (7.2.2 jre)
This is what I get when trying to add the application:

Unable to resolve com.microsoft.sqlserver.mssql-jdbc [64](R 64.0): missing requirement [com.microsoft.sqlserver.mssql-jdbc [64](R 64.0)] osgi.wiring.package; (&(osgi.wiring.package=org.osgi.framework)(version>=1.8.0)(!(version>=2.0.0))) Unresolved requirements: [[com.microsoft.sqlserver.mssql-jdbc [64](R 64.0)] osgi.wiring.package; (&(osgi.wiring.package=org.osgi.framework)(version>=1.8.0)(!(version>=2.0.0)))]

Is this an easy fix… or should I re-build the OS and try again?

OS: Windows Server 2016
Java Version: 11.0.7 (AdoptOpenJDK) 64bit
Tomcat Version: Apache Tomcat/9.0.35
Lucee Version: Lucee 5.3.7.48

1 Like
2

@BKW I’ve filed a bug LDEV-3492 MSSQL version 9.3.1 shows the error in application page.. The same error shows for all the versions above the 7.2.2 jre 8. MSSQL extension 7.2.2 jre 8 is the last working version.

Restart admin and install 7.2.2 jre 8 works.

2 Likes
3

That is worked!!!

Thank you so very much for the information!

3 Likes