tSqoopImport ERROR cannot find the file

[Anonymous]

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 :"jdbc racle: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? "jdbc racle:thin..." ?
thanks!

[Anonymous]

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? "jdbcracle:thin..." ?

For Oracle DB, the connection string looks like:
"jdbc racle:thin:@host_ip:1521:database_name"
Shong

[Anonymous]

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..