RetryError: RetryError[<Future at 0x7f735f4aceb0 state=finished raised com.microsoft.sqlserver.jdbc.SQLServerException>]

Question

We are inserting data into a table in Azure SQL DB from Azure Databricks. On that function, we have applied @retry in order to retry execution after waiting for some time in case of any exception. This function sometimes fails and gives an exception given below:

com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Unexpected rethrowing".

It's an intermittent issue. Can anyone please let me know the cause of it and what can be the possible solution?

Answer 1

Hi,

Make sure that you are enforcing sslProtocol=TLSv1.2; in the database connection string.

Check this thread for another discussion on the subject:

https://github.com/Microsoft/mssql-jdbc/issues/879