sqoop启动出错， JDBCREPO_0009

Question

版本：Sqoop1.99.5 ，Hadoop2.5.2

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:109)
at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:61)
at org.apache.sqoop.repository.JdbcRepository.purgeSubmissions(JdbcRepository.java:589)
at org.apache.sqoop.driver.JobManager$PurgeThread.run(JobManager.java:648)
Caused by: java.sql.SQLNonTransientConnectionException: No current connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(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: ERROR 08003: No current connection.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
... 16 more

Answer 1

JDBC链接的话，直接使用官网预编译的sqoop版本就可以，需要的jdbc jar文件放置在lib下。配置好conf文件，就可以连接上的。我之前就是使用sqoop-1.99.3+hadoop-2.5.2+hive-1.2.1+mysql&postgresql 直接就打通了。

http://blog.csdn.net/huyangshu87/article/details/51372495

Answer 2

n那怎么解决的呢？？

Answer 3

我也遇到了，目前还没有解决...

Answer 4

请问这个问题您最终如何解决的啊？

Answer 5

当然没连上

Answer 6

引用来自“_hadooper”的评论

Caused by: ERROR 08003: No current connection.连上了吗

Answer 7

Caused by: ERROR 08003: No current connection.连上了吗