08-10-2016 02:22 PM
I am trying create a new Sqoop2 transfer job using hue.
While creating a link with SQL Server details, I am getting error (could not create link).
I could able to run the sqoop job from command pompt with same details.
I have placed sqljdbc42.jar driver in /var/lib/sqoop as well as /var/lib/sqoop2
I am using Sqoop 1.4.5-cdh5.3.3 version
Please suggest the solution.
08-12-2016 07:19 AM - edited 08-12-2016 07:22 AM
Did you restart the sqoop2 service after placing the jdbc driver jar file on the host ?
Appart from that I can only guess it could comes from :
- a faulty information (mostly the JDBC URL that can be tricky) ?
- or a connectivity issue with the database ? Can you ping the database server ?
Did you check the sqoop2 server logs ?