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
>