topic [resolved] Connection reset on tOracleConnection in Talend Studio

[resolved] Connection reset on tOracleConnection

Anonymous — Sat, 16 Nov 2024 12:40:36 GMT

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.

Re: [resolved] Connection reset on tOracleConnection

Anonymous — Tue, 20 Sep 2011 16:06:25 GMT

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

Re: [resolved] Connection reset on tOracleConnection

Anonymous — Wed, 21 Sep 2011 14:43:47 GMT

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

Re: [resolved] Connection reset on tOracleConnection

Anonymous — Tue, 20 Dec 2011 16:26:45 GMT

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