Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> OraOop error: cannot be called unless RememberSqoopJobType() has been used


Copy link to this message
-
OraOop error: cannot be called unless RememberSqoopJobType() has been used
Hi all!

I install OraOop as pointed in instruction:
http://archive.cloudera.com/cdh/3/adapters/oraoopuserguide.pdf<http://archive.cloudera.com/cdh/4/adapters/oraoopuserguide.pdf>

And try to use OraOop,but get error:

[oracle@db11203x64 ~]$ sqoop import   --connection-manager
com.quest.oraoop.OraOopConnManager    --connect
jdbc:oracle:thin:@//localhost:1521/orcl
   --username demouser --password welcome1 --table DEMOUSER.GUP_PROFILE_V2
13/08/30 03:15:45 WARN tool.BaseSqoopTool: Setting your password on the
command-line is insecure. Consider using -P instead.
13/08/30 03:15:45 INFO manager.SqlManager: Using default fetchSize of 1000
13/08/30 03:15:45 INFO tool.CodeGenTool: Beginning code generation
13/08/30 03:15:48 ERROR sqoop.Sqoop: Got exception running Sqoop:
java.lang.RuntimeException: RecallSqoopJobType() cannot be called unless
RememberSqoopJobType() has been used.
java.lang.RuntimeException: RecallSqoopJobType() cannot be called unless
RememberSqoopJobType() has been used.
        at
com.quest.oraoop.OraOopUtilities.recallSqoopJobType(OraOopUtilities.java:757)
        at
com.quest.oraoop.OraOopConnManager.getColumnNamesInOracleTable(OraOopConnManager.java:115)
        at
com.quest.oraoop.OraOopConnManager.getSelectedColumnNamesInOracleTable(OraOopConnManager.java:135)
        at
com.quest.oraoop.OraOopConnManager.getColTypesQuery(OraOopConnManager.java:198)
        at
org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:220)
        at
com.quest.oraoop.OraOopConnManager.getColumnTypes(OraOopConnManager.java:460)
        at
org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:283)
        at
org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1268)
        at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1080)
        at
org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
        at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390)
        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)

Sorry I didn't found the same case in web...

--
Best regards,
Alexey Filanovskiy
+
Venkat Ranganathan 2013-08-30, 16:36
+
Jarek Jarcec Cecho 2013-09-02, 08:55
+
Alexey Filanovskiy 2013-09-02, 12:11
+
Jarek Jarcec Cecho 2013-09-04, 06:52
+
Алексей Филановский 2013-09-06, 08:35
+
Jarek Jarcec Cecho 2013-09-12, 06:32
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB