talendMeter_DB Firewall Timeout Stats & Logs and Oracle SID connection

Anonymous — Sat, 16 Nov 2024 13:23:31 GMT

Hi,
I have a problem with a firewall timeout when I run a long job using these stats & logs parameters (screenshot) in the job setting, with an Oracle with SID Connection (JDBC Thin).
There is a firewall between the server running talend job and the server with my Oracle Database.
When the job is too long (more than one hour), the firewall break the connection with the database where I log any Talend events (stats & logs job setting).
To keep my connection alive, I have already add these parameters on the Talend running job server :
In the SQLNET.ORA files : SQLNET.EXPIRE_TIME=1
In the TNSNAMES.ORA files : ENABLE=BROKEN parameter in the DESCRIPTION clause in the connect descriptor
In Talend, in the Additional parameters textbox, in Stat & Logs, I try to use this setting : ?tcp_keepalive_interval=240000? (screenshot)
But that doesn?t work.
I got this error (with or without the tcp_keepalive_interval parameter) :
Exception in component talendMeter_DB
java.sql.SQLException: Exception d'E/S: Connection reset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:255)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPrepare
dStatement.java:826)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStateme
nt.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPrepa
redStatement.java:850)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1134)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePrepare
dStatement.java:3384)
at oracle.jdbc.OracleDatabaseMetaData.getTables(OracleDatabaseMetaData.j
ava:2472)
?
Connexion interrompueException in component tRunJob_1
Talend Open Studio Version : 4.01
Oracle Database v10.g
OS of the Talend running job server : Windows Server 2003 R2 32 Bits
Could you help me to find a solution, maybe using additional parameters in Talend, or anything else. I don?t know how this parameters ?tcp_keepalive_interval=240000? can be used with Talend Oracle with SID connection. Or if an external solution may be used ?
Thanks in advance.

topic talendMeter_DB Firewall Timeout Stats & Logs and Oracle SID connection in Talend Studio

talendMeter_DB Firewall Timeout Stats & Logs and Oracle SID connection