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

0 votes

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)
Apr 24 in Big Data Hadoop by akhtar
• 11,270 points
61 views

1 answer to this question.

0 votes

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.

answered Apr 24 by MD
• 24,500 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Java MapReduce error saying No FileSystem for scheme:hdfs

The problem is with the dependencies. The ...READ MORE

answered May 9, 2018 in Big Data Hadoop by Shubham
• 13,380 points
545 views
0 votes
1 answer

Hadoop: namenode -format error "java.io.IOException"

Run the command as sudo or add the ...READ MORE

answered Nov 26, 2018 in Big Data Hadoop by Omkar
• 69,060 points
574 views
+1 vote
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,920 points
5,116 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,920 points
732 views
+1 vote
11 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyF ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
30,402 views
–1 vote
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,310 points
1,907 views