[
https://issues.apache.org/jira/browse/SQOOP-2951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15822376#comment-15822376
]
Li Cui commented on SQOOP-2951:
-------------------------------
Any update on this please? workaround/temp fix, etc?
I tried the following:
1. --relaxed-isolation,
2. use connection-param-file to pass
"jdbc.transaction.isolation=TRANSACTION_READ_COMMITTED"
3. use connection-param-file to pass
"jdbc.transaction.isolation=TRANSACTION_READ_UNCOMMITTED"
4. use connection-param-file to pass
"jdbc.transaction.isolation=TRANSACTION_SERIALIZABLE "
Got the same results: "ERROR manager.SqlManager: Error reading database
metadata: java.sql.SQLException: No Transaction Isolation on non-logging db's"
This is sqoop 1.4.6 with informix Informix 11.50.FC7 on Sun Solaris 5.10
Thanks
> 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)
