AZURE SQL JDBC additional parameters

Anonymous — Sat, 16 Nov 2024 05:07:09 GMT

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.

Re: AZURE SQL JDBC additional parameters

Anonymous — Mon, 05 Aug 2019 04:51:45 GMT

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

Re: AZURE SQL JDBC additional parameters

Anonymous — Mon, 05 Aug 2019 07:13:45 GMT

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

topic Re: AZURE SQL JDBC additional parameters in Talend Studio

AZURE SQL JDBC additional parameters

Re: AZURE SQL JDBC additional parameters

Re: AZURE SQL JDBC additional parameters