Senthil Ganesh created SQOOP-2980:
-------------------------------------
Summary: Export to DB2 z/OS fails unless --batch mode is used
Key: SQOOP-2980
URL: https://issues.apache.org/jira/browse/SQOOP-2980
Project: Sqoop
Issue Type: Bug
Components: connectors
Affects Versions: 1.4.6
Reporter: Senthil Ganesh
Fix For: 1.4.7
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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
