Actually when i pasted sql server connector and jdbc connectors in hadoop lib folder,the errors are gone
On 7/23/12, Chalcy <[email protected]> wrote: > com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory > > If you follow instruction on installation, this will automatically be > written. > > --Chalcy > > On Mon, Jul 23, 2012 at 7:09 AM, iwannaplay games < > [email protected]> wrote: > >> yes its installed properly ,i have a question >> In SQOOP_HOME /conf/managers.d/mssqoop-sqlserver >> >> what should be written >> >> Regards >> Prabhjot >> >> >> On 7/23/12, Chalcy <[email protected]> wrote: >> > Hi, >> > >> > Do you have the microsft sql server connector installed? >> > >> > http://www.microsoft.com/en-us/download/details.aspx?id=27584 >> > >> > --Chalcy >> > >> > On Mon, Jul 23, 2012 at 5:10 AM, iwannaplay games < >> > [email protected]> wrote: >> > >> >> Hi, >> >> >> >> I am getting this error.Please let me know if anybody knows about it. >> >> >> >> [hduser@master bin]$ sqoop list-databases --connect >> >> 'jdbc:sqlserver://198.1.1.187;username=develop;password=d3v3l0p' >> >> --verbose >> >> Warning: $HADOOP_HOME is deprecated. >> >> >> >> 12/07/23 20:08:19 ERROR sqoop.ConnFactory: Could not load >> >> ManagerFactory com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory >> >> (not found) >> >> 12/07/23 20:08:19 INFO manager.SqlManager: Using default fetchSize of >> >> 1000 >> >> 12/07/23 20:08:19 ERROR sqoop.Sqoop: Got exception running Sqoop: >> >> java.lang.RuntimeException: Could not load db driver class: >> >> com.microsoft.sqlserver.jdbc.SQLServerDriver >> >> java.lang.RuntimeException: Could not load db driver class: >> >> com.microsoft.sqlserver.jdbc.SQLServerDriver >> >> at >> >> org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:657) >> >> at >> >> >> org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) >> >> at >> >> >> org.apache.sqoop.manager.CatalogQueryManager.listDatabases(CatalogQueryManager.java:56) >> >> at >> >> org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:49) >> >> at org.apache.sqoop.Sqoop.run(Sqoop.java:145) >> >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) >> >> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) >> >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) >> >> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) >> >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> >> at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57) >> >> >> >> >> >> Thanks >> >> >> > >> >
