使用Java程序调用本地转换盒作业，资源库中的转换和作业（kettle4.2）

新建Java工程，引入所有需要的包，新建Java类：KettleJava.java，代码如下：（四个方法分别实现执行本地转换和作业，资源库中的转换和作业）

package kettle.java;   import org.pentaho.di.core.KettleEnvironment; import org.pentaho.di.core.database.DatabaseMeta; import org.pentaho.di.core.exception.KettleException; import org.pentaho.di.core.logging.LogWriter; import org.pentaho.di.core.util.EnvUtil; import org.pentaho.di.job.Job; import org.pentaho.di.job.JobMeta; 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;   public class KettleJava { //执行本地转换 public void runNativeTran(){            String transName ="D:/etltest/etltest4.2/kettleJava/Excel_parameter.ktr";            try {             //初始化kettle环境             KettleEnvironment.init();             //直接执行本地转换             TransMeta transformationMetaNative =new TransMeta(transName);             //创建ktr             Trans trans = new Trans(transformationMetaNative);             //执行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();         }            } //执行本地作业 public void runNativeJob(){            String jobName="D:/etltest/etltest4.2/kettleJava/EtltestJob.kjb";                     try {                       KettleEnvironment.init();                       //jobname 是Job脚本的路径及名称                       JobMeta jobMeta = new JobMeta(jobName, null);                       Job job = new Job(null, jobMeta);                       //向Job 脚本传递参数，脚本中获取参数值：${参数名}                       //job.setVariable(paraname, paravalue);                        job.start();                        job.waitUntilFinished();                        if (job.getErrors() > 0) {                        throw new Exception("There are errors during job exception!(执行job发生异常)");                       }                       } catch (Exception e) {                       e.printStackTrace();                     }            } //执行资源库中的转换 public void runRepTran(){            String transName ="Excel_parameter";            try {             //初始化kettle环境             KettleEnvironment.init();             //创建资源库对象，此时的对象还是一个空对象             KettleDatabaseRepository repository = new KettleDatabaseRepository();                          //创建资源库数据库对象，类似我们在spoon里面创建资源库             DatabaseMeta dataMeta =             new DatabaseMeta("etltest4.2_repository_mysql","MYSQL","Native","localhost", "etltest_repository4_2","3306","admin","admin");             //资源库元对象,名称参数，id参数，描述等可以随便定义             KettleDatabaseRepositoryMeta kettleDatabaseMeta =             new KettleDatabaseRepositoryMeta("etltest4.2_repository_mysql", "etltest4.2_repository_mysql", "databaseRepositoryMeta description",dataMeta);             //kettleDatabaseMeta.setConnection(dataMeta);                         //给资源库赋值             repository.init(kettleDatabaseMeta);             //连接资源库             repository.connect("admin","admin");             //根据变量查找到模型所在的目录对象,此步骤很重要。             RepositoryDirectoryInterface directory = repository.findDirectory("/parameters");             //创建ktr元对象--资源库中的转换             TransMeta transformationMetaRep = ((Repository) repository).loadTransformation(transName, directory, null, true, null );             //创建ktr             Trans trans = new Trans(transformationMetaRep);             //执行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();         }            } //执行资源库中的作业 public void runRepJob(){            String jobName ="job_ftp_upload";            try {             //初始化kettle环境             KettleEnvironment.init();             //创建资源库对象，此时的对象还是一个空对象             KettleDatabaseRepository repository = new KettleDatabaseRepository();                         //创建资源库数据库对象，类似我们在spoon里面创建资源库             DatabaseMeta dataMeta =             new DatabaseMeta("etltest4.2_repository_mysql","MYSQL","Native","localhost","etltest_repository4_2","3306","admin","admin");             //资源库元对象,名称参数，id参数，描述等可以随便定义             KettleDatabaseRepositoryMeta kettleDatabaseMeta =             new KettleDatabaseRepositoryMeta("etltest4.2_repository_mysql", "etltest4.2_repository_mysql", "databaseRepositoryMeta description",dataMeta);             //kettleDatabaseMeta.setConnection(dataMeta);                         //给资源库赋值             repository.init(kettleDatabaseMeta);             //连接资源库             repository.connect("admin","admin");             //根据变量查找到模型所在的目录对象,此步骤很重要。             RepositoryDirectoryInterface directory = repository.findDirectory("/work");             //创建kjb元对象--资源库中的作业             JobMeta jobMetaRep = ((Repository) repository).loadJob(jobName, directory, null, null);//loadTransformation(transName, directory, null, true, null );             //JobMeta jobMeta = new JobMeta(jobName, null);              //JobMeta jobMetaRep= new JobMeta(jobName, repository);                     Job job = new Job(repository, jobMetaRep);             job.start();             job.waitUntilFinished();                                    if(job.getErrors()>0) {                                   System.err.println("Transformation run Failure!");             }else{                 System.out.println("Transformation run successfully!");             }         } catch (KettleException e) {             e.printStackTrace();         } } public static void main(String[] args) {            KettleJava kettleJava=new KettleJava();            //kettleJava.runNativeTran();            //kettleJava.runRepTran();            kettleJava.runNativeJob();            //kettleJava.runRepJob(); } }