Talend -Oracle SSL connection : Metadata DB connection working but Talend job Failing when using the same connection - Talend 7.3.1

PS1653481830 — Fri, 15 Nov 2024 22:53:10 GMT

Hi All,

Hope you are doing fine.

I need some help for connectivity setup/issues which I am facing currently.

I am trying to use SSL connection to connect Talend to Oracle-19 Database.

I created one Database connection in Metadata and the SSL connection to Oracle using port 2484 working as attached. I am using Oracle ssl_wallet to configure the connection.

However when I am trying to call a Talend job with that connection, the Job is failing and showing error as attached.

I am able to connect to Oracle DB through command line from D4D.I am using Amazon D4D (desktop for Developer) Linux box and remote connection to Talend.

In my d4dbelow java version is available:

[COLUMBUS\u.xxxxx@a-kexxxx]$ java -version

java version "1.8.0_77"

Java(TM) SE Runtime Environment (build 1.8.0_77-b03)

Java HotSpot(TM) 64-Bit Server VM (build 25.77-b03, mixed mode)

Any help /pointer appreciated.

Some Error from Job:

Starting job Read_Orace_records_2484Port at 13:07 25/05/2022.

[statistics] connecting to socket on port 4039

[statistics] connected

Exception in component tDBConnection_1 (Read_Orace_records_2484Port)

[FATAL] 13:07:32 mdr_dev001.read_orace_records_2484port_0_1.Read_Orace_records_2484Port- tDBConnection_1 IO Error: The Network Adapter could not establish the connection

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_202]

at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[?:1.8.0_202]

at mdr_dev001.read_orace_records_2484port_0_1.Read_Orace_records_2484Port.tDBConnection_1Process(Read_Orace_records_2484Port.java:497) [classes/:?]

at mdr_dev001.read_orace_records_2484port_0_1.Read_Orace_records_2484Port.runJobInTOS(Read_Orace_records_2484Port.java:1835) [classes/:?]

at mdr_dev001.read_orace_records_2484port_0_1.Read_Orace_records_2484Port.main(Read_Orace_records_2484Port.java:1617) [classes/:?]

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:571) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:548) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:309) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

... 9 more

Caused by: oracle.net.ns.NetException: Unable to initialize ssl context.

at oracle.net.nt.CustomSSLSocketFactory.createSSLContext(CustomSSLSocketFactory.java:346) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.net.nt.CustomSSLSocketFactory.getSSLContext(CustomSSLSocketFactory.java:307) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.net.nt.CustomSSLSocketFactory.getSSLSocketEngine(CustomSSLSocketFactory.java:273) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

at oracle.net.nt.TcpsNTAdapter.connect(TcpsNTAdapter.java:174) ~[ojdbc8-19.3.0.0.jar:19.3.0.0.0]

Regards

Re: Talend -Oracle SSL connection : Metadata DB connection working but Talend job Failing when using the same connection - Talend 7.3.1

Anonymous — Tue, 28 Jun 2022 10:03:02 GMT

Hello,

Here exists the related jira issue:

https://jira.talendforge.org/browse/TDI-46913

Best regards

Sabrina

topic Talend -Oracle SSL connection : Metadata DB connection working but Talend job Failing when using the same connection - Talend 7.3.1 in Talend Studio

Talend -Oracle SSL connection : Metadata DB connection working but Talend job Failing when using the same connection - Talend 7.3.1

Re: Talend -Oracle SSL connection : Metadata DB connection working but Talend job Failing when using the same connection - Talend 7.3.1