AZURE SQL JDBC additional parameters

Highlighted
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=*.database.windows.net

 

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

Thanks in advance.

Moderator

Re: AZURE SQL JDBC additional parameters

Hello,

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

Sabrina

--
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>(JtdsConnection.java:436)   at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)   at java.sql.DriverManager.getConnection(DriverManager.java:664)   at java.sql.DriverManager.getConnection(DriverManager.java:247)   at importfromprod.set_globalvariables_0_1.Set_globalVariables.tMSSqlConnection_1Process(Set_globalVariables.java:3535)   at importfromprod.set_globalvariables_0_1.Set_globalVariables.runJobInTOS(Set_globalVariables.java:4926)   at importfromprod.set_globalvariables_0_1.Set_globalVariables.runJob(Set_globalVariables.java:4781)   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.tRunJob_1Process(Prod_to_Rater_Wrapper.java:479)   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.runJobInTOS(Prod_to_Rater_Wrapper.java:750)   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.main(Prod_to_Rater_Wrapper.java:598)  Caused by: java.net.SocketException: Connection reset   at java.net.SocketInputStream.read(SocketInputStream.java:210)   at java.net.SocketInputStream.read(SocketInputStream.java:141)   at net.sourceforge.jtds.ssl.TdsTlsInputStream.readFully(TdsTlsInputStream.java:131)   at net.sourceforge.jtds.ssl.TdsTlsInputStream.primeBuffer(TdsTlsInputStream.java:100)   at net.sourceforge.jtds.ssl.TdsTlsInputStream.read(TdsTlsInputStream.java:78)   at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)   at sun.security.ssl.InputRecord.read(InputRecord.java:503)   at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:983)   at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1385)   at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1413)   at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1397)   at net.sourceforge.jtds.ssl.SocketFactories$TdsTlsSocketFactory.createSocket(SocketFactories.java:101)   at net.sourceforge.jtds.jdbc.SharedSocket.enableEncryption(SharedSocket.java:330)  at net.sourceforge.jtds.jdbc.TdsCore.negotiateSSL(TdsCore.java:577)   at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:365)   ... 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(Prod_to_Rater_Wrapper.java:501)   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.runJobInTOS(Prod_to_Rater_Wrapper.java:750)   at importfromprod.prod_to_rater_wrapper_0_1.Prod_to_Rater_Wrapper.main(Prod_to_Rater_Wrapper.java:598)

 

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.

 

Thanks

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

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

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

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

Blog