topic Error Inserting data to Oracle using ELT in Talend Studio

Error Inserting data to Oracle using ELT

dhans0023 — Wed, 25 Apr 2018 01:34:49 GMT

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.

Re: Error Inserting data to Oracle using ELT

Anonymous — Wed, 25 Apr 2018 10:37:05 GMT

Hello,

Could you please clarify in which Talend version/edition you are?

Best regards

Sabrina

Re: Error Inserting data to Oracle using ELT

dhans0023 — Wed, 25 Apr 2018 16:04:33 GMT

6.5 community edition

Re: Error Inserting data to Oracle using ELT

Anonymous — Thu, 26 Apr 2018 10:17:41 GMT

Hello,

Are you using oracle 11? Oracle OCI? Have your already download ojdbc14.jar by the install external jars wizard of the studio?

Best regards

Sabrina

Re: Error Inserting data to Oracle using ELT

Ganshyam — Thu, 26 Apr 2018 11:04:31 GMT

Hello,

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.

Re: Error Inserting data to Oracle using ELT

dhans0023 — Thu, 26 Apr 2018 13:45:43 GMT

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

Re: Error Inserting data to Oracle using ELT

dhans0023 — Thu, 26 Apr 2018 13:47:10 GMT

Oracle isn;t within my laptop. It is accessible by an ETL or otherwise from command prompt. I use MAC. The oracle is configured by Service name on a EXA. Hope this helps

Re: Error Inserting data to Oracle using ELT

dhans0023 — Thu, 26 Apr 2018 20:31:03 GMT

It is noticed the value of host, username isn't passed to the tELTOracleOutput.

String driverClass_tELTOracleOutput_1 = "oracle.jdbc.driver.OracleDriver";

java.lang.Class.forName(driverClass_tELTOracleOutput_1);

String url_tELTOracleOutput_1 = "jdbcracle:thin:@" + "" + ":"

+ "1521" + ":" + "";

String dbUser_tELTOracleOutput_1 = "";

String decryptedPassword_tELTOracleOutput_1 = null;