dmontgom
asked on
getting jdbc to work on a mac os
Hi...
I used sudo port install mysql-connector-java to install a mysql connectory for jdbc.
Whe I try and execute this command...
sqoop import --connect jdbc:mysql://ubuntu@xxxxx. com/testdb 1 --table test -m 1
I get this error
11/03/04 16:47:45 INFO tool.CodeGenTool: Beginning code generation
11/03/04 16:47:45 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException : Could not load db driver class: com.mysql.jdbc.Driver
java.lang.RuntimeException : Could not load db driver class: com.mysql.jdbc.Driver
at com.cloudera.sqoop.manager .SqlManage r.makeConn ection(Sql Manager.ja va:597)
at com.cloudera.sqoop.manager .GenericJd bcManager. getConnect ion(Generi cJdbcManag er.java:51 )
at com.cloudera.sqoop.manager .MySQLMana ger.execut e(MySQLMan ager.java: 201)
at com.cloudera.sqoop.manager .SqlManage r.getColum nTypesForR awQuery(Sq lManager.j ava:177)
at com.cloudera.sqoop.manager .SqlManage r.getColum nTypes(Sql Manager.ja va:161)
at com.cloudera.sqoop.orm.Cla ssWriter.g enerate(Cl assWriter. java:908)
at com.cloudera.sqoop.tool.Co deGenTool. generateOR M(CodeGenT ool.java:8 2)
at com.cloudera.sqoop.tool.Im portTool.i mportTable (ImportToo l.java:337 )
at com.cloudera.sqoop.tool.Im portTool.r un(ImportT ool.java:4 23)
at com.cloudera.sqoop.Sqoop.r un(Sqoop.j ava:144)
at org.apache.hadoop.util.Too lRunner.ru n(ToolRunn er.java:65 )
at org.apache.hadoop.util.Too lRunner.ru n(ToolRunn er.java:79 )
at com.cloudera.sqoop.Sqoop.r unSqoop(Sq oop.java:1 80)
at com.cloudera.sqoop.Sqoop.r unTool(Sqo op.java:21 8)
at com.cloudera.sqoop.Sqoop.m ain(Sqoop. java:228)
How to I fix so I can use jdbc
I also have the jar fle from the mysql website.
I used sudo port install mysql-connector-java to install a mysql connectory for jdbc.
Whe I try and execute this command...
sqoop import --connect jdbc:mysql://ubuntu@xxxxx.
I get this error
11/03/04 16:47:45 INFO tool.CodeGenTool: Beginning code generation
11/03/04 16:47:45 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException
java.lang.RuntimeException
at com.cloudera.sqoop.manager
at com.cloudera.sqoop.manager
at com.cloudera.sqoop.manager
at com.cloudera.sqoop.manager
at com.cloudera.sqoop.manager
at com.cloudera.sqoop.orm.Cla
at com.cloudera.sqoop.tool.Co
at com.cloudera.sqoop.tool.Im
at com.cloudera.sqoop.tool.Im
at com.cloudera.sqoop.Sqoop.r
at org.apache.hadoop.util.Too
at org.apache.hadoop.util.Too
at com.cloudera.sqoop.Sqoop.r
at com.cloudera.sqoop.Sqoop.r
at com.cloudera.sqoop.Sqoop.m
How to I fix so I can use jdbc
I also have the jar fle from the mysql website.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can achieve that by copying the jat to $SQOOP_HOME/lib
Copy the mysql driver jar to the lib/ext directory of your active java runtime