Kettle配置Oracle库报错怎么处理?

時光清淺i 2016-07-06 10:38:58
错误连接数据库 [133.64.87.228-ststsdb] : org.pentaho.di.core.exception.KettleDatabaseException:
java.sql.SQLException: Configuration file not found
Configuration file not found

org.pentaho.di.core.exception.KettleDatabaseException:
java.sql.SQLException: Configuration file not found
Configuration file not found

at org.pentaho.di.core.database.ConnectionPoolUtil.clearConnection(ConnectionPoolUtil.java:173)
at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:71)
at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2446)
at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:348)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:294)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:124)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:112)
at org.pentaho.ui.xul.swt.tags.SwtButton.access$000(SwtButton.java:17)
at org.pentaho.ui.xul.swt.tags.SwtButton$1.widgetSelected(SwtButton.java:77)
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:238)
at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:174)
at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:44)
at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:93)
at org.pentaho.di.ui.spoon.designform.DesignComposite.doubleClickedInResourceTree(DesignComposite.java:4215)
at org.pentaho.di.ui.spoon.designform.DesignComposite.access$19(DesignComposite.java:4139)
at org.pentaho.di.ui.spoon.designform.DesignComposite$14.widgetDefaultSelected(DesignComposite.java:1144)
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.pentaho.di.ui.spoon.faultform.WaitDealDialog.open(WaitDealDialog.java:102)
at org.pentaho.di.ui.spoon.Spoon$20$1.run(Spoon.java:1575)
at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1666)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5313)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:435)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:116)
Caused by: java.sql.SQLException: Configuration file not found
at org.apache.commons.dbcp.PoolingDriver.getConnectionPool(PoolingDriver.java:132)
at org.pentaho.di.core.database.ConnectionPoolUtil.clearConnection(ConnectionPoolUtil.java:168)
... 45 more
...全文
1731 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
  • 打赏
  • 举报
回复
Oracle jar'文件没放到kettle里面去
wl19931218 2018-02-02
  • 打赏
  • 举报
回复
原因是没有找到oracle的驱动jar文件。 找到oracle的安装目录搜索关键字:ojdbc 把ojdbc6.jar文件复制到ETL的lib目录下即可

1,617

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 非技术区
社区管理员
  • 非技术区社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧