设为首页收藏本站 开启辅助访问
 找回密码
 立即注册

QQ登录

只需一步,快速开始

用新浪微博登录

只需一步,快速搞定

查看: 208|回复: 1

Kettle 执行任务时提示Connection closed

[复制链接]

6

主题

11

帖子

68

积分

注册会员

Rank: 2

积分
68
发表于 2016-12-19 20:48:07 | 显示全部楼层 |阅读模式
错误信息如下:我有两个任务,连接的数据库都是一样的只有表不一样,一个没问题,一个提示异常
java.sql.SQLException: Closed Connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1133)
        at org.Kettle.org" target="_blank" class="relatedlink">Pentaho.di.core.database.Database.rollback(Database.java:850)
        at org.pentaho.di.core.database.Database.rollback(Database.java:837)
        at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:332)
        at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118)
        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
        at java.lang.Thread.run(Thread.java:745)
2016/12/19 19:49:19 - insert.0 - ERROR (version Unknown, build 0 from 2016/12/19 19:45:22.375 by root) : Because of an error, this step can't continue:
2016/12/19 19:49:19 - insert.0 - ERROR (version Unknown, build 0 from 2016/12/19 19:45:22.375 by root) : org.pentaho.di.core.exception.KettleDatabaseException:
2016/12/19 19:49:19 - insert.0 - Error performing rollback on connection
2016/12/19 19:49:19 - insert.0 - Closed Connection
2016/12/19 19:49:19 - insert.0 -
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.rollback(Database.java:860)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.rollback(Database.java:837)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:332)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:118)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2016/12/19 19:49:19 - insert.0 -        at java.lang.Thread.run(Thread.java:745)
2016/12/19 19:49:19 - insert.0 - Caused by: java.sql.SQLException: Closed Connection
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1133)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.rollback(Database.java:850)
2016/12/19 19:49:19 - insert.0 -        ... 5 more
************ true *************
java.sql.SQLException: Closed Connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1103)
        at org.pentaho.di.core.database.Database.commit(Database.java:771)
        at org.pentaho.di.core.database.Database.commit(Database.java:747)
        at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1368)
        at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:574)
        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:97)
        at java.lang.Thread.run(Thread.java:745)
2016/12/19 19:49:19 - insert.0 - ERROR (version Unknown, build 0 from 2016/12/19 19:45:22.375 by root) : Unexpected error committing the database connection.
2016/12/19 19:49:19 - insert.0 - ERROR (version Unknown, build 0 from 2016/12/19 19:45:22.375 by root) : org.pentaho.di.core.exception.KettleDatabaseException:
2016/12/19 19:49:19 - insert.0 - Error comitting connection
2016/12/19 19:49:19 - insert.0 - Closed Connection
2016/12/19 19:49:19 - insert.0 -
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.commit(Database.java:781)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.commit(Database.java:747)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1368)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:574)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:97)
2016/12/19 19:49:19 - insert.0 -        at java.lang.Thread.run(Thread.java:745)
2016/12/19 19:49:19 - insert.0 - Caused by: java.sql.SQLException: Closed Connection
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1103)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.commit(Database.java:771)
2016/12/19 19:49:19 - insert.0 -        ... 5 more
2016/12/19 19:49:19 - insert.0 - ERROR (version Unknown, build 0 from 2016/12/19 19:45:22.375 by root) : org.pentaho.di.core.exception.KettleDatabaseException:
2016/12/19 19:49:19 - insert.0 - Error comitting connection
2016/12/19 19:49:19 - insert.0 - Closed Connection
2016/12/19 19:49:19 - insert.0 -
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.commit(Database.java:781)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.commit(Database.java:747)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1368)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:574)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:97)
2016/12/19 19:49:19 - insert.0 -        at java.lang.Thread.run(Thread.java:745)
2016/12/19 19:49:19 - insert.0 - Caused by: java.sql.SQLException: Closed Connection
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:1103)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.commit(Database.java:771)
2016/12/19 19:49:19 - insert.0 -        ... 5 more
java.sql.SQLException: Closed Connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1133)
        at org.pentaho.di.core.database.Database.rollback(Database.java:850)
        at org.pentaho.di.core.database.Database.rollback(Database.java:837)
        at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:609)
        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:97)
        at java.lang.Thread.run(Thread.java:745)
2016/12/19 19:49:19 - insert.0 - ERROR (version Unknown, build 0 from 2016/12/19 19:45:22.375 by root) : Unexpected error rolling back the database connection.
2016/12/19 19:49:19 - insert.0 - ERROR (version Unknown, build 0 from 2016/12/19 19:45:22.375 by root) : org.pentaho.di.core.exception.KettleDatabaseException:
2016/12/19 19:49:19 - insert.0 - Error performing rollback on connection
2016/12/19 19:49:19 - insert.0 - Closed Connection
2016/12/19 19:49:19 - insert.0 -
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.rollback(Database.java:860)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.rollback(Database.java:837)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:609)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:97)
2016/12/19 19:49:19 - insert.0 -        at java.lang.Thread.run(Thread.java:745)
2016/12/19 19:49:19 - insert.0 - Caused by: java.sql.SQLException: Closed Connection
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
2016/12/19 19:49:19 - insert.0 -        at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:1133)
2016/12/19 19:49:19 - insert.0 -        at org.pentaho.di.core.database.Database.rollback(Database.java:850)
2016/12/19 19:49:19 - insert.0 -        ... 4 more
2016/12/19 19:49:19 - insert.0 - Finished processing (I=633001, O=1239695, R=-10001, W=4305, U=0, E=1)

楼主热帖

6

主题

11

帖子

68

积分

注册会员

Rank: 2

积分
68
 楼主| 发表于 2016-12-20 14:37:13 | 显示全部楼层
更新了Oracle的驱动jar,好了
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋| μKettle ( 沪ICP备14044064号 )     

GMT+8, 2017-10-19 17:05 , Processed in 0.154864 second(s), 17 queries , File On.

Powered by Discuz!  uKettle

Copyright © 2014 Comsenz Inc.

快速回复 返回顶部 返回列表