Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded 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
Алексей Филановский 2013-08-30, 07:55
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