高大卫 2022-03-09 12:38 采纳率: 100%
浏览 163
已结题

如何使用Java调用Kettle脚本,出现Caused by: org.pentaho.di.core.exception.KettleDatabaseException?

1.创建kettle脚本,并且可以成功运行转换,数据库连接也没问题!

img

2.Java代码

String fileName = "C:\\Users\\GaoHao\\Desktop\\Text\\ct_test.ktr";
        System.out.println("-----------");
        KettleEnvironment.init();
        TransMeta transMeta = new TransMeta(fileName);
        Trans trans = new Trans(transMeta);
        trans.execute(null);
        trans.waitUntilFinished();

3.报错信息

2022/03/09 12:31:39 - 表输出.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : An error occurred intialising this step: 
2022/03/09 12:31:39 - 表输出.0 - Error occurred while trying to connect to the database
2022/03/09 12:31:39 - 表输出.0 - 
2022/03/09 12:31:39 - 表输出.0 - Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
2022/03/09 12:31:39 - 表输出.0 - org.gjt.mm.mysql.Driver
2022/03/09 12:31:39 - 表输出.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : 错误初始化步骤[表输出]
2022/03/09 12:31:39 - ct_test - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : 步骤 [表输出.0] 初始化失败!
2022/03/09 12:31:39 - 表输出.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : Unexpected error rolling back the database connection.
2022/03/09 12:31:39 - 表输出.0 - ERROR (version 9.0.0.0-423, build 9.0.0.0-423 from 2020-01-31 04.53.04 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException: 
2022/03/09 12:31:39 - 表输出.0 - Unable to get database metadata from this database connection
2022/03/09 12:31:39 - 表输出.0 - 
2022/03/09 12:31:39 - 表输出.0 - Error connecting to database [ct_test]
2022/03/09 12:31:39 - 表输出.0 - 
2022/03/09 12:31:39 - 表输出.0 - 
2022/03/09 12:31:39 - 表输出.0 -     at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3126)
2022/03/09 12:31:39 - 表输出.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:906)
2022/03/09 12:31:39 - 表输出.0 -     at org.pentaho.di.core.database.Database.rollback(Database.java:898)
2022/03/09 12:31:39 - 表输出.0 -     at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:625)
2022/03/09 12:31:39 - 表输出.0 -     at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:1257)
2022/03/09 12:31:39 - 表输出.0 -     at org.pentaho.di.trans.Trans.execute(Trans.java:751)
2022/03/09 12:31:39 - 表输出.0 -     at com.ct.test.kettle.KettleDemo.main(KettleDemo.java:32)
2022/03/09 12:31:39 - 表输出.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
2022/03/09 12:31:39 - 表输出.0 - Error connecting to database [ct_test]
2022/03/09 12:31:39 - 表输出.0 - 
2022/03/09 12:31:39 - 表输出.0 -     at org.pentaho.di.core.database.Database.getDatabaseMetaData(Database.java:3120)
2022/03/09 12:31:39 - 表输出.0 -     ... 6 more
Exception in thread "main" org.pentaho.di.core.exception.KettleException: 
无法初始化至少一个步骤.  执行无法开始!

4.解决办法
需要单独添加mysql-connector-java-5.1.47-bin.jar这个依赖。
jar包下载地址:http://www.java2s.com/Code/Jar/m/Downloadmysqlconnectorjava5123binjar.htm

img

运行成功!

img

  • 写回答

2条回答 默认 最新

      报告相同问题?

      相关推荐 更多相似问题

      问题事件

      • 系统已结题 3月17日
      • 已采纳回答 3月9日
      • 创建了问题 3月9日

      悬赏问题

      • ¥15 关于用matlab进行光束整形的问题
      • ¥15 vs code编译器 C语言刚学,想的有点复杂
      • ¥15 航班订票系统函数无法运行
      • ¥20 VS2022无法启动程序,如何解决?(语言-c++|开发工具-visual studio)
      • ¥15 c语言可以做出完整的吗有人看看吗
      • ¥15 电脑流氓插件处理方法
      • ¥15 问一下这个可调恒流源电路用哪个电源接口比较好,想用tapec接口仅作为电源接口这个引脚怎么连啊
      • ¥30 Abaqus做建模的时候网格没办法收敛是为什么?
      • ¥15 车牌识别摄像镜头,httppost,nodejs
      • ¥20 腾讯云托管与本地测试 GET请求获取返回值 完全不同