[
https://issues.apache.org/jira/browse/SQOOP-2980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Attila Szabo updated SQOOP-2980:
--------------------------------
Fix Version/s: (was: 1.4.7)
1.5.0
> 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.5.0
>
>
> 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.4.14#64029)
