topic Re: QDC and JDBC error after click on Test Connection in Catalog and Lineage

QDC and JDBC error after click on Test Connection

jochem_zw — Tue, 07 Dec 2021 22:35:04 GMT

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?

Re: QDC and JDBC error after click on Test Connection

ThiebaudS — Mon, 04 Nov 2019 08:06:20 GMT

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

Re: QDC and JDBC error after click on Test Connection

jochem_zw — Mon, 04 Nov 2019 08:09:55 GMT

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

Re: QDC and JDBC error after click on Test Connection

steffan_holmquist — Wed, 13 Nov 2019 17:35:46 GMT

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

Re: QDC and JDBC error after click on Test Connection

Dan-Kenobi — Wed, 13 Nov 2019 17:54:10 GMT

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=sql-server-ver15

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.

Re: QDC and JDBC error after click on Test Connection

steffan_holmquist — Wed, 13 Nov 2019 17:56:41 GMT

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

Re: QDC and JDBC error after click on Test Connection

maksim_senin — Mon, 05 Apr 2021 10:23:57 GMT

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.

Re: QDC and JDBC error after click on Test Connection

jamshed07 — Mon, 14 Jun 2021 10:23:49 GMT

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