I'm very new to Talend, getting an error when designing an ELT. The same connection works in a ETL design.
Exception in component tELTOracleOutput_1 (myfirstELT)
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
I see ojdbc14.jar resolved the issue. Latest update from Oracle is to use ojdbc6.jar or ojdbc7.jar. I used both and same error.
Could you please clarify in which Talend version/edition you are?
Are you using oracle 11? Oracle OCI? Have your already download ojdbc14.jar by the install external jars wizard of the studio?
The is because of the listener issue.Please check the listener status on command prompt.
You can re-start it with the "lsnrctl start" command.
Thank you all for your time to help.
I use ojdbc6.jar as well as tried with ojdbc7.jar. The connectivity works on a regular ETL job. The issue is only with ELT job on the target table.
I couldn't find ojdbc14.jar because per Oracle, it is no longer available for download.
I will do some more research on my own and also seek help from other folks. Will post if i find a solution
It is noticed the value of host, username isn't passed to the tELTOracleOutput.
String driverClass_tELTOracleOutput_1 = "oracle.jdbc.driver.OracleDriver";
String url_tELTOracleOutput_1 = "jdbcracle:thin:@" + "" + ":"
+ "1521" + ":" + "";
String dbUser_tELTOracleOutput_1 = "";
String decryptedPassword_tELTOracleOutput_1 = null;