Skip to main content

Catalog and Lineage

Discussion Board for collaboration around Catalog and Lineage.

Announcements
Feb 9th, Qlik Product Portfolio Strategy and Roadmap Webinar for Data Integration, last chance to REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jochem_zw
Partner - Creator III
Partner - Creator III

QDC and JDBC error after click on Test Connection

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?

 

Labels (1)
1 Solution

Accepted Solutions
ThiebaudS
Partner - Creator II
Partner - Creator II

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

View solution in original post

7 Replies
ThiebaudS
Partner - Creator II
Partner - Creator II

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
Partner - Creator III
Partner - Creator III
Author

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

 

steffan_holmquist
Partner - Contributor II
Partner - Contributor II

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

Dan-Kenobi
Partner - Contributor III
Partner - Contributor III

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
Partner - Contributor II
Partner - Contributor II

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

maksim_senin
Partner - Creator III
Partner - Creator III

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
Partner - Contributor III
Partner - Contributor III

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