oozie 创建oozie.sql文件时报错遇到 Could not connect to the database:

oozie 创建oozie.sql文件时遇到 Could not connect to the database: ###java.lang.ClassNotFoundException: com.mysq

在创建oozie.sql文件时 bin/ooziedb.sh create -sqlfile oozie.sql -run 遇到如下报错：

Validate DB Connection
Error: Could not connect to the database: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
Stack trace for the error was (for debug purposes):
--------------------------------------
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:903)
at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:183)
at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:127)
at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:78)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:892)
at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:899)
... 3 more
--------------------------------------

应该是数据库连接不上的问题

1.检查了oozie-site.xml 的相关配置，发现没有问题

2.在/usr/my.cnf [mysqld]标签下添加一句：skip-grant-tables 还是无果

3.更换了驱动包 mysql-connector-java-5.1.32.jar

在oozie根目录的libext 重新用二进制的上传方式上传 发现解决了问题

最后

以上就是忧心爆米花为你收集整理的oozie 创建oozie.sql文件时报错遇到 Could not connect to the database:的全部内容，希望文章能够帮你解决oozie 创建oozie.sql文件时报错遇到 Could not connect to the database:所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。