QDC and JDBC error after click on Test Connection

[jochem_zw]

core.error.code.DYNAMIC_CLASS_LOAD_FAILURE - Failed to dynamically load driver and connect : com.microsoft.sqlserver.jdbc.SQLServerDriver

this is my connection string:

jdbc:sqlserver://<HOST>.database.windows.net:1433;database=TestDB

Any idea what's is going wrong and how to fix this?

[ThiebaudS · Accepted solution]

Hi,

It's not because database drivers are listed in Admin>Database Drivers that there are actually installed.

You need to download and install the JDBC driver for mssql.

Best regards,

Thiebaud

[jochem_zw]

That's right, I already did a installation of the driver in the TomCat home dir and it is working.

[steffan_holmquist]

/usr/local/qdc/apache-tomcat-v.r.nn/lib/

[Dan-Kenobi]

The steps that worked for us were

1. Download the mssql JDBC connector from microsoft's page

https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view...

We got the Microsoft JDBC Driver 7.4 (JRE 8, 11, 12) - download the *tar.gz*, NOT the exe

2. Unzip the driver. You should get a file named mssql-jdbc-7.4.1.jre8.jar among others. copy this one to the TOMCAT_HOME/lib folder

in our case it was: 
# cp mssql-jdbc-7.4.1.jre8.jar /usr/local/qdc/apache-tomcat-7.0.94/lib/

3. With the file copied, shutdown and then start tomcat (don't simply "restart" it. Do this two-step procedure)

Test again from the Catalyst UI. It should work fine now.

[steffan_holmquist]

That is exactly what we did and it worked.  Thank you for the detailed description.

[maksim_senin]

Hi all,

For whom it may be useful - I have been struggling whit this error for 2+ hours and finaly managed by only use of SQL Server native user instead of AD one... so, if you use domain users just consider this choice.

[jamshed07]

thank you very much this solution worked for me too. Install mssql-jdbc-9.2.1.jre8.jar 

cp -R /tmp/mssql-jdbc-9.2.1.jre8.jar /usr/local/qdc/apache-tomcat-9.0.38/lib/

Start Tomcat manually
(qdc) $ cd <tomcat home>
$ ./bin/startup.sh

Tomcat can be manually stopped at any time
(qdc) # cd <tomcat home>
(qdc) # ./bin/shutdown.sh