How to use an Oracle Wallet with Talend Studio (R2025-11)

[MoisesQN]

Hi everyone, I'm trying to connect Talend Studio  (R2025-11) to a Oracle Cloud Database, but I get the next error message. I try from several options but all times i get error message.

Exception in component tDBConnection_1 (job_Inventarios)

java.sql.SQLRecoverableException: Error de E/S: Connection reset, Authentication lapse 0 ms.

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:923)

at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:820)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:80)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:816)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:620)

at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:681)

at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:190)

at banobras.job_inventarios_0_1.job_Inventarios.tDBConnection_1Process(job_Inventarios.java:575)

at banobras.job_inventarios_0_1.job_Inventarios.runJobInTOS(job_Inventarios.java:1300)

at banobras.job_inventarios_0_1.job_Inventarios.main(job_Inventarios.java:936)

Caused by: java.io.IOException: Connection reset, Authentication lapse 0 ms.

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:919)

... 9 more

Caused by: java.net.SocketException: Connection reset

at java.base/sun.nio.ch.SocketChannelImpl.throwConnectionReset(SocketChannelImpl.java:394)

at java.base/sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:426)

at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:187)

at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:676)

at oracle.net.ns.NIOPacket.readNIOPacket(NIOPacket.java:408)

at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:143)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:353)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1702)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:627)

... 9 more

[FATAL] 12:45:33 banobras.job_inventarios_0_1.job_Inventarios- tDBConnection_1 Error de E/S: Connection reset, Authentication lapse 0 ms.

[david_lucas]

As far as  I can see, studio can connect to your orable cloud server: 

java.sql.SQLRecoverableException: Error de E/S: Connection reset, Authentication lapse 0 ms.

Can you try t connect to the db with another db client, like dbeaver ? 

[MoisesQN]

Hi, thanks for you answer. I try to connect using DBeaver and I get this message: "ORA-12506:TNS:el listener ha rechazado la conexión según el filtrado ACL del servicio" .