开发者社区> itkeke> 正文

Kettle连接MySQL数据库出现问题,连接不上的解决方法

简介: 使用Kettle连接MySQL数据库,发生了错误
+关注继续查看

本文转自IT摆渡网欢迎转载,请标明出处
摆渡网

更多mysq文章请阅读

mysql数据库问题解决

使用Kettle连接MySQL数据库,发生了错误,废话不多说,直接上图:
QQ_20170817162617
  错误信息:

  错误连接数据库 [tcc] : org.pentaho.di.core.exception.KettleDatabaseException:

  Error occurred while trying to connect to the database

  Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.

  org.gjt.mm.mysql.Driver

  org.pentaho.di.core.exception.KettleDatabaseException:

  Error occurred while trying to connect to the database

  Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.

  org.gjt.mm.mysql.Driver

  at org.pentaho.di.core.database.Database.normalConnect(Database.Java:428)

  at org.pentaho.di.core.database.Database.connect(Database.java:358)

  at org.pentaho.di.core.database.Database.connect(Database.java:311)

  at org.pentaho.di.core.database.Database.connect(Database.java:301)

  at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80)

  at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2686)

  at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:546)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

  at java.lang.reflect.Method.invoke(Method.java:597)

  at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)

  at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)

  at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)

  at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:43)

  at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:138)

  at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)

  at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)

  at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)

  at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)

  at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)

  at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)

  at org.eclipse.jface.window.Window.open(Window.java:796)

  at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:389)

  at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:318)

  at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:116)

  at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:59)

  at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:464)

  at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:451)

  at org.pentaho.di.ui.spoon.Spoon.newConnection(Spoon.java:8728)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

  at java.lang.reflect.Method.invoke(Method.java:597)

  at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)

  at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)

  at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)

  at org.pentaho.ui.xul.jface.tags.JfaceMenuitem.access$100(JfaceMenuitem.java:43)

  at org.pentaho.ui.xul.jface.tags.JfaceMenuitem$1.run(JfaceMenuitem.java:106)

  at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)

  at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)

  at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)

  at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)

  at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)

  at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)

  at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)

  at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)

  at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1319)

  at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939)

  at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190)

  at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

  at java.lang.reflect.Method.invoke(Method.java:597)

  at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)

  Caused by: org.pentaho.di.core.exception.KettleDatabaseException:

  Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.

  org.gjt.mm.mysql.Driver

  at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:522)

  at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:4697)

  at org.pentaho.di.core.database.Database.normalConnect(Database.java:414)

  ... 55 more

  Caused by: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver

  at java.NET.URLClassLoader$1.run(URLClassLoader.java:202)

  at java.security.AccessController.doPrivileged(Native Method)

  at java.net.URLClassLoader.findClass(URLClassLoader.java:190)

  at java.lang.ClassLoader.loadClass(ClassLoader.java:306)

  at java.lang.ClassLoader.loadClass(ClassLoader.java:247)

  at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:497)

  ... 57 more

  主机名 : 210.17.19.79

  端口 : 3306

  数据库名:test

  错误信息显示是jar包未安装,有问题找百度:

  下载jar包:mysql-connector-java-5.1.15-bin.jar

  放到Kettle安装目录下:D:kettledata-integrationlib

  重启Spoon.bat问题解决:
QQ_20170817162750

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
如何重置Joomla并解决文件或数据库问题
如果您在Joomla网站上遇到问题,那么重新安装其核心文件和数据库可能是最好的解决方案。
842 0
【转】ADO.NET连接访问dbf数据库问题
from:http://space.cnblogs.com/question/7423/    悬赏园豆:20 [已解决问题] 浏览: 2067次   我发现当dbf文件的长度超过8的时候,使用OleDbCommand 查询就会出现“jet 数据库引擎找不到对象”的错误,我搜索到(http://space.cnblogs.com/question/2046/)说解决了这个问题,方法是将表的名字加个中括号。
1183 0
JSP中拼装数据为XML出现的问题
一、应用背景 JSP取得Servlet中放入request的List,将List中的数据拼装成XML。以下代码在Eclipse的内置浏览器中显示为xml,没有问题。 /** * 新闻Servlet * @author 徐越 * */ public class ListServlet extends HttpServlet { private static fin
811 0
"无法删除数据库,因为该数据库当前正在使用"问题解决
原文:"无法删除数据库,因为该数据库当前正在使用"问题解决 异常处理汇总-数据库系列  http://www.cnblogs.com/dunitian/p/4522990.html  以前刚学数据库的时候比较苦恼这个问题,今天删除的时候又看见了,正好一起记录一下: 图形化方法: 命令行方法...
1399 0
+关注
29
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
JS零基础入门教程(上册)
立即下载
性能优化方法论
立即下载
手把手学习日志服务SLS,云启实验室实战指南
立即下载