Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[statistics] connecting to socket on port 3629
[statistics] connected
Exception in component tOracleInput_7 (tcomp1)
java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tOracleInput_7Process(DCACS_ACCMS_ATTORNEY.java:4648)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tFixedFlowInput_1Process(DCACS_ACCMS_ATTORNEY.java:2191)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tJava_6Process(DCACS_ACCMS_ATTORNEY.java:1738)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.runJobInTOS(DCACS_ACCMS_ATTORNEY.java:15576)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.main(DCACS_ACCMS_ATTORNEY.java:14954)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:210)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
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:975)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)
at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:750)
at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
at oracle.net.ns.Packet.send(Packet.java:419)
at oracle.net.ns.ConnectPacket.send(ConnectPacket.java:241)
at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:151)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:263)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)
... 11 more
[FATAL]: projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY - tOracleInput_7 IO Error: Connection reset
java.sql.SQLRecoverableException: IO Error: Connection reset
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:682)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tOracleInput_7Process(DCACS_ACCMS_ATTORNEY.java:4648)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tFixedFlowInput_1Process(DCACS_ACCMS_ATTORNEY.java:2191)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.tJava_6Process(DCACS_ACCMS_ATTORNEY.java:1738)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.runJobInTOS(DCACS_ACCMS_ATTORNEY.java:15576)
at projects_bip_dcacs.dcacs_accms_attorney_1_0.DCACS_ACCMS_ATTORNEY.main(DCACS_ACCMS_ATTORNEY.java:14954)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:210)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
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:975)
at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)
at sun.security.ssl.SSLSocketImpl.writeRecord(SSLSocketImpl.java:750)
at sun.security.ssl.AppOutputStream.write(AppOutputStream.java:123)
at oracle.net.ns.Packet.send(Packet.java:419)
at oracle.net.ns.ConnectPacket.send(ConnectPacket.java:241)
at oracle.net.ns.NSProtocolStream.negotiateConnection(NSProtocolStream.java:151)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:263)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)
... 11 more
DCACS_ACCMS_ATTORNEY - IO Error: Connection reset
2022-09-15 17:09:32|It88tc|It88tc|It88tc|PROJECTS_BIP_DCACS|DCACS_ACCMS_ATTORNEY|Default|6|Java Exception|tOracleInput_7|java.sql.SQLRecoverableException:IO Error: Connection reset|1
*** display from tJavaRow_2 ***
- Error in Talend component: tOracleInput_7
- Error Message: java.sql.SQLRecoverableException:IO Error: Connection reset
[statistics] disconnected
Job DCACS_ACCMS_ATTORNEY ended at 17:09 15/09/2022. [Exit code = 0]
Hello,
Talend has added support for Oracle 19c since 7.3.1. What's TAC version are you using?
Here is online documentation about:
https://help.talend.com/r/en-US/8.0/installation-guide-data-integration-windows/compatible-databases
Best regards
Sabrina
I'm especially stayed aware of the article and I will get many benefits from it. Subsequently, thank you for sharing it.
Hello,
Feel free to let us know if there is any further help we can give.
Best regards
Sabrina