The error that you're seeing is interesting: /u002/Oracle/Software/sqoop-1.4.1-incubating-src/build.xml:1077: > java.net.ConnectException: Connection refused
It seems that ivy fails to connec to the maven repository. Is the machine that you're on connected to the internet? In fact, this seems consistent with the svn error that you were getting before. In both cases, connection to the repository failed. If you cannot download dependency jar files from the maven repository, you cannot build sqoop as you won't have dependency libraries in your local machine. Thanks, Cheolsoo On Thu, Jul 5, 2012 at 12:59 AM, venkatesh warulu <[email protected]> wrote: > Hi Cheolsoo, > > As per my last email , already installed the Rpm xml-commons-apis > > After installing the Rpm xml-commons-apis , I re ran teh step 6 .. > Getting following error related to Git ... > > ant jar-all > > Buildfile: build.xml > Overriding previous definition of reference to sqoop > [echo] Use Hadoop 0.23 by default > [echo] Use built-in SQL server connector by default > init: > gen-version: > [exec] > /u002/Oracle/Software/sqoop-1.4.1-incubating-src/src/scripts/write-version-info.sh: > line 41: git: command not found > ivy-download: > [get] Getting: > http://repo2.maven.org/maven2/org/apache/ivy/ivy/2.1.0/ivy-2.1.0.jar > [get] To: > /u002/Oracle/Software/sqoop-1.4.1-incubating-src/lib/ivy-2.1.0.jar > [get] Error getting > http://repo2.maven.org/maven2/org/apache/ivy/ivy/2.1.0/ivy-2.1.0.jar to > /u002/Oracle/Software/sqoop-1.4.1-incubating-src/lib/ivy-2.1.0.jar > BUILD FAILED > /u002/Oracle/Software/sqoop-1.4.1-incubating-src/build.xml:1077: > java.net.ConnectException: Connection refused > Total time: 1 second > [root@ltstappsvm01 sqoop-1.4.1-incubating-src]# > > Regards > Venky > *From:* Cheolsoo Park <[email protected]> > *To:* venkatesh warulu <[email protected]> > *Cc:* "[email protected]" <[email protected]> > *Sent:* Thursday, July 5, 2012 3:43 PM > *Subject:* Re: OraOop > > Hi, > > Does installing xml-commons-apis solve that problem? > > sudo yum install xml-commons-apis > > Cheolsoo > > On Thu, Jul 5, 2012 at 12:27 AM, venkatesh warulu <[email protected]>wrote: > > Hi Cheolsoo, > > I am almost there , executing the step 6 > I was getting this error > > ant jar -all > /usr/bin/build-classpath: error: Could not find xml-commons-apis Java > extension for this JVM > /usr/bin/build-classpath: error: Some specified jars were not found > Unknown argument: -all > ant [options] [target [target2 [target3] ...]] > Options: > -help, -h print this message > -projecthelp, -p print project help information > -version print the version information and exit > -diagnostics print information that might be helpful to > diagnose or report problems. > -quiet, -q be extra quiet > -verbose, -v be extra verbose > -debug, -d print debugging information > -emacs, -e produce logging information without adornments > -lib <path> specifies a path to search for jars and classes > -logfile <file> use given file for log > -l <file> '' > -logger <classname> the class which is to perform logging > -listener <classname> add an instance of class as a project listener > -noinput do not allow interactive input > -buildfile <file> use given buildfile > -file <file> '' > -f <file> '' > -D<property>=<value> use value for given property > -keep-going, -k execute all targets that do not depend > on failed target(s) > -propertyfile <name> load all properties from file with -D > properties taking precedence > -inputhandler <class> the class which will handle input requests > -find <file> (s)earch for buildfile towards the root of > -s <file> the filesystem and use it > -nice number A niceness value for the main thread: > 1 (lowest) to 10 (highest); 5 is the default > -nouserlib Run ant without using the jar files from > ${user.home}/.ant/lib > -noclasspath Run ant without using CLASSPATH > > > Then Iexported the following > export ANT_HOME=/usr/share/ant > export JAVA_HOME=/usr/java/jdk1.6.0_25 > > Still getting following error > > [root@ltstappsvm01 sqoop-1.4.1-incubating-src]# ant jar-all > /usr/bin/build-classpath: error: Could not find xml-commons-apis Java > extension for this JVM > /usr/bin/build-classpath: error: Some specified jars were not found > Buildfile: build.xml > Overriding previous definition of reference to sqoop > [echo] Use Hadoop 0.23 by default > [echo] Use built-in SQL server connector by default > init: > gen-version: > [exec] > /u002/Oracle/Software/sqoop-1.4.1-incubating-src/src/scripts/write-version-info.sh: > line 41: git: command not found > ivy-download: > [get] Getting: > http://repo2.maven.org/maven2/org/apache/ivy/ivy/2.1.0/ivy-2.1.0.jar > [get] To: > /u002/Oracle/Software/sqoop-1.4.1-incubating-src/lib/ivy-2.1.0.jar > [get] Error getting > http://repo2.maven.org/maven2/org/apache/ivy/ivy/2.1.0/ivy-2.1.0.jar to > /u002/Oracle/Software/sqoop-1.4.1-incubating-src/lib/ivy-2.1.0.jar > BUILD FAILED > /u002/Oracle/Software/sqoop-1.4.1-incubating-src/build.xml:1077: > java.net.ConnectException: Connection refused > Total time: 1 second > > Regards > Venky > *From:* Cheolsoo Park <[email protected]> > *To:* venkatesh warulu <[email protected]> > *Cc:* "[email protected]" <[email protected]> > *Sent:* Thursday, July 5, 2012 2:24 PM > *Subject:* Re: OraOop > > Hi Venky, > > OK, can you try the following then? > > 1) Since you can't checkout source code, please download the source > tarball from one of sqoop mirror sites ( > http://www.apache.org/dyn/closer.cgi/sqoop/). > > For example: > > http://www.reverse.net/pub/apache/sqoop/1.4.1-incubating/sqoop-1.4.1-incubating-src.tar.gz > > 2) tar -xf sqoop-1.4.1-incubating-src.tar.gz > > 3) cd sqoop-1.4.1-incubating-src > > 4) wget > https://issues.apache.org/jira/secure/attachment/12531120/SQOOP-480-2.patch > > 5) patch -p0 -i SQOOP-480.patch > > 6) ant jar-all > > 7) You will find "sqoop-test-1.4.2-incubating-SNAPSHOT.jar" in the "build" > sub-directory. > > 8) Replace /usr/lib/sqoop/sqoop-1.4.1-cdh4.0.0.jar with > sqoop-test-1.4.2-incubating-SNAPSHOT.jar. > > Thanks! > Cheolsoo > > > On Wed, Jul 4, 2012 at 11:02 PM, venkatesh warulu <[email protected]>wrote: > > Hi Cheolsoo, > > Just I have installed Svn and tried to execute the steps mentioned in the > note , getting follwoing error > > svn co https://svn.apache.org/repos/asf/sqoop/trunk/ sqoop > svn: OPTIONS of 'https://svn.apache.org/repos/asf/sqoop/trunk': > could not connect to server (https://svn.apache.org/) > Also need to understand after the build , which file need to be replaced > > /usr/lib/sqoop/sqoop-* > -rw-r--r-- 1 root root 596185 Jun 4 17:45 > /usr/lib/sqoop/sqoop-1.4.1-cdh4.0.0.jar > -rw-r--r-- 1 root root 291898 Jun 4 17:45 > /usr/lib/sqoop/sqoop-test-1.4.1-cdh4.0.0.jar > > Regards > Venky > *From:* Cheolsoo Park <[email protected]> > *To:* venkatesh warulu <[email protected]> > *Cc:* "[email protected]" <[email protected]> > *Sent:* Thursday, July 5, 2012 1:46 PM > *Subject:* Re: OraOop > > Typo correction: > > Would you mind if I ask why you can't build Sqoop? > > > On Wed, Jul 4, 2012 at 10:43 PM, Cheolsoo Park <[email protected]>wrote: > > Hi Venky, > > Unfortunately, there is no compiled code that includes this fix at the > moment. We're going to release a new version of Sqoop soon, but you will > have to wait until then though. > > Would you mind asking why you can't build Sqoop? > > Thanks, > Cheolsoo > > On Wed, Jul 4, 2012 at 10:21 PM, venkatesh warulu <[email protected]>wrote: > > > Hi Cheolsoo > > Thank for all your valuable suppot ... > Ubfortunately I could not able to build , Is it any way possible to get > the compiled code , so that I can just deploy > > > Regards > Venky > > *From:* Cheolsoo Park <[email protected]> > *To:* venkatesh warulu <[email protected]> > *Cc:* "[email protected]" <[email protected]> > *Sent:* Thursday, July 5, 2012 1:09 PM > *Subject:* Re: OraOop > > Hi Venky, > > Sure. No problem. > > 1) Checkout the latest Sqoop source code that already includes SQOOP-480 > from the project repository and build. For details, please refer to the > following link: > > > https://cwiki.apache.org/confluence/display/SQOOP/Setting+up+Development+Environment > > 2) Replace the installed Sqoop jar with the one that you've just built. If > you installed Sqoop from rpm or deb, you can find the installed jar at > /usr/lib/sqoop/lib. > > Please let me know if you have any further questions. > > Thanks, > Cheolsoo > > On Wed, Jul 4, 2012 at 7:42 PM, venkatesh warulu <[email protected]>wrote: > > Hi , > > This is new area for me to explore ... Will you please provide me the > steps to apply the patch *SQOOP-480*. > > > > Regards > Venky > *From:* Cheolsoo Park <[email protected]> > *To:* [email protected] > *Cc:* [email protected] > *Sent:* Thursday, July 5, 2012 4:05 AM > *Subject:* Re: OraOop > > Hi Venky, > > Exception in thread "main" > java.lang.NoSuchMethodError: > com.cloudera.sqoop.manager.ImportJobContext.setConnManager(Lcom/cloudera/sqoop/manager/ConnManager;)V > > > This is fixed in the upstream trunk. Please see SQOOP-480: > https://issues.apache.org/jira/browse/SQOOP-480. Unfortunately, there is > no official Sqoop release that include this fix, so you will have to apply > the patch and rebuild Sqoop. > > Thanks, > Cheolsoo > > > On Wed, Jul 4, 2012 at 12:13 PM, Kathleen Ting <[email protected]>wrote: > > Dear Venky, > > For faster resolution of Sqoop support issues, please subscribe to the > Sqoop User mailing list by emailing: [email protected] > > Regarding your issue below, it could be that your version of Hadoop is > not compatible with OraOop - what is your Hadoop version? > > Regards, Kathleen > > sqoop import --connect > jdbc:oracle:thin:@lyisdb01.dev.sgp.avagotech.net:1523:OPTCH --username > system --password clone --table VENK -verbose > 12/07/04 05:39:14 WARN tool.BaseSqoopTool: Setting your password on > the command-line is insecure. Consider using -P instead. > 12/07/04 05:39:14 DEBUG oraoop.OraOopUtilities: Enabled OraOop debug > logging. > 12/07/04 05:39:14 DEBUG oraoop.OraOopManagerFactory: Quest® Data > Connector for Oracle and Hadoop can be called by Sqoop! > 12/07/04 05:39:14 INFO manager.SqlManager: Using default fetchSize of 1000 > 12/07/04 05:39:15 DEBUG oraoop.OraOopUtilities: The Oracle table > context has been derived from: > oracleConnectionUserName = system > tableStr = VENK > as: > owner : SYSTEM > table : VENK > 12/07/04 05:39:15 INFO oraoop.OraOopManagerFactory: > *************************************************************** > *** Using Quest® Data Connector for Oracle and Hadoop 1.5.0 *** > *** Copyright 2012 Quest Software, Inc. *** > *** ALL RIGHTS RESERVED. *** > *************************************************************** > 12/07/04 05:39:15 INFO oraoop.OraOopManagerFactory: Oracle Database > version: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - > 64bit Production > 12/07/04 05:39:15 INFO oraoop.OraOopManagerFactory: This Oracle > database is not a RAC. > 12/07/04 05:39:15 WARN conf.Configuration: mapred.map.max.attempts is > deprecated. Instead, use mapreduce.map.maxattempts > 12/07/04 05:39:15 INFO tool.CodeGenTool: Beginning code generation > 12/07/04 05:39:15 DEBUG oraoop.OraOopOracleQueries: getTableColumns() : > sql = > SELECT column_name, data_type FROM dba_tab_columns WHERE owner = ? > and table_name = ? and (DATA_TYPE IN > > ('BINARY_DOUBLE','BINARY_FLOAT','BLOB','CHAR','CLOB','DATE','FLOAT','LONG','NCHAR','NCLOB','NUMBER','NVARCHAR2','RAW','ROWID','URITYPE','VARCHAR2') > OR DATA_TYPE LIKE 'INTERVAL YEAR(%) TO MONTH' OR DATA_TYPE LIKE > 'INTERVAL DAY(%) TO SECOND(%)' OR DATA_TYPE LIKE 'TIMESTAMP(%)' OR > DATA_TYPE LIKE 'TIMESTAMP(%) WITH TIME ZONE' OR DATA_TYPE LIKE > 'TIMESTAMP(%) WITH LOCAL TIME ZONE') ORDER BY column_id > 12/07/04 05:39:15 INFO manager.SqlManager: Executing SQL statement: > SELECT "A","B" FROM VENK WHERE 0=1 > 12/07/04 05:39:15 INFO manager.SqlManager: Executing SQL statement: > SELECT A,B FROM VENK WHERE 1=0 > 12/07/04 05:39:15 INFO orm.CompilationManager: HADOOP_HOME is > /usr/lib/hadoop > Note: /tmp/sqoop-root/compile/8817da7c72ed005d42065edefc806224/VENK.java > uses or overrides a deprecated API. > Note: Recompile with -Xlint:deprecation for details. > 12/07/04 05:39:18 INFO orm.CompilationManager: Writing jar file: > /tmp/sqoop-root/compile/8817da7c72ed005d42065edefc806224/VENK.jar > 12/07/04 05:39:18 DEBUG oraoop.OraOopConnManager: The output directory > for the sqoop table import is : VENK > Exception in thread "main" java.lang.NoSuchMethodError: > > com.cloudera.sqoop.manager.ImportJobContext.setConnManager(Lcom/cloudera/sqoop/manager/ConnManager;)V > at > com.quest.oraoop.OraOopConnManager.importTable(OraOopConnManager.java:248) > at > org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:403) > at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476) > at org.apache.sqoop.Sqoop.run(Sqoop.java:145) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) > at org.apache.sqoop.Sqoop.main(Sqoop.java:238) > at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57) > > > > > > > > > > > > > > > > > >
