Unable to import data from Informix non transactional database

samant_thakur — Tue, 28 Aug 2018 19:26:28 GMT

Hi There,

I am trying to import data from Informix non transactional database to HDFS but getting below error..Our database is defined as non transactional. Is there any way by which we can import data from non transactional DB through sqoop ?

I know this issue has already been raised below.

https://issues.apache.org/jira/browse/SQOOP-2951

sqoop list-tables --connect jdbc:informix-sqli://XXX:1530/XXX:INFORMIXSERVER=XXX --driver com.informix.jdbc.IfxDriver --username XXX --P

 ERROR manager.SqlManager: Error reading database metadata: java.sql.SQLException: No Transaction Isolation on non-logging db's
java.sql.SQLException: No Transaction Isolation on non-logging db's
        at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
        at com.informix.jdbc.IfxSqliConnect.setTransactionIsolation(IfxSqliConnect.java:2438)
        at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:910)
        at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
        at org.apache.sqoop.manager.SqlManager.listTables(SqlManager.java:539)
        at org.apache.sqoop.tool.ListTablesTool.run(ListTablesTool.java:49)
        at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225)
        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
        at org.apache.sqoop.Sqoop.main(Sqoop.java:243)
Could not retrieve tables list from server

Re: Unable to import data from Informix non transactional database

ssubhas — Tue, 28 Aug 2018 19:38:46 GMT

@Samant Thakur

This is a limitation from Sqoop end that operation on any non-transactional is not supported. Refer to below link to enable transaction logging on Informix and then, try Sqoop.

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqlt.doc/ids_sqt_279.htm

Re: Unable to import data from Informix non transactional database

samant_thakur — Thu, 30 Aug 2018 15:23:26 GMT

@Sindhu

Thank you!

question Re: Unable to import data from Informix non transactional database in Archives of Support Questions (Read Only)

Unable to import data from Informix non transactional database

Re: Unable to import data from Informix non transactional database

Re: Unable to import data from Informix non transactional database