[
https://issues.apache.org/jira/browse/SQOOP-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14281815#comment-14281815
]
DeepakVohra commented on SQOOP-1278:
------------------------------------
The issue is indicated as fixed in 1.4.5 but getting the following error with
Sqoop 1.4.5.
java.sql.SQLException: SQLite supports only TRANSACTION_SERIALIZABLE and
TRANSACTION_READ_UNCOMMITTED.
> Allow use of uncommitted isolation for databases that support it as an import
> option
> ------------------------------------------------------------------------------------
>
> Key: SQOOP-1278
> URL: https://issues.apache.org/jira/browse/SQOOP-1278
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.4.3, 1.4.4
> Environment: All DBs that support uncommitted read transaction
> isolation
> Reporter: Venkat Ranganathan
> Assignee: Venkat Ranganathan
> Fix For: 1.4.5
>
> Attachments: SQOOP-1278-3.diff, SQOOP-1278.diff
>
>
> Some customers might have ETL workflows that depend on data to be imported
> while the table is otherwise available for the regular data processing.
> The current read committed isolation can cause failure because of locking
> semantics used in the database systems used also.
> So, this is to provide a relaxation of the connection isolation used by the
> mappers to be read uncommitted using a sqoop option. Note that read
> uncommitted is not a valid option for Oracle so it is not supported with the
> database and will be ignored for Oracle
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
