sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ajit Koti <ajitk...@gmail.com>
Subject Re: Sqoop + DB2 Connection Close Error
Date Tue, 16 Sep 2014 00:38:59 GMT
Thanks for the response will try that out.

Ajit
Sorry, i don't have any experience with DB2, but i guess you can try the
latest version of sqoop (1.4.5).
Another thing is you can pass the --verbose flag to get more details.

~Pratik

On Mon, Sep 15, 2014 at 3:01 PM, Ajit Koti <ajitkoti@gmail.com> wrote:

> Hi,
>
>
> I am using db2jcc4.jar , sqoop 1.4.2,
> When sqoop tries to close the connection, it throws the below warning,
>
>
>
> 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
>
>
> Has anyone faced it before , any workarounds and any suggestion would be
> helpful.
>
> Thanks
> Ajit
>

Mime
View raw message