Sqoop1.99.6 启动 JDBCREPO_0009 报错

2017-01-05 11:09:06来源:oschina作者:u91win人点击

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 transactionat 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.gztar xzvf db-derby-10.11.1.1-bin.tar.gzcp 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.bakmv derbyclient-10.8.2.2.jar derbyclient-10.8.2.2.jar.bak

再来一次就行了

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台