"Got an error creating the database manager" - Error in sqoop import request

Question

Scenario:

I am trying to import from SQL Server to HDFS, but I am getting errors like:

Error:

hadoop@ubuntu :~/sqoop-1.1.0/bin$ ./sqoop import --connect 'jdbc:sqlserver://192.168.230.1;username=xxx;password=xxxxx;database=HadoopTest' --table PersonInfo --target-dir /home/hadoop/hadoop-0.21.0/ 11/12/10 12:13:20 ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string: jdbc:sqlserver://192.168.230.1;username=xxx;password=xxxxx;database=HadoopTest at com.cloudera.sqoop.ConnFactory.getManager(ConnFactory.java:119) at com.cloudera.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:178) at com.cloudera.sqoop.tool.ImportTool.init(ImportTool.java:81) at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:411) at com.cloudera.sqoop.Sqoop.run(Sqoop.java:134) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:69) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:83) at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:170) at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:196) at com.cloudera.sqoop.Sqoop.main(Sqoop.java:205) 

Question:

What is the problem that I am not getting? My Hadoop Version: hadoop-0.21.0 Sqoop Version: sqoop-1.1.0

Pls offers me a solution. Thank you

Answer 1

Your syntax is incorrect. Use the syntax below

  ./sqoop import --connect jdbc:sqlserver://192.168.230.1:<PORT_NUMBER>/HadoopTest --username xxx --password xxxxx --table PersonInfo --target-dir /home/hadoop/hadoop-0.21.0/ 

Also make sure jdbc jasrs must be present in

 $SQOOP_HOME/lib 

Answer 2

Oddly enough, using a single tic to include your connection string can cause problems. If you use double quotes or nothing at all, this might work better for you - at least it happens in my environment.

So instead

 ./sqoop import --connect 'jdbc:sqlserver://192.168.230.1;username=xxx;password=xxxxx;database=HadoopTest' --table PersonInfo --target-dir /home/hadoop/hadoop-0.21.0/ 

to try

 ./sqoop import --connect "jdbc:sqlserver://192.168.230.1;username=xxx;password=xxxxx;database=HadoopTest" --table PersonInfo --target-dir /home/hadoop/hadoop-0.21.`0/ 

or

 ./sqoop import --connect jdbc:sqlserver://192.168.230.1;username=xxx;password=xxxxx;database=HadoopTest --table PersonInfo --target-dir /home/hadoop/hadoop-0.21.0/ 

Hope this helps.

Answer 3

You need to specify Drivermanager

- driver com.microsoft.jdbc.sqlserver.SQLServerDriver