[
https://issues.apache.org/jira/browse/SQOOP-2951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16710712#comment-16710712
]
Manoj Durisheti commented on SQOOP-2951:
----------------------------------------
Hi, Any update on this or any workaround please?
Command and Error:
sqoop list-tables --driver com.informix.jdbc.IfxDriver --connect
jdbc:informix-sqli://HOST.dev.lcl:50001/abc:informixserver=abc_HOST --username
sqoopx --password xxxxx
18/12/05 14:30:02 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.buildException(IfxErrMsg.java:474)
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:443)
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:394)
at
com.informix.jdbc.IfxSqliConnect.setTransactionIsolation(IfxSqliConnect.java:3041)
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
18/12/05 14:30:02 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
> Priority: Major
>
> 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
(v7.6.3#76005)
