[
https://issues.apache.org/jira/browse/SQOOP-2951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15819955#comment-15819955
]
Li Cui commented on SQOOP-2951:
-------------------------------
I got the same problem when trying sqoop on informix database, and fix or
workaround for this issue?
=========================================
> sqoop eval \
> --driver com.informix.jdbc.IfxDriver \
> --connect
> "jdbc:informix-sqli://xx.xx.xx.xxx:xxxxxx/dbname:informixserver=dbname_1233abcd;DB_LOCAL=en_US.57372"
> \
> --username username \
> -P \
> --query "select count(*) from call_rec";
Warning:
/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/bin/../lib/sqoop/../accumulo
does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/01/11 21:01:08 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.9.0
Enter password:
17/01/11 21:01:21 WARN sqoop.ConnFactory: Parameter --driver is set to an
explicit driver however appropriate connection manager is not being set (via
--connection-manager). Sqoop is going to fall back to
org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which
connection manager should be used next time.
17/01/11 21:01:21 INFO manager.SqlManager: Using default fetchSize of 1000
17/01/11 21:01:23 WARN tool.EvalSqlTool: SQL exception executing statement:
java.sql.SQLException: No Transaction Isolation on non-logging db's
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:407)
at
com.informix.jdbc.IfxSqliConnect.setTransactionIsolation(IfxSqliConnect.java:2764)
at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:910)
at
org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
at org.apache.sqoop.tool.EvalSqlTool.run(EvalSqlTool.java:64)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
> sqoop list-tables \
> --driver com.informix.jdbc.IfxDriver \
> --connect
> "jdbc:informix-sqli://xx.xx.xx.xxx:xxxxxx/dbname:informixserver=dbname_1233abcd"
> \
> --username username \
> -P ;
Warning:
/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/bin/../lib/sqoop/../accumulo
does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/01/11 21:01:56 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.9.0
Enter password:
17/01/11 21:02:05 WARN sqoop.ConnFactory: Parameter --driver is set to an
explicit driver however appropriate connection manager is not being set (via
--connection-manager). Sqoop is going to fall back to
org.apache.sqoop.manager.GenericJdbcManager. Please specify explicitly which
connection manager should be used next time.
17/01/11 21:02:05 INFO manager.SqlManager: Using default fetchSize of 1000
17/01/11 21:02:06 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:407)
at
com.informix.jdbc.IfxSqliConnect.setTransactionIsolation(IfxSqliConnect.java:2764)
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:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Could not retrieve tables list from server
17/01/11 21:02:06 ERROR tool.ListTablesTool: manager.listTables() returned null
> Not able to use sqoop command on DB where logging disabled
> ----------------------------------------------------------
>
> Key: SQOOP-2951
> URL: https://issues.apache.org/jira/browse/SQOOP-2951
> Project: Sqoop
> Issue Type: Wish
> Components: connectors
> Reporter: Ravikumar Ranga
>
> How to connect a database which is kind of un-logging (Transaction logging
> disabled) from sqoop.With Normal command if I try to connect such DB getting
> error.
> Syntax of command that been used.
> sqoop list-tables --driver com.informix.jdbc.IfxDriver --connect
> "jdbc:informix-sqli://XX.XX.XX.22:44XX/pdr:INFORMIXSERVER=zfindvXXX_x"
> --username l407 --password XXXX
> Error
> ERROR manager.SqlManager: Error reading database metadata:
> java.sql.SQLException: No Transaction Isolation on non-logging db's
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
