sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Li Cui (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-2951) Not able to use sqoop command on DB where logging disabled
Date Thu, 12 Jan 2017 02:39:17 GMT

    [ 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)

Mime
View raw message