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

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous]

Hi
Thanks - it works now
looking for parameter now

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Uploading the ELT job screenshot for this job