使用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();

}

}