Forum Discussion
jdbc connector receives TCP/IP error against the warehouse
should I open a feature request or a bug somewhere? currently is shows in the docs like jdbc is a available
https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity#connect-using-jdbc
Microsoft EmployeeI'd open a support ticket and ask the support engineer to raise an "ICM" so he/she can get in touch with the Fabric Software Engineer that wrote this, my guess is, that Software Engineer didn't test in Azure Synapse or other Azure Compute.
- mdrakiburrahman
benor1470 I was able to solve the problem.
Old JDBC drivers don't work with Fabric because the Fabric Proxy forces Redirect mode, you need to use the latest JDC drivers wherever you are running your code.
In case of Synapse, even though I was using the latest Driver, Synapse CLASSPATH overrides what the user passes in their JAR. Shading your JAR solves the problem and it works.
Please use this version:
Shade your spark-submit JAR:
Works fine in Synapse:
Thank you but anfortunatly it's not this
I'm using https://mvnrepository.com/artifact/com.microsoft.sqlserver/mssql-jdbc/12.8.1.jre11 and https://mvnrepository.com/artifact/com.microsoft.azure/msal4j/1.17.0 and I don't have a any shaded jars as I load my drives using extral class loader and I don't use spark or Synapse
I can create a new project that just shows this issue, could you look at it?