topic Re: Network error IOException: Connection timed out (Connection timed out) java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out) in Talend Studio

Network error IOException: Connection timed out (Connection timed out) java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)

rohit1804 — Fri, 15 Nov 2024 21:55:47 GMT

I am trying to connect Microsoft SQL Server via Linux Server I am getting below error:

Where as when I am connecting to same Microsoft SQL server via local studio its working as expected, also when I trying connect to it via different Linux server it working

Can you please help me

Below is the error:

tDBConnection_2 Network error IOException: Connection timed out (Connection timed out)

java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)

@AT net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436) ~[jtds-1.3.1-patch-20190523.jar:?]

@AT net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184) ~[jtds-1.3.1-patch-20190523.jar:?]

@AT java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]

@AT java.sql.DriverManager.getConnection(DriverManager.java:228) ~[java.sql:?]

@AT coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tDBConnection_2Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:1566) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@AT coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tJava_1Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:1387) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@AT coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tOracleConnection_1Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:1164) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@AT coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tJava_7Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:4367) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@AT coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.tJava_5Process(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:4140) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@AT coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.runJobInTOS(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:5344) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

@AT coda_project_common.temp_coda_stg_resolveit_ordertech_0_1.TEMP_CODA_STG_RESOLVEIT_ORDERTECH.main(TEMP_CODA_STG_RESOLVEIT_ORDERTECH.java:4715) [temp_coda_stg_resolveit_ordertech_0_1.jar:?]

Caused by: java.net.ConnectException: Connection timed out (Connection timed out)

@AT java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:?]

@AT java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412) ~[?:?]

@AT java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255) ~[?:?]

@AT java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237) ~[?:?]

@AT java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:?]

@AT java.net.Socket.connect(Socket.java:608) ~[?:?]

@AT net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288) ~[jtds-1.3.1-patch-20190523.jar:?]

@AT net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251) ~[jtds-1.3.1-patch-20190523.jar:?]

@AT net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331) ~[jtds-1.3.1-patch-20190523.jar:?]

Re: Network error IOException: Connection timed out (Connection timed out) java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)

Anonymous — Tue, 04 Apr 2023 10:09:00 GMT

Hello @rohit bannagare ,

Regarding to the error log, the problem is that the linux server can't connect to the sqlserver due to network issue.

Could you please try to check the firewall of sqlserver to allow the access of the linux server?

Best regards

Aiming

Re: Network error IOException: Connection timed out (Connection timed out) java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)

rohit1804 — Tue, 04 Apr 2023 10:10:51 GMT

@Aiming Chen

How to check Firewall of Sql Server ?

Re: Network error IOException: Connection timed out (Connection timed out) java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)

jlolling_kloeckner — Wed, 05 Apr 2023 14:12:29 GMT

It is really so hard to understand that we have here different forums for different purposes?

This current forum is for ANNOUNCMENTS and NOT for technical questions!

Please do not spread your questions without thinking!

Re: Network error IOException: Connection timed out (Connection timed out) java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)

Anonymous — Thu, 06 Apr 2023 01:06:52 GMT

Hello @rohit bannagare ,

Please check with your IT about the firewall issue, thanks

Re: Network error IOException: Connection timed out (Connection timed out) java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)

Anonymous — Mon, 10 Apr 2023 03:28:44 GMT

Hello,

Moved this topic to Design and Development board.

Best regards

Sabrina