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 Threaded View
Sqoop >> mail # user >> OraOop error: cannot be called unless RememberSqoopJobType() has been used


Copy link to this message
-
Re: OraOop error: cannot be called unless RememberSqoopJobType() has been used
Hi Alexey,
what Sqoop and OraOop version are you using?

Jarcec

On Fri, Aug 30, 2013 at 11:55:03AM +0400, Алексей Филановский wrote:
> 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
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