Wednesday, September 17, 2014

Oozie - Could not connect to the database: java.lang.ClassNotFoundException: com.mysql.jdbc.Drive

I am using Cloudera Manager 4.8.0 to set up Oozie with mySQL. After installed the Oozie instance and try to start Oozie, I am getting errors like:

java.lang.Exception: Could not connect to the database: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:473)
    at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:179)
    at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:118)
    at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:64)
...

To solve this problem, make sure you have "mysql-connector-java.jar" in "/var/lib/oozie/", I copied it from "/usr/share/java/mysql-connector-java.jar"

# ls -lh /var/lib/oozie/mysql-connector-java.jar
-rw-r--r-- 1 root root 801K Sep 17 12:54 /var/lib/oozie/mysql-connector-java.jar

Cpoying mysql-connector-java.jar into /va/lib/oozie solved my problem.

No comments: