tSqoopImport ERROR cannot find the file

One Star

tSqoopImport ERROR cannot find the file

Hi all,
i get this error when running a simple job with tSqoopImport component.
Exception in component tSqoopImport_1
java.io.IOException: Cannot run program "sqoop": CreateProcess error=2, The system cannot find the file specified
I specified the necessary parameters.
=> general parameter
connexion :"jdbcSmiley Surprisedracle:thin:@//dwdv:1511/dbdev"
utilisateur: "user"
mot de passe : "pass"
nom de la table: "tablename"
=>advanced parameter
the columns, targetdir and the split by.
my database is Oracle as shown.
in the parameter "Connexion", do you have idea about the structure of ORACLE connection? "jdbcSmiley Surprisedracle:thin..." ?
thanks!
Community Manager

Re: tSqoopImport ERROR cannot find the file

Hi
The error indicates it can't find the program sqoop, ensure that you have Sqoop installed in the host used to run this component and ensure as well that you have added the Sqoop command line to the PATH variable of this host.
in the parameter "Connexion", do you have idea about the structure of ORACLE connection? "jdbcSmiley Surprisedracle:thin..." ?

For Oracle DB, the connection string looks like:
"jdbcSmiley Surprisedracle:thin:@host_ip:1521:database_name"
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tSqoopImport ERROR cannot find the file

Hi,
thank you for answering
I added the two envi var
SQOOP_HOME: C:\Hadoop\sqoop-1.4.2
PATH : C:\Hadoop\sqoop-1.4.2\bin
but still didn't work!!!!!!
error:
Exception in component tSqoopImport_1
java.io.IOException: Cannot run program "sqoop": CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessBuilder.start(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at bigdataproject.chargerdanshdfs_0_1.ChargerDansHDFS.tSqoopImport_1Process(ChargerDansHDFS.java:314)
at bigdataproject.chargerdanshdfs_0_1.ChargerDansHDFS.runJobInTOS(ChargerDansHDFS.java:783)
at bigdataproject.chargerdanshdfs_0_1.ChargerDansHDFS.main(ChargerDansHDFS.java:651)
from the console, sqoop commad work successfully..