[
https://issues.apache.org/jira/browse/SQOOP-2951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15996125#comment-15996125
]
Naveen Kumar commented on SQOOP-2951:
-------------------------------------
[~selvat] I'm also facing same issue from sqoop. Tried with beeline and it is
working, thought it is showing same Error: No Transaction Isolation on
non-logging db's (state=IX000,code=-79746) .
copied ifx* jars in $HIVE_HOME/lib directory and connected using beeline -u "
jdbc:informix-sqli://xx.xxx.xx.xxx:50000/abc:INFORMIXSERVER=xyz;user=XXX;password=XXXX"
> 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.15#6346)