Great! I am glad you could run sqoop now. We are using sqoop heavily. Great tool!. We had been using bcp to copy file over etc., before sqoop connector was available.
--Chalcy On Mon, Jul 23, 2012 at 8:27 AM, iwannaplay games < [email protected]> wrote: > 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 > >> >> > >> > > >> > > >
