[SQOOP-2980] Export to DB2 z/OS fails unless --batch mode is used

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.6
• Fix Version/s: 1.5.0
• Component/s: connectors
• Assignee: Unassigned
• Reporter: Senthil Ganesh
• Created: 30/Jun/16 10:41
• Updated: 30/Oct/17 14:10

Description

Export fails for DB2 Z/OS without --batch option with the below error

java.lang.Exception: java.io.IOException: com.ibm.db2.jcc.am.SqlException: [jcc][t4][10251][10308][4.19.49] java.sql.Connection.close() requested while a transaction is in progress on the connection.
May 25, 2016 8:14:37 PM, eMSG_TRACE, TASK_140119021643520-MAPPING, APPSDK_Msg_1762, [TRACE] The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null
at org.apache.hadoop.mapred.LocalJobRunner$Job.runTasks(LocalJobRunner.java:462)
at org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:522)
May 25, 2016 8:14:37 PM, eMSG_TRACE, TASK_140119021643520-MAPPING, APPSDK_Msg_1762, [TRACE] Caused by: java.io.IOException: com.ibm.db2.jcc.am.SqlException: [jcc][t4][10251][10308][4.19.49] java.sql.Connection.close() requested while a transaction is in progress on the connection.
May 25, 2016 8:14:37 PM, eMSG_TRACE, TASK_140119021643520-MAPPING, APPSDK_Msg_1762, [TRACE] The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null
at org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.close(AsyncSqlRecordWriter.java:211)
at org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.close(MapTask.java:670)
at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:793)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341)
at org.apache.hadoop.mapred.LocalJobRunner$Job$MapTaskRunnable.run(LocalJobRunner.java:243)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)