[
https://issues.apache.org/jira/browse/SQOOP-1117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13999283#comment-13999283
]
ASF subversion and git services commented on SQOOP-1117:
--------------------------------------------------------
Commit 72e3bfdd6677f8630678d8aa94da7a8652692033 in sqoop's branch
refs/heads/trunk from [~jarcec]
[ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=72e3bfd ]
SQOOP-1117: when failed to import a non-existing table, the failure information
includes NullPointerException
(sam liu via Jarek Jarcec Cecho)
> when failed to import a non-existing table, the failure information includes
> NullPointerException
> -------------------------------------------------------------------------------------------------
>
> Key: SQOOP-1117
> URL: https://issues.apache.org/jira/browse/SQOOP-1117
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Affects Versions: 1.4.3
> Environment: RHEL 5.4
> Reporter: sam liu
> Priority: Minor
> Fix For: 1.4.5
>
> Attachments: SQOOP-1117.patch
>
>
> when failed to import a non-existing table, the returned failure information
> includes java.lang.NullPointerException which customer does not care about.
> These exception might confuse customers.
> a) command:
> {code}
> sqoop import --connect jdbc:db2://hostname:50000/SAMPLE --table
> DB2ADMIN.DB2TEST_TBL1001 --username sam --password pwd -m 1 --target-dir
> /tmp/DB2TEST_TBL001_0620_f
> {code}
> b) result:
> {code}
> 13/06/26 22:39:50 WARN tool.BaseSqoopTool: Setting your password on the
> command-line is insecure. Consider using -P instead.
> 13/06/26 22:39:50 INFO manager.SqlManager: Using default fetchSize of 1000
> 13/06/26 22:39:50 INFO tool.CodeGenTool: Beginning code generation
> 13/06/26 22:39:53 INFO manager.SqlManager: Executing SQL statement: SELECT
> t.* FROM DB2ADMIN.DB2TEST_TBL1001 AS t WHERE 1=0
> 13/06/26 22:39:53 ERROR manager.SqlManager: Error executing statement:
> com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204,
> SQLSTATE=42704, SQLERRMC=DB2ADMIN.DB2TEST_TBL1001, DRIVER=4.12.55
> com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204,
> SQLSTATE=42704, SQLERRMC=DB2ADMIN.DB2TEST_TBL1001, DRIVER=4.12.55
> at com.ibm.db2.jcc.am.hd.a(hd.java:676)
> at com.ibm.db2.jcc.am.hd.a(hd.java:60)
> at com.ibm.db2.jcc.am.hd.a(hd.java:127)
> at com.ibm.db2.jcc.am.mn.c(mn.java:2621)
> at com.ibm.db2.jcc.am.mn.d(mn.java:2609)
> at com.ibm.db2.jcc.am.mn.a(mn.java:2085)
> at com.ibm.db2.jcc.am.nn.a(nn.java:7054)
> at com.ibm.db2.jcc.t4.cb.g(cb.java:141)
> at com.ibm.db2.jcc.t4.cb.a(cb.java:41)
> at com.ibm.db2.jcc.t4.q.a(q.java:32)
> at com.ibm.db2.jcc.t4.rb.i(rb.java:135)
> at com.ibm.db2.jcc.am.mn.ib(mn.java:2055)
> at com.ibm.db2.jcc.am.nn.rc(nn.java:3219)
> at com.ibm.db2.jcc.am.nn.b(nn.java:4002)
> at com.ibm.db2.jcc.am.nn.ec(nn.java:728)
> at com.ibm.db2.jcc.am.nn.executeQuery(nn.java:698)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:539)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:548)
> at
> org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:191)
> at
> org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:175)
> at
> org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:262)
> at
> org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1235)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1060)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> 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:65)
> 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)
> 13/06/26 22:39:53 INFO manager.SqlManager: Executing SQL statement: SELECT
> t.* FROM DB2ADMIN.DB2TEST_TBL1001 AS t WHERE 1=0
> 13/06/26 22:39:53 ERROR manager.SqlManager: Error executing statement:
> com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204,
> SQLSTATE=42704, SQLERRMC=DB2ADMIN.DB2TEST_TBL1001, DRIVER=4.12.55
> com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204,
> SQLSTATE=42704, SQLERRMC=DB2ADMIN.DB2TEST_TBL1001, DRIVER=4.12.55
> at com.ibm.db2.jcc.am.hd.a(hd.java:676)
> at com.ibm.db2.jcc.am.hd.a(hd.java:60)
> at com.ibm.db2.jcc.am.hd.a(hd.java:127)
> at com.ibm.db2.jcc.am.mn.c(mn.java:2621)
> at com.ibm.db2.jcc.am.mn.d(mn.java:2609)
> at com.ibm.db2.jcc.am.mn.a(mn.java:2085)
> at com.ibm.db2.jcc.am.nn.a(nn.java:7054)
> at com.ibm.db2.jcc.t4.cb.g(cb.java:141)
> at com.ibm.db2.jcc.t4.cb.a(cb.java:41)
> at com.ibm.db2.jcc.t4.q.a(q.java:32)
> at com.ibm.db2.jcc.t4.rb.i(rb.java:135)
> at com.ibm.db2.jcc.am.mn.ib(mn.java:2055)
> at com.ibm.db2.jcc.am.nn.rc(nn.java:3219)
> at com.ibm.db2.jcc.am.nn.b(nn.java:4002)
> at com.ibm.db2.jcc.am.nn.ec(nn.java:728)
> at com.ibm.db2.jcc.am.nn.executeQuery(nn.java:698)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:539)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:548)
> at
> org.apache.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:126)
> at
> org.apache.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:110)
> at
> org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1207)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1062)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> 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:65)
> 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)
> 13/06/26 22:39:53 WARN tool.BaseSqoopTool: Error while closing connection:
> com.ibm.db2.jcc.am.SqlException: [jcc][t4][10251][10308][4.12.55]
> java.sql.Connection.close() requested while a transaction is in progress on
> the connection.
> The transaction remains active, and the connection cannot be closed.
> ERRORCODE=-4471, SQLSTATE=null
> 13/06/26 22:39:53 ERROR sqoop.Sqoop: Got exception running Sqoop:
> java.lang.NullPointerException
> java.lang.NullPointerException
> at
> org.apache.sqoop.orm.ClassWriter.cleanColNames(ClassWriter.java:1045)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1066)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> 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:65)
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
