Databricks

MichelSmits · 05-07-2023

We run a dbx job that uses a jdbc connection to three (SQL Server) on-prem databases. Very occasionally a connection will go to the wrong server.In the job log we see the error "com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '...

MichelSmits · 05-22-2023

Hi Suteja,Unfortunately this change did not solve the problem. Looking at the exception and stack trace it looks to be the exact same code, so:spark.read.format("jdbc")andspark.read.format('sqlserver')are actually the same.The "solution" we have now,...

MichelSmits · 05-21-2023

Hi Suteja,Thanks for the lengthy reply. We also think it's some kind of race condition.As to your points...We're not sure how to influence 1/2 since they are part of the Databricks environment.Also, we're not convinced how 4/5/6 will help since the p...

Databricks

User Stats

User Activity

Connection to on-prem database occasionally goes to the wrong server

Re: Connection to on-prem database occasionally goes to the wrong server

Re: Connection to on-prem database occasionally goes to the wrong server