[resolved] Connection reset on tOracleConnection

One Star

[resolved] Connection reset on tOracleConnection

Hello,
I'm using TOS 4.1.2 with Oracle 11g. (v 11.2.0.1.0)
I made a job with 2 tOracleConnection, each one with tOracleClose at the end of job.
When i run my job in Talend, i have no problem. When i try to run my job with shell script to do multiple launch, sometimes (2/3) i have this error :
java.sql.SQLRecoverableException: I/O Exception: Connection reset
I tried some things :
- Use tStatsCatcher to see that tOracleClose component was succesfull
- Add the -Djava.security.egd=file:///dev/urandom switch or file:/dev/./urandom
This problem seems to be random.
Thx for help.

Accepted Solutions
One Star

Re: [resolved] Connection reset on tOracleConnection

Many thanks noituac!
this was very helpful, as i had the same problem on a unix-machine (Debian). Though, I'd like to add a remark:
Changing the random number generator from random to urandom in the java.security file might not always work due to a bug in the Java-parser.
LINK: http://www.itonguard.com/20090313/weblogic-starts-slow/
In that case try using these paths instead:
securerandom.source=file:/dev/./urandom
OR
securerandom.source=file:/dev/../dev/urandom

All Replies
One Star

Re: [resolved] Connection reset on tOracleConnection

Here full stacktrace :
Exception in component tOracleConnection_1
java.sql.SQLRecoverableException: Exception d'E/S: Connection reset
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:521)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:418)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at java.sql.DriverManager.getConnection(DriverManager.java:620)
at java.sql.DriverManager.getConnection(DriverManager.java:169)
at project1.job1.JOB1.tOracleConnection_1Process(JOB1.java:2773)
at project1.job1.JOB1.tJava_1Process(JOB1.java:2694)
at project1.job1.JOB1.runJobInTOS(JOB1.java:3980)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at alma.ps2.tracabilite.batch.RunTalendJob.main(RunTalendJob.java:76)
Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at oracle.net.ns.DataPacket.send(DataPacket.java:150)
at oracle.net.ns.NetOutputStream.flush(NetOutputStream.java:180)
at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:169)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:117)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:92)
at oracle.net.ns.NetInputStream.read(NetInputStream.java:77)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1034)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:760)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
... 14 more
One Star

Re: [resolved] Connection reset on tOracleConnection

I solved my prob with use of urandom instead of random.
First try was bad, now it works.
http://download.oracle.com/docs/cd/E13209_01/wlcp/wlss31/configwlss/jvmrand.html
One Star

Re: [resolved] Connection reset on tOracleConnection

Many thanks noituac!
this was very helpful, as i had the same problem on a unix-machine (Debian). Though, I'd like to add a remark:
Changing the random number generator from random to urandom in the java.security file might not always work due to a bug in the Java-parser.
LINK: http://www.itonguard.com/20090313/weblogic-starts-slow/
In that case try using these paths instead:
securerandom.source=file:/dev/./urandom
OR
securerandom.source=file:/dev/../dev/urandom

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download