Sqoop1.99.6 启动 JDBCREPO_0009 报错
博客专区 > u91win 的博客 > 博客详情
Sqoop1.99.6 启动 JDBCREPO_0009 报错
u91win 发表于1年前
Sqoop1.99.6 启动 JDBCREPO_0009 报错
  • 发表于 1年前
  • 阅读 12
  • 收藏 0
  • 点赞 0
  • 评论 0

腾讯云 学生专属云服务套餐 10元起购>>>   

摘要: Centos 7 + hadoop-2.7.2 + hive-2.1.0 + Sqoop1.99.6 Sqoop1.99.6 启动 JDBCREPO_0009 报错

Centos 7 + hadoop-2.7.2 + hive-2.1.0 + Sqoop1.99.6  配置时, Sqoop1.99.6 在 执行 sqoop2-tool verify 时报错:

Exception in thread "PurgeThread" org.apache.sqoop.common.SqoopException: JDBCREPO_0009:Failed to finalize transaction
        at org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:115)
        at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:111)
        at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:63)
        at org.apache.sqoop.repository.JdbcRepository.purgeSubmissions(JdbcRepository.java:591)
        at org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:660)
Caused by: java.sql.SQLNonTransientConnectionException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.noCurrentConnection(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.checkIfClosed(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setupContextStack(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.commit(Unknown Source)
        at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)
        at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)
        at org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:112)
        ... 4 more
Caused by: java.sql.SQLException: No current connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)
        ... 15 more

 

原因为jar 包版本冲突 ,修复:


    cd ~
    wget http://apache.mirrors.pair.com/db/derby/db-derby-10.11.1.1/db-derby-10.11.1.1-bin.tar.gz
    tar xzvf db-derby-10.11.1.1-bin.tar.gz
    cp  db-derby-10.11.1.1-bin/lib/derby.jar $SQOOP_HOME/server/webapps/sqoop/WEB-INF/lib/
    cp db-derby-10.11.1.1-bin/lib/derbyclient.jar $SQOOP_HOME/server/webapps/sqoop/WEB-INF/lib/

    cd $SQOOP_HOME/server/webapps/sqoop/WEB-INF/lib/
    mv derby-10.8.2.2.jar derby-10.8.2.2.jar.bak
    mv derbyclient-10.8.2.2.jar derbyclient-10.8.2.2.jar.bak

 

再来一次就行了

共有 人打赏支持
粉丝 2
博文 4
码字总数 1377
×
u91win
如果觉得我的文章对您有用,请随意打赏。您的支持将鼓励我继续创作!
* 金额(元)
¥1 ¥5 ¥10 ¥20 其他金额
打赏人
留言
* 支付类型
微信扫码支付
打赏金额:
已支付成功
打赏金额: