Hi Rechard, does derby need to be installed in advance?
<div>-------- 原始邮件 --------</div><div>发件人： "Zhou, Richard" <[email protected]> </div><div>日期:2015-07-13 15:21 (GMT+08:00) </div><div>收件人： [email protected] </div><div>抄送： </div><div>主题： RE: sqoop install : unable t load native sqoop library for your platform </div><div> </div>Would you share your catalina.properties and sqoop.properties? Regards Richard From: Lee S [mailto:[email protected]] Sent: Monday, July 13, 2015 2:30 PM To: [email protected] Subject: Re: sqoop install : unable t load native sqoop library for your platform Log as attachment. And I ran sqoop2-tool verify with same error. On Mon, Jul 13, 2015 at 2:23 PM, Lee S <[email protected]> wrote: sqoop server didnt start. 2015-07-13 14:23:44,524 INFO derby.DerbyRepositoryHandler [org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:196)] Can't fetch repository structure version. org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:113) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) at org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:185) at org.apache.sqoop.repository.derby.DerbyRepositoryHandler.createOrUpgradeRepository(DerbyRepositoryHandler.java:209) at org.apache.sqoop.repository.JdbcRepository$1.doIt(JdbcRepository.java:133) at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:92) at org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:63) at org.apache.sqoop.repository.JdbcRepository.createOrUpgradeRepository(JdbcRepository.java:129) at org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:123) at org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:77) at org.apache.sqoop.core.SqoopServer.initialize(SqoopServer.java:56) at org.apache.sqoop.server.ServerInitializer.contextInitialized(ServerInitializer.java:41) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) Caused by: java.sql.SQLSyntaxErrorException: Table/View 'SQOOP.SQ_SYSTEM' does not exist. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:285) at org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1179) at org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107) On Mon, Jul 13, 2015 at 1:08 PM, Zhou, Richard <[email protected]> wrote: Would you attach the log? Have you checked whether the Sqoop server works fine? Use “ps aux | grep sqoop” and “netstat –anp | grep 12000”. Regards Richard From: Lee S [mailto:[email protected]] Sent: Monday, July 13, 2015 12:33 PM To: [email protected] Subject: sqoop install : unable t load native sqoop library for your platform Hi all , I try to start sqoop sever and encounter the error below. And I checked the hadoop config in catalina.properties, that's all right. Can anybody help？ sqoop:000> set server -host your.host.com -port 12000 -webapp sqoop Server is set successfully sqoop:000> show version -all client version: Sqoop 1.99.6 source revision 07244c3915975f26f03d9e1edf09ab7d06619bb8 Compiled by root on Wed Apr 29 10:40:43 CST 2015 0 [main] WARN org.apache.hadoop.util.NativeCodeLoader - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable Exception has occurred during processing command Exception: org.apache.sqoop.common.SqoopException Message: CLIENT_0000:An unknown error has occurred
