資源簡介
將kettle集成值web應用中,不再需打開kettle窗口運行,并通過spring自動任務進行數據抽取,數據庫采用數據源(jndi)的方式進行管理。配置簡單方便。(之前需要kettle打開其運行環境,并配置數據庫連接的相關信息)
代碼片段和文件信息
package?com.kettle3.service;
import?org.pentaho.di.core.exception.KettleException;
import?org.pentaho.di.trans.StepLoader;
import?org.pentaho.di.trans.Trans;
import?org.pentaho.di.trans.Transmeta;
public?class?AutoKettleService?{
public?void?executeKettle()?throws?KettleException?{
System.out.println(“執行kettle數據抓取任務開始!“);
try?{
StepLoader.init();
}?catch?(Exception?ex)?{
ex.printStackTrace();
}
String?filePath?=?getKettleFilePath();
System.out.println(“獲取文件路徑:?“+filePath);
Transmeta?meta?=?new?Transmeta(filePath);
Trans?trans?=?new?Trans(meta);
trans.execute(null);
trans.waitUntilFinished();
trans.endProcessing(“end“);
System.out.println(“執行kettle數據抓取任務結束!“);
}
/**
?*?獲取WEB-INF目錄下面kettle_demo_test.ktr文件的路徑
?*?@return
?*/
public?static?String?getKettleFilePath()
{
String?path=Thread.currentThread().getContextClassLoader().getResource(““).toString();
path=path.replace(‘/‘?‘\\‘);?//?將/換成\
path=path.replace(“file:“?““);?//去掉file:
path=path.replace(“classes\\“?““);?//去掉class\
path=path.substring(1);?//去掉第一個\如?\D:\JavaWeb...
path+=“kettle\\kettle_demo_test.ktr“;
return?path;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-12-05?15:26??kettle3\
?????文件????????2655??2015-12-05?16:34??kettle3\.classpath
?????文件????????1040??2015-12-02?16:01??kettle3\.project
?????目錄???????????0??2015-12-05?15:10??kettle3\.settings\
?????文件?????????503??2015-12-02?16:01??kettle3\.settings\.jsdtscope
?????文件?????????395??2015-12-02?16:00??kettle3\.settings\org.eclipse.jdt.core.prefs
?????文件?????????451??2015-12-02?16:01??kettle3\.settings\org.eclipse.wst.common.component
?????文件?????????345??2015-12-02?16:01??kettle3\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2015-12-02?16:01??kettle3\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-12-02?16:01??kettle3\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-12-05?17:29??kettle3\WebContent\
?????目錄???????????0??2015-12-05?15:10??kettle3\WebContent\me
?????文件??????????39??2015-12-02?16:01??kettle3\WebContent\me
?????目錄???????????0??2015-12-05?17:14??kettle3\WebContent\WEB-INF\
?????文件????????1738??2015-12-05?16:05??kettle3\WebContent\WEB-INF\applicationContext.xm
?????目錄???????????0??2015-12-05?16:34??kettle3\WebContent\WEB-INF\classes\
?????目錄???????????0??2015-12-05?16:34??kettle3\WebContent\WEB-INF\classes\com\
?????目錄???????????0??2015-12-05?16:34??kettle3\WebContent\WEB-INF\classes\com\kettle3\
?????目錄???????????0??2015-12-05?16:34??kettle3\WebContent\WEB-INF\classes\com\kettle3\service\
?????文件????????2326??2015-12-05?17:24??kettle3\WebContent\WEB-INF\classes\com\kettle3\service\AutoKettleService.class
?????目錄???????????0??2015-12-05?17:14??kettle3\WebContent\WEB-INF\kettle\
?????文件????????4794??2015-12-05?17:14??kettle3\WebContent\WEB-INF\kettle\kettle_demo_test.ktr
?????目錄???????????0??2015-12-05?16:34??kettle3\WebContent\WEB-INF\lib\
?????文件??????481534??2015-12-02?16:42??kettle3\WebContent\WEB-INF\lib\apache-logging-log4j.jar
?????文件??????188671??2015-12-02?16:42??kettle3\WebContent\WEB-INF\lib\commons-beanutils-1.7.0.jar
?????文件??????559366??2015-12-02?16:42??kettle3\WebContent\WEB-INF\lib\commons-collections-3.1.jar
?????文件??????143602??2015-12-02?16:42??kettle3\WebContent\WEB-INF\lib\commons-digester-1.8.jar
?????文件???????52915??2015-12-02?16:42??kettle3\WebContent\WEB-INF\lib\commons-logging-1.1.jar
?????文件??????409795??2015-12-02?16:42??kettle3\WebContent\WEB-INF\lib\commons-vfs-2.0-20090205.jar
?????文件??????285638??2015-12-05?16:07??kettle3\WebContent\WEB-INF\lib\jtds-1.2.jar
?????文件??????330469??2015-12-02?16:42??kettle3\WebContent\WEB-INF\lib\kettle-core.jar
............此處省略23個文件信息
評論
共有 條評論