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: [email protected] Date: Mon, 19 Sep 2011 18:35:33 To: <[email protected]> Reply-To: [email protected] 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 <[email protected]> Date: Mon, 19 Sep 2011 11:06:19 To: Sqoop Users<[email protected]> Reply-To: [email protected] 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, "[email protected]" <[email protected]> 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 <[email protected]> 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 [email protected] is deprecated in favor of > > Apache Sqoop mailing list [email protected]. Please subscribe > > to it by sending an email to [email protected] > > Hide quoted text - > > - Show quoted text - -- NOTE: The mailing list [email protected] is deprecated in favor of Apache Sqoop mailing list [email protected]. Please subscribe to it by sending an email to [email protected].
