You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by iwannaplay games <fu...@gmail.com> on 2012/07/23 10:10:42 UTC
Could not load ManagerFactory com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory
(not found)
Hi,
I have succesfully installed sqoop as when i type sqoop-help i am able
to retrieve the list as shown below.But when i try to connect it to
sql server and list databases,it gives connection error.ie ERROR
sqoop.ConnFactory: Could not load ManagerFactory
com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory (not found)
I have installed the mssql connector and set its path as well.I have
also copied the sqljdbc jars in lib .
Why this error is coming then
Thanks & Regards
Prabhjot
Here are the results
[hduser@master bin]$ sqoop-help
Warning: $HADOOP_HOME is deprecated.
usage: sqoop COMMAND [ARGS]
Available commands:
codegen Generate code to interact with database records
create-hive-table Import a table definition into Hive
eval Evaluate a SQL statement and display the results
export Export an HDFS directory to a database table
help List available commands
import Import a table from a database to HDFS
import-all-tables Import tables from a database to HDFS
job Work with saved jobs
list-databases List available databases on a server
list-tables List available tables in a database
merge Merge results of incremental imports
metastore Run a standalone Sqoop metastore
version Display version information
See 'sqoop help COMMAND' for information on a specific command.
[hduser@master bin]$ sqoop list-databases --driver
com.microsoft.jdbc.sqlserver.SQLServerDriver --connect
'jdbc:sqlserver://IPADDRESS;username=dvp;password=dvp'
Warning: $HADOOP_HOME is deprecated.
12/07/23 19:05:16 ERROR sqoop.ConnFactory: Could not load
ManagerFactory com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory
(not found)
12/07/23 19:05:16 INFO manager.SqlManager: Using default fetchSize of 1000
12/07/23 19:05:16 ERROR manager.SqlManager: Generic
SqlManager.listDatabases() not implemented.
Could not retrieve database list from server
12/07/23 19:05:16 ERROR tool.ListDatabasesTool:
manager.listDatabases() returned null