kettle使用jndi连接 oracle时测试数据库报错

2016-06-12 11:05:19 2.4k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›
sykcool007 sykcool007 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网 我也要 + 加入社区
Kettle连接Oracle 19c的三种方式：JDBC、JNDI与RDO实战指南 在数据集成与ETL场景中，Java编写的Kettle是主流工具，而连接Oracle 19c常因驱动版本、JDK版本及服务名配置问题导致失败。要解决这个问题，需理解JDBC直连、JNDI统一配置文件、RDO依赖Oracle客户端三种连接路径的原理与适用场景。JDBC直连最为通用灵活，适合快速验证；JNDI将连接参数集中管理，便于多作业复用与团队维护；RDO则适用于老版本作业或特殊网络环境。合理选择连接方式，并配置ojdbc8/ojdbc10驱动、确认PDB服务名，即可实现稳定高效的数据抽取与同步。本文基于实际 阅读详情
错误连接数据库 [ic_zy] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
java.io.File parameter must be a directory. [C:\Windows\System32\simple-jndi]

org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
java.io.File parameter must be a directory. [C:\Windows\System32\simple-jndi]

at org.pentaho.di.core.database.Database.normalConnect(Database.java:312)
at org.pentaho.di.core.database.Database.connect(Database.java:261)
at org.pentaho.di.core.database.Database.connect(Database.java:223)
at org.pentaho.di.core.database.Database.connect(Database.java:213)
at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:55)
at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2409)
at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:487)
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:161)
at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:79)
at org.pentaho.di.ui.spoon.Spoon.editConnection(Spoon.java:2001)
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.xul.EventHandler.handleMenuEvent(EventHandler.java:42)
at org.pentaho.xul.swt.menu.PopupMenu.handleMenuEvent(PopupMenu.java:40)
at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77)
at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73)
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:945)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412)
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.lang.IllegalArgumentException: java.io.File parameter must be a directory. [C:\Windows\System32\simple-jndi]
at org.osjava.sj.loader.JndiLoader.loadDirectory(JndiLoader.java:110)
at org.osjava.sj.loader.JndiLoader.loadDirectory(JndiLoader.java:104)
at org.osjava.sj.SimpleContext.<init>(SimpleContext.java:96)
at org.osjava.sj.SimpleContextFactory.getInitialContext(SimpleContextFactory.java:69)
at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.init(Unknown Source)
at javax.naming.InitialContext.<init>(Unknown Source)
at org.pentaho.di.core.database.util.DatabaseUtil.getDataSourceFromJndi(DatabaseUtil.java:70)
at org.pentaho.di.core.database.util.DatabaseUtil.getNamedDataSource(DatabaseUtil.java:44)
at org.pentaho.di.core.database.Database.initWithNamedDataSource(Database.java:325)
at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:351)
at org.pentaho.di.core.database.Database.normalConnect(Database.java:296)
... 46 more

主机名 :
端口 : 1521
数据库名:ic_zy
错误连接数据库 [ic_zy] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
java.io.File parameter must be a directory. [C:\Windows\System32\simple-jndi]

org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
java.io.File parameter must be a directory. [C:\Windows\System32\simple-jndi]

at org.pentaho.di.core.database.Database.normalConnect(Database.java:312)
at org.pentaho.di.core.database.Database.connect(Database.java:261)
at org.pentaho.di.core.database.Database.connect(Database.java:223)
at org.pentaho.di.core.database.Database.connect(Database.java:213)
at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:55)
at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2409)
at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:487)
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:161)
at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:79)
at org.pentaho.di.ui.spoon.Spoon.editConnection(Spoon.java:2001)
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.xul.EventHandler.handleMenuEvent(EventHandler.java:42)
at org.pentaho.xul.swt.menu.PopupMenu.handleMenuEvent(PopupMenu.java:40)
at org.pentaho.xul.swt.menu.MenuChoice.handleMenuEvent(MenuChoice.java:77)
at org.pentaho.xul.swt.menu.MenuChoice.handleEvent(MenuChoice.java:73)
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:945)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:5574)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:412)
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.lang.IllegalArgumentException: java.io.File parameter must be a directory. [C:\Windows\System32\simple-jndi]
at org.osjava.sj.loader.JndiLoader.loadDirectory(JndiLoader.java:110)
at org.osjava.sj.loader.JndiLoader.loadDirectory(JndiLoader.java:104)
at org.osjava.sj.SimpleContext.<init>(SimpleContext.java:96)
at org.osjava.sj.SimpleContextFactory.getInitialContext(SimpleContextFactory.java:69)
at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
at javax.naming.InitialContext.init(Unknown Source)
at javax.naming.InitialContext.<init>(Unknown Source)
at org.pentaho.di.core.database.util.DatabaseUtil.getDataSourceFromJndi(DatabaseUtil.java:70)
at org.pentaho.di.core.database.util.DatabaseUtil.getNamedDataSource(DatabaseUtil.java:44)
at org.pentaho.di.core.database.Database.initWithNamedDataSource(Database.java:325)
at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:351)
at org.pentaho.di.core.database.Database.normalConnect(Database.java:296)
... 46 more

主机名 :
端口 : 1521
数据库名:ic_zy

...全文
Kettle连接Oracle 19c三种方式详解：JDBC、JNDI与OCI配置实践 在数据集成与ETL开发中，Kettle作为开源工具被广泛用于数据抽取、转换和加载。面对Oracle 19c带来的容器数据库（CDB）与可插拔数据库（PDB）架构变化，传统基于SID的连接方式不再适用，而正确选用JDBC驱动、理解服务名与驱动类名变更，是保障数据库连接稳定性的基础。JDBC直连以配置简单、环境依赖少著称，适合快速开发；JNDI通过集中管理数据源，解决了多环境切换与敏感信息保护的运维痛点；OCI则借助Oracle客户端库提供更高并发下的稳定性，适用于特殊网络限制场景。本文结合实际报错排查与兼容性 阅读详情

相关推荐

kettle手册.docx

kettle入门手册

养生熊猫

JDBC方式连接KETTLE运行定时任务报错解决

今天测试KETTLE定时任务时报错 D:\software\kettle7.1&gt;Kitchen.bat -file="D:\software\kettle7.1\xuzhe_test_resault\多表同步（从EXCEL表中获取表名）.kjb" DEBUG: Using JAVA_HOME DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files\Java\jdk1.8.0_131 DEBUG: _PENTAHO_JAVA=C:\Program Files\Java\

白日梦83

kettler连接oracle 12c数据库(目前只能用JNDI)

kettler连接oracle 12c数据库(目前只能用JNDI)

xuqunying071101

kettle 介绍 ETL工具的使用说明

帮助用户了解数据抽取、理解ETL工具怎么使用

jack_gps

Kettle从零开始

Kettle 从零开始系列文章汇总，带标签，方便查看。

欧参谋
评论
收藏 已收藏
分享
返回顶部
sykcool007
sykcool007
数据仓库 7,394 成员 6,741 内容
+ 加入社区