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, 2020 in Big Data Hadoop by akhtar
• 38,170 points
691 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, 2020 by MD
• 95,060 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,480 points
830 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,090 points
1,127 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
• 11,380 points
6,846 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
• 11,380 points
1,095 views
+2 votes
11 answers

hadoop fs -put command?

Hi, You can create one directory in HDFS ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by nitinrawat895
• 11,380 points
48,273 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,390 points
2,596 views
0 votes
1 answer
0 votes
1 answer