java 整合Web调用kettle本地转换
来源:互联网 发布:java内存模型视频教程 编辑:程序博客网 时间:2024/06/05 06:40
@RequestMapping("/kettle")
public void kettle(HttpServletRequest request){
try {
String user_dir = System.getProperty("user.dir");
/*String kettleHome = this.getServletContext().getRealPath(File.separator + "WEB-INF");*/
String kettleHome = request.getSession().getServletContext().getRealPath(File.separator + "WEB-INF/kettle");
// Kettle初始化需要修改相应的配置路径
System.setProperty("user.dir", kettleHome);
System.setProperty("KETTLE_HOME", kettleHome);
KettleEnvironment.init();
} catch (KettleException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String[] params = {"1","content","test.txt"};
runTransfer(params,"12.ktr");
}
private Object getServletContext() {
// TODO Auto-generated method stub
return null;
}
public void kettle(HttpServletRequest request){
try {
String user_dir = System.getProperty("user.dir");
/*String kettleHome = this.getServletContext().getRealPath(File.separator + "WEB-INF");*/
String kettleHome = request.getSession().getServletContext().getRealPath(File.separator + "WEB-INF/kettle");
// Kettle初始化需要修改相应的配置路径
System.setProperty("user.dir", kettleHome);
System.setProperty("KETTLE_HOME", kettleHome);
KettleEnvironment.init();
} catch (KettleException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String[] params = {"1","content","test.txt"};
runTransfer(params,"12.ktr");
}
private Object getServletContext() {
// TODO Auto-generated method stub
return null;
}
public void runTransfer(String[] params, String ktrPath) {
Trans trans = null;
try {
// // 初始化
// 转换元对象
/*if (!KettleEnvironment.isInitialized()) {
KettleEnvironment.init();
}*/
// 初始化
//EnvUtil.environmentInit();
//StepLoader.init();
TransMeta transMeta = new TransMeta(ktrPath);
//TransMeta transMeta = new TransMeta(System.getProperty("user.dir")+ktrPath);
// 转换
trans = new Trans(transMeta);
// 执行转换
trans.execute(params);
// 等待转换执行结束
trans.waitUntilFinished();
// 抛出异常
if (trans.getErrors() > 0) {
throw new Exception(
"There are errors during transformation exception!(传输过程中发生异常)");
}
} catch (Exception e) {
e.printStackTrace();
}
}
Trans trans = null;
try {
// // 初始化
// 转换元对象
/*if (!KettleEnvironment.isInitialized()) {
KettleEnvironment.init();
}*/
// 初始化
//EnvUtil.environmentInit();
//StepLoader.init();
TransMeta transMeta = new TransMeta(ktrPath);
//TransMeta transMeta = new TransMeta(System.getProperty("user.dir")+ktrPath);
// 转换
trans = new Trans(transMeta);
// 执行转换
trans.execute(params);
// 等待转换执行结束
trans.waitUntilFinished();
// 抛出异常
if (trans.getErrors() > 0) {
throw new Exception(
"There are errors during transformation exception!(传输过程中发生异常)");
}
} catch (Exception e) {
e.printStackTrace();
}
}
阅读全文
0 0
- java 整合Web调用kettle本地转换
- java中调用kettle转换文件
- java中调用kettle转换文件
- Java调用Kettle执行任务或转换
- Java项目中调用Kettle转换
- java中调用kettle转换文件
- BI:Java调用Kettle执行任务或转换
- Java-动态传参调用kettle转换和作业
- Kettle java调用
- java调用Kettle总结
- Kettle java调用
- Java调用ETL工具Kettle
- kettle中调用java类
- java调用spoon kettle API
- java调用kettle工具类
- kettle+java代码调用Webservice
- kettle调用自定义java类
- java调用kettle向job(任务)和transformation(转换)传递参数实例
- 手机代理访问 自己制作的看看能不能看懂
- 读入字符时往往会多一个回车,如何解决
- LaTex “too many unprocessed floats” (过多未处理的浮动)错误的解决方法
- 一些自己整理实用代码
- HDU1257
- java 整合Web调用kettle本地转换
- JS数组与对象的遍历方法大全
- 计算机网络(1):运输层(TCP/UDP)
- 设计模式(17) 责任链模式(简单入门 行为模式)
- Permission denied (publickey). fatal: The remote end hung up unexpectedly 解决办法
- AngularJS实现跨域请求
- EvenBus No subscribers registered for event class 发送消息失败
- c++ sort函数的使用
- STM32怎么读取输出口电平