tOracleInput Random Failed Connection

chichibio — Thu, 03 Nov 2016 11:19:49 GMT

Hi,

I need import data from table on db oracle to mysql db.
I have problem only on component tOracleInput about connection on Oracle:

Exception in component tOracleInput_1
java.sql.SQLRecoverableException: Io exception: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:458)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:411)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:490)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:202)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:465)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)

If I try again one or more times, it work well.
I know that the problem is my network. The connection is Oracle with Service Name version Oracle11.

I would try again execute the component tOracleInput (like on error try again). How I can do it?

thanx at all

Re: tOracleInput Random Failed Connection

Anonymous — Fri, 04 Nov 2016 03:22:22 GMT

Hi,
Here is a component TalendHelpCenter:tInfiniteLoop which allows you to to execute a task or a Job automatically, based on a loop.
Best regards
Sabrina

Re: tOracleInput Random Failed Connection

chichibio — Fri, 04 Nov 2016 09:27:13 GMT

Hi Sabrina,
I try it but doesn't work:

I wrong ?

topic Re: tOracleInput Random Failed Connection in Talend Studio

tOracleInput Random Failed Connection

Re: tOracleInput Random Failed Connection

Re: tOracleInput Random Failed Connection