Re: [sqoop-user] Re: Not able to run Sqoop on cdh3u1 vmware

[be...@gmail.com]

Moving the conversation to apache mailing list.
Please register to this list and carry on the thread here.

Regards
Bejoy K S

-----Original Message-----
From: bejoyks@gmail.com
Date: Mon, 19 Sep 2011 18:35:33 
To: <sq...@cloudera.org>
Reply-To: bejoyks@gmail.com
Subject: Re: [sqoop-user] Re: Not able to run Sqoop on cdh3u1 vmware

Sonam
   Try explicitly specifying the driver in your sqoop import command. Include -Driver argument as well in your sqoop import command.
Also you can copy the jar into sqoop/lib as root user. On Cloudera VM I believe the root credentials are root/cloudera .

Hope it helps.
Regards
Bejoy K S

-----Original Message-----
From: Sonam Jain <so...@gmail.com>
Date: Mon, 19 Sep 2011 11:06:19 
To: Sqoop Users<sq...@cloudera.org>
Reply-To: sqoop-user@cloudera.org
Subject: [sqoop-user] Re: Not able to run Sqoop on cdh3u1 vmware

Hi Arvind,

I tried giving libjars in import ,however again facing the same
issue :


[cloudera@localhost ~]$ sqoop import -libjars /home/cloudera/
ojdbc6.jar --connect jdbc:oracle:thin:@192.168.0.102:1521:demodb --
username sysadm --password sysadm  --table sysadm.gmlc_host_error  --
target-dir='/user/local'
11/09/19 23:24:21 WARN tool.BaseSqoopTool: Setting your password on
the command-line is insecure. Consider using -P instead.
11/09/19 23:24:21 INFO manager.SqlManager: Using default fetchSize of
1000
11/09/19 23:24:21 INFO tool.CodeGenTool: Beginning code generation
11/09/19 23:24:21 ERROR sqoop.Sqoop: Got exception running Sqoop:
java.lang.RuntimeException: Could not load db driver class:
oracle.jdbc.OracleDriver
java.lang.RuntimeException: Could not load db driver class:
oracle.jdbc.OracleDriver
        at
com.cloudera.sqoop.manager.OracleManager.makeConnection(OracleManager.java:
260)
        at
com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:
51)
        at
com.cloudera.sqoop.manager.SqlManager.execute(SqlManager.java:457)
        at
com.cloudera.sqoop.manager.SqlManager.execute(SqlManager.java:480)
        at
com.cloudera.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:
193)
        at
com.cloudera.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:
177)
        at
com.cloudera.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:
1185)
        at
com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:1027)
        at
com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
        at
com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:337)
        at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)


On Sep 19, 9:41 pm, "arv...@cloudera.com" <ar...@cloudera.com> wrote:
> Hi,
>
> You can specify the location of your jar using the -libjars option. For example:
>
> sqoop import -libjars /home/cloudera/ojdbc.jar --connect jdbc:oracle:...
>
> Thanks,
> Arvind
>
>
>
> On Mon, Sep 19, 2011 at 9:22 AM, Sonam Jain <so...@gmail.com> wrote:
> > I tried to run sqoop import command on vmware of cloudera in order to
> > import tables from oracle .It is giving me error like this :
>
> > ERROR sqoop.Sqoop: Got exception running Sqoop:
> > java.lang.RuntimeException: Could not load db driver class:
> > oracle.jdbc.OracleDriver
>
> > The soultion which i found on internet is to copy ojdbc6.jar file in
> > sqoop/lib folder .However I do not have permission on the vmware with
> > cloudera/cloudera username/password.How should I proceed?
>
> > --
> > NOTE: The mailing list sqoop-u...@cloudera.org is deprecated in favor of Apache Sqoop mailing list sqoop-u...@incubator.apache.org. Please subscribe to it by sending an email to incubator-sqoop-user-subscr...@apache.org.- Hide quoted text -
>
> - Show quoted text -

-- 
NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please subscribe to it by sending an email to incubator-sqoop-user-subscribe@apache.org.