Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
JCC1
Contributor II
Contributor II

Issue with integrating Oracle 19c with TAC

[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]

Labels (2)
3 Replies
Anonymous
Not applicable

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

 

PWunsch_1653032151
Contributor
Contributor

I'm especially stayed aware of the article and I will get many benefits from it. Subsequently, thank you for sharing it.

 

 

Anonymous
Not applicable

Hello,

Feel free to let us know if there is any further help we can give.

Best regards

Sabrina