AZURE SQL JDBC additional parameters

Five Stars

AZURE SQL JDBC additional parameters

Hi everyone,

Updating my original post.

My Talend 6.2.1 job is pulling out data from one AZURE SQL Database and inserting it into another.

Since 29th July 2019, this job is throwing error CONNECTION RESET/CONNECTION CLOSED.

We analyzed that the issue is with connectivity with AZURE SQL Database. The connection is closed while the job is trying to pull data from a database.

Additional parameters we used are: encrypt=true;hostNameInCertificate=*


Please let me know which additional parameters to be used to avoid this closed connection.

Thanks in advance.


Re: AZURE SQL JDBC additional parameters


Did you use any tMSSQLConnection component in your work flow?

tPreJob -> -->mssqlconnection

than all other:

Fileinput----------------> tmssqloutput------------>Mssqlcommit.

tPostJob ----> tMSSQLClose

You try to insert data before define connection and change batch size from advanced settings in tmssqloutput.

Let us know if it works.

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: AZURE SQL JDBC additional parameters

Hi Sabrina,

Thanks for the reply. 

These workflows are in place since 2017. They are created in a fashion just like you specified in your reply.

Each job of this workflow starts with connection open  -> transformation and load -> connection commit/close.

No modification has been done on this workflow and these all worked fine till 26th July.


But since 29th July 2019, when the workflow starts, it gives the following error:

Message : <module> : Job Failed : Exception in component tMSSqlConnection_1  java.sql.SQLException: Network error IOException: Connection reset  at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(   at net.sourceforge.jtds.jdbc.Driver.connect(   at java.sql.DriverManager.getConnection(   at java.sql.DriverManager.getConnection(   at importfromprod.set_globalvariables_0_1.Set_globalVariables.tMSSqlConnection_1Process(   at importfromprod.set_globalvariables_0_1.Set_globalVariables.runJobInTOS(   at importfromprod.set_globalvariables_0_1.Set_globalVariables.runJob(   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.tRunJob_1Process(   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.runJobInTOS(   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.main(  Caused by: Connection reset   at   at   at net.sourceforge.jtds.ssl.TdsTlsInputStream.readFully(   at net.sourceforge.jtds.ssl.TdsTlsInputStream.primeBuffer(   at   at   at   at   at   at   at   at net.sourceforge.jtds.ssl.SocketFactories$TdsTlsSocketFactory.createSocket(   at net.sourceforge.jtds.jdbc.SharedSocket.enableEncryption(  at net.sourceforge.jtds.jdbc.TdsCore.negotiateSSL(   at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(   ... 9 more  Exception in component tRunJob_1  java.lang.RuntimeException: Child job running failed   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.tRunJob_1Process(   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.runJobInTOS(   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.main(


Please help me as these workflows are crucial and I am still struggling to find out the root cause of this error and finding its solution.




Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables


Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables


Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema