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 11:10:27 UTC
ERROR sqoop.ConnFactory: Could not load ManagerFactory
com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory (not found)
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
Re: ERROR sqoop.ConnFactory: Could not load ManagerFactory
com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory (not found)
Posted by Chalcy <ch...@gmail.com>.
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 <
funnlearnforkids@gmail.com> wrote:
> Actually when i pasted sql server connector and jdbc connectors in
> hadoop lib folder,the errors are gone
>
>
> On 7/23/12, Chalcy <ch...@gmail.com> 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 <
> > funnlearnforkids@gmail.com> 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 <ch...@gmail.com> 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 <
> >> > funnlearnforkids@gmail.com> 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
> >> >>
> >> >
> >>
> >
>
Re: ERROR sqoop.ConnFactory: Could not load ManagerFactory
com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory (not found)
Posted by iwannaplay games <fu...@gmail.com>.
Actually when i pasted sql server connector and jdbc connectors in
hadoop lib folder,the errors are gone
On 7/23/12, Chalcy <ch...@gmail.com> 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 <
> funnlearnforkids@gmail.com> 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 <ch...@gmail.com> 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 <
>> > funnlearnforkids@gmail.com> 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
>> >>
>> >
>>
>
Re: ERROR sqoop.ConnFactory: Could not load ManagerFactory
com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory (not found)
Posted by Chalcy <ch...@gmail.com>.
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 <
funnlearnforkids@gmail.com> 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 <ch...@gmail.com> 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 <
> > funnlearnforkids@gmail.com> 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
> >>
> >
>
Re: ERROR sqoop.ConnFactory: Could not load ManagerFactory
com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory (not found)
Posted by iwannaplay games <fu...@gmail.com>.
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 <ch...@gmail.com> 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 <
> funnlearnforkids@gmail.com> 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
>>
>
Re: ERROR sqoop.ConnFactory: Could not load ManagerFactory
com.microsoft.sqoop.SqlServer.MSSQLServerManagerFactory (not found)
Posted by Chalcy <ch...@gmail.com>.
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 <
funnlearnforkids@gmail.com> 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
>