Apache Airflow can not connect to mssql 2008

[#1]

Hi team,

I update airflow to v2.6.3, and find I can't connect to mssql 2008 by using JDBC.

Following are my setting：

• Docker Desktop：v4.19.0
• airflow：v2.6.3
• JAVA：openjdk-11-jdk
• JDBC Driver：jtds-1.3.1.jar
• Connection URL：jdbc:jtds:sqlserver://xxx.xxx.xx.xx:1433/xxxx
• Driver Path：/usr/local/airflow/jars/jtds-1.3.1.jar
• Driver Class：net.sourceforge.jtds.jdbc.Driver
  

The connection was failed.

 

I wonder why the message show the connection string as below：

jdbc://jdbc:jtds:sqlserver:

why not only

jdbc:jtds:sqlserver:

Any help will be appreciated, thanks!

[#2 · Accepted solution]

Hello @mandychen 

Thanks for using Cloudera Community. This is an Old Post, yet Wish to convey that Cloudera shall assist with Airflow Issues (Install, Upgrade, Maintenance) dealing with Airflow shipped by Cloudera. Currently, CDE (Cloudera Data Engineering) allows Airflow to be deployed on Public Cloud & Private Cloud with End-To-End Support offered by Cloudera.

Your Post deals with reviewing an Issue with Installing Standalone Airflow, which isn't Supported per-se. Henceforth, our engagement would be Limited. However, the Issue is likely linked with JDBC Parsing as discussed in [1].

If your Team is interested in CDE Airflow, Let us know & we can get in touch with your Team. 

- Smarak

[1] https://github.com/apache/airflow/issues/33442