Skip to main content

Catalog and Lineage

Discussion Board for collaboration around Catalog and Lineage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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