ERROR tool BaseSqoopTool Got error creating database manager java io IOException No manager for connect string

Question

I am trying to connect sqoop with my database but It shows me the below error.

localhost@master:~/sqoop-2.1.0/bin$ ./sqoop import --connect 'jdbc:sqlserver ://10.0.0.115; username = abc ;password=abc;database=sqoop' --table mytable --target-dir /sqoop/file/
23/04/20 11:13:29 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string:jdbc:sqlserver ://10.0.0.115; username = abc ;password=abc;database=sqoop'
at com.cloudera.sqoop.ConnFactory.getManager(ConnFactory.java:119)

Answer 1

Hi@akhtar,

I think your jdbc jars are not present in lib folder and also make changes in your command as given below.

$ SQOOP_HOME/lib
$ ./sqoop import --connect jdbc:sqlserver://10.0.0.115:port/sqoop; username = abc ;password=abc; --table mytable --target-dir /sqoop/file/

Hope this will work.