Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
That's right, I already did a installation of the driver in the TomCat home dir and it is working.
/usr/local/qdc/apache-tomcat-v.r.nn/lib/
The steps that worked for us were
1. Download the mssql JDBC connector from microsoft's page
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.
That is exactly what we did and it worked. Thank you for the detailed description.
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.
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