Ajit Koti created OOZIE-2010:
--------------------------------
Summary: Sqoop + DB2 Connection Close Error
Key: OOZIE-2010
URL: https://issues.apache.org/jira/browse/OOZIE-2010
Project: Oozie
Issue Type: Bug
Components: action
Affects Versions: 4.0.1
Reporter: Ajit Koti
Sqoop retrieves the data from DB2 and when Sqoop tries to close the
connection, it throws the below warning,
I am using db2jcc4.jar , sqoop 1.4.2, Will also try with the latest version
14/09/15 16:30:39 INFO mapreduce.ImportJobBase: Transferred 24.4863 KB in
14.0591 seconds (1.7417 KB/sec)
14/09/15 16:30:39 INFO mapreduce.ImportJobBase: Retrieved 578 records.
14/09/15 16:30:39 INFO util.AppendUtils: Appending to directory test
14/09/15 16:30:39 INFO util.AppendUtils: Using found partition 36
14/09/15 16:30:39 INFO tool.ImportTool: Saving incremental import state to the
metastore
14/09/15 16:30:39 INFO tool.ImportTool: Updated data for job: db2_test_fetch44
14/09/15 16:30:39 WARN tool.BaseSqoopTool: Error while closing connection:
com.ibm.db2.jcc.am.SqlException: [jcc][t4][10251][10308][4.14.119]
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
