topic ELT for Oracle : tELTOracleOutput_1 java.sql.SQLException: The Network in Talend Studio

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

Anonymous — Tue, 04 Sep 2012 14:16:31 GMT

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 ?

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

Anonymous — Tue, 04 Sep 2012 14:42:55 GMT

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

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

Anonymous — Tue, 04 Sep 2012 15:08:35 GMT

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 ?

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

Anonymous — Tue, 04 Sep 2012 15:42:38 GMT

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

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

Anonymous — Mon, 08 Oct 2012 15:34:27 GMT

Hi
Thanks - it works now
looking for parameter now

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

Anonymous — Wed, 20 Nov 2013 21:39:22 GMT

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

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

Anonymous — Thu, 21 Nov 2013 04:10:16 GMT

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

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

Anonymous — Thu, 21 Nov 2013 13:27:09 GMT

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

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

Anonymous — Thu, 21 Nov 2013 14:37:42 GMT

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

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

Anonymous — Thu, 21 Nov 2013 14:52:20 GMT

Uploading the ELT job screenshot for this job

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

Anonymous — Fri, 22 Nov 2013 21:51:09 GMT

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

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

Anonymous — Mon, 20 Mar 2017 15:37:51 GMT

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.

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

Anonymous — Tue, 21 Mar 2017 08:37:24 GMT

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