One Star

ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

I m new in Talend ETL (most experience in SSIS).
Talend ver 4.2 and Oracle 11g DB.
I make simple example with OracleELT
tELTOracleInput -> tELTOracleMap --> tELTOracleOutput
When running :
xception in component tELTOracleOutput_1
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at thinkbi_dev.j_elt_load_0_1.j_elt_load.tELTOracleMap_1Process(j_elt_load.java:307)
at thinkbi_dev.j_elt_load_0_1.j_elt_load.runJobInTOS(j_elt_load.java:570)
disconnected
Any ideas ?
12 REPLIES
One Star

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

That is a Oracle JDBC driver exception(classes12.jar/ojdbc14.jar), Check you connection.
--
Regards,
Vinod
One Star

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

That is a Oracle JDBC driver exception(classes12.jar/ojdbc14.jar), Check you connection.

Coonection works OK
OracleInput , Output compnents work OK but very SLOWLY
50 entries inserting per second
I investigate possibility to use ELT comonnets to speed up process
and have this error on tELTOracleOutput

I searched these forums but I found no topics with Same problem.
could you pls comment what shoud I check in details ?
One Star

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

Please provide screenshot of job and of the tELTOracleMap settings.
Please also check your network. This might be a network issue also since you are saying output component works but slowly and it also fetches error at times. So might be the slow network which is braking sometimes.
On windows system you can check with following command "ping <ip> -t"
Probaly you can try with tOracleConnection and use it in tELTOracleMap.
--
Regards,
Vinod
One Star

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

Hi
Thanks - it works now
looking for parameter now
One Star

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

We are getting same error. ETL works fine but not ELT.
Please find attached job also the error screen.

Talend ver 5.3 and Oracle 11g DB.
connecting to socket on port 3730
connected
Exception in component tELTOracleOutput_2
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at saleforce.test_elt_0_1.test_ELT.tELTOracleMap_1Process(test_ELT.java:360)
at saleforce.test_elt_0_1.test_ELT.runJobInTOS(test_ELT.java:632)
disconnected
at saleforce.test_elt_0_1.test_ELT.main(test_ELT.java:498)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:206)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:2
Moderator

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

Hi, mravikan
It seems the attached job and the error screen fail to be uploaded into forum, could you please check it?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

Somehow not able to attach the file. file size is less than 200KB, still could not not attach.
Employee

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

The screenshot for the ELT job is attached. Also Talend version is v5.3.
Employee

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

Uploading the ELT job screenshot for this job
Employee

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

Is there any resolution for this error ? I am re-attaching the screenshots.
One Star

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

hello 
im using talend for a BI projet
i connected the source with oracle 10g
i made a simple etl with tETLOracleinput----tEtlOracleMap-----TEtlOracleOutput;
it gives me this error;
Démarrage du job bi a 15:37 20/03/2017.
connecting to socket on port 3994
connected
Exception in component tELTOracleOutput_1
java.sql.SQLRecoverableException: Exception d'E/S: 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(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
: local_project.bi_0_1.bi - tELTOracleOutput_1 Exception d'E/S: The Network Adapter could not establish the connection
at local_project.bi_0_1.bi.tELTOracleMap_1Process(bi.java:428)
at local_project.bi_0_1.bi.runJobInTOS(bi.java:789)
at local_project.bi_0_1.bi.main(bi.java:623)
disconnected
Job bi terminé à 15:37 20/03/2017.
Moderator

Re: ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network

Hi LAMYAE04,
Can you connect to your Oralce DB successfully through client without using talend tool? Is your network Ok with you?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.