eclipse集成kettle_java 调用kettle报错，求大神解答

2017-06-25 回答

java调用kettle数据库类型资源库中的ktr 此问题在1个月前或许已经接触，单是一直木有怎么用到，就被耽搁至今；问题的解决要来源于网络，其实我还想说问题的解决更多的是要靠我们自己的思想，不过多的言情，我们接下来直接进入主题吧！ 环境：kettle-spoon 4.2.0,oracle11g，myeclipse6.5，sqlserver2008 前提：在kettle图形界面spoon里面已经做好了一个ktr转换模型，此时我的ktr信息如下图： step1：在myeclipse创建project，导入kettle集成所需要的包 step2:重点解析与code源码 //定义ktr名字 private static string transname = "test1"; //初始化kettle环境 kettleenvironment.init(); //创建资源库对象，此时的对象还是一个空对象 kettledatabaserepository repository = new kettledatabaserepository(); //创建资源库数据库对象，类似我们在spoon里面创建资源库 databasemeta datameta = new databasemeta("enfo_bi","oracle","native","ip","sid","port","username","password"); //资源库元对象,名称参数，id参数，描述等可以随便定义 kettledatabaserepositorymeta kettledatabasemeta = new kettledatabaserepositorymeta("enfo_bi", "enfo_bi", "king description",datameta); //给资源库赋值 repository.init(kettledatabasemeta); //连接资源库 repository.connect("admin","admin"); //根据变量查找到模型所在的目录对象 repositorydirectoryinterface directory = repository.finddirectory("/enfo_worker/wxj"); //创建ktr元对象 transmeta transformationmeta = ((repository) repository).loadtransformation(transname, directory, null, true, null ) ; //创建ktr trans trans = new trans(transformationmeta); //执行ktr trans.execute(null); //等待执行完毕 trans.waituntilfinished(); 上面的两个步骤才可以确定是资源库中的那个路径下的ktr和我们用命令执行一样的-dir ,-tran -job 附上源码： package kettle; import org.pentaho.di.core.kettleenvironment; import org.pentaho.di.core.database.databasemeta; import org.pentaho.di.core.exception.kettleexception; import org.pentaho.di.repository.repository; import org.pentaho.di.repository.repositorydirectoryinterface; import org.pentaho.di.repository.kdr.kettledatabaserepository; import org.pentaho.di.repository.kdr.kettledatabaserepositorymeta; import org.pentaho.di.trans.trans; import org.pentaho.di.trans.transmeta; /** *

title: java调用kettle4.2数据库型资料库中的转换

*

description:

*

copyright: copyright () 2012

*/ public class executedatabasereptran { private static string transname = "test1"; public static void main(string[] args) { try { //初始化kettle环境 kettleenvironment.init(); //创建资源库对象，此时的对象还是一个空对象 kettledatabaserepository repository = new kettledatabaserepository(); //创建资源库数据库对象，类似我们在spoon里面创建资源库 databasemeta datameta = new databasemeta("enfo_bi","oracle","native","ip","sid","port","username","password"); //资源库元对象,名称参数，id参数，描述等可以随便定义 kettledatabaserepositorymeta kettledatabasemeta = new kettledatabaserepositorymeta("enfo_bi", "enfo_bi", "king description",datameta); //给资源库赋值 repository.init(kettledatabasemeta); //连接资源库 repository.connect("admin","admin"); //根据变量查找到模型所在的目录对象,此步骤很重要。 repositorydirectoryinterface directory = repository.finddirectory("/enfo_worker/wxj"); //创建ktr元对象 transmeta transformationmeta = ((repository) repository).loadtransformation(transname, directory, null, true, null ) ; //创建ktr trans trans = new trans(transformationmeta); //执行ktr trans.execute(null); //等待执行完毕 trans.waituntilfinished(); if(trans.geterrors()>0) { system.err.println("transformation run failure!"); } else { system.out.println("transformation run successfully!"); } } catch (kettleexception e) { e.printstacktrace(); } } }