You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by Алексей Филановский <a....@gmail.com> on 2013/08/30 09:55:03 UTC
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
Re: OraOop error: cannot be called unless RememberSqoopJobType() has
been used
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
Hi Alexey,
It seems to be working for me, so I'm not sure what might went wrong. I would suggest you to create a bug report on OraOop [1] JIRA.
Jarcec
Links:
1: https://questmos.jira.com/browse/ORAOOP
On Fri, Sep 06, 2013 at 12:35:14PM +0400, Алексей Филановский wrote:
> Hi all!
>
> [root@cdh ~]# sqoop version
> Sqoop 1.4.2-cdh4.2.1
> git commit id a0862dc56393e3096c65d6ca26766c67f5ab5309
> Compiled by jenkins on Mon Apr 22 11:36:27 PDT 2013
>
> and
>
> Quest Connector for Oracle and Hadoop 1.6
> <http://downloads.cloudera.com/connectors/oraoop-1.6.0-cdh4.tgz>
>
>
> 2013/9/4 Jarek Jarcec Cecho <ja...@apache.org>
>
> > Hi Alexey,
> > would you mind be a bit more specific? What exact version of Sqoop and
> > what exact version of OraOop are you using?
> >
> > Jarcec
> >
> > On Mon, Sep 02, 2013 at 03:11:23PM +0300, Alexey Filanovskiy wrote:
> > > Hi!
> > >
> > > 1.4
> > >
> > > Отправлено с iPad
> > >
> > > 02.09.2013, в 11:55, Jarek Jarcec Cecho <ja...@apache.org> написал(а):
> > >
> > > > 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
> >
>
>
>
> --
> С уважением,
> Филановский Алексей
Re: OraOop error: cannot be called unless RememberSqoopJobType() has
been used
Posted by Алексей Филановский <a....@gmail.com>.
Hi all!
[root@cdh ~]# sqoop version
Sqoop 1.4.2-cdh4.2.1
git commit id a0862dc56393e3096c65d6ca26766c67f5ab5309
Compiled by jenkins on Mon Apr 22 11:36:27 PDT 2013
and
Quest Connector for Oracle and Hadoop 1.6
<http://downloads.cloudera.com/connectors/oraoop-1.6.0-cdh4.tgz>
2013/9/4 Jarek Jarcec Cecho <ja...@apache.org>
> Hi Alexey,
> would you mind be a bit more specific? What exact version of Sqoop and
> what exact version of OraOop are you using?
>
> Jarcec
>
> On Mon, Sep 02, 2013 at 03:11:23PM +0300, Alexey Filanovskiy wrote:
> > Hi!
> >
> > 1.4
> >
> > Отправлено с iPad
> >
> > 02.09.2013, в 11:55, Jarek Jarcec Cecho <ja...@apache.org> написал(а):
> >
> > > 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
>
--
С уважением,
Филановский Алексей
Re: OraOop error: cannot be called unless RememberSqoopJobType() has
been used
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
Hi Alexey,
would you mind be a bit more specific? What exact version of Sqoop and what exact version of OraOop are you using?
Jarcec
On Mon, Sep 02, 2013 at 03:11:23PM +0300, Alexey Filanovskiy wrote:
> Hi!
>
> 1.4
>
> Отправлено с iPad
>
> 02.09.2013, в 11:55, Jarek Jarcec Cecho <ja...@apache.org> написал(а):
>
> > 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
Re: OraOop error: cannot be called unless RememberSqoopJobType() has been used
Posted by Alexey Filanovskiy <a....@gmail.com>.
Hi!
1.4
Отправлено с iPad
02.09.2013, в 11:55, Jarek Jarcec Cecho <ja...@apache.org> написал(а):
> 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
Re: OraOop error: cannot be called unless RememberSqoopJobType() has
been used
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
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
Re: OraOop error: cannot be called unless RememberSqoopJobType() has
been used
Posted by Venkat Ranganathan <vr...@hortonworks.com>.
Hi Алексей Филановский
For OraOop issues, I would suggest posting to the Toad forums
http://www.toadworld.com/products/toad-for-cloud-databases/default.aspx
Thanks
Venkat
On Fri, Aug 30, 2013 at 12:55 AM, Алексей Филановский <
a.filanovskiy@gmail.com> 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
>
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.