Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-461

Sqoop User Guide's troubleshooting section should include Oracle Connection Errors

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.4.1-incubating
    • 1.4.2
    • docs
    • None

    Description

      While working with Oracle you may encounter the below problem when the Sqoop command explicitly specifies the --driver oracle.jdbc.driver.OracleDriver option. When the driver option is included in the Sqoop command, the built-in connection manager selection defaults to the generic connection manager, which is not the intended Oracle driver. This is because if the driver option is not specified, the built-in Oracle connection manager will chose the very driver that is being passed in. It would be helpful if this was documented in the troubleshooting section of the Sqoop User Guide.

      Attachments

        1. SQOOP-461-1.patch
          1 kB
          Kathleen Ting
        2. SQOOP-461.patch
          1 kB
          Kathleen Ting

        Issue Links

          Activity

            -----------------------------------------------------------
            This is an automatically generated e-mail. To reply, visit:
            https://reviews.apache.org/r/4287/
            -----------------------------------------------------------

            Review request for Sqoop and Arvind Prabhakar.

            Summary
            -------

            Updated Documentation.

            This addresses bug SQOOP-461.
            https://issues.apache.org/jira/browse/SQOOP-461

            Diffs


            ./src/docs/user/troubleshooting.txt 1299394

            Diff: https://reviews.apache.org/r/4287/diff

            Testing
            -------

            Built docs and verified.

            Thanks,

            Kathleen

            jiraposter@reviews.apache.org jiraposter@reviews.apache.org added a comment - ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/4287/ ----------------------------------------------------------- Review request for Sqoop and Arvind Prabhakar. Summary ------- Updated Documentation. This addresses bug SQOOP-461 . https://issues.apache.org/jira/browse/SQOOP-461 Diffs ./src/docs/user/troubleshooting.txt 1299394 Diff: https://reviews.apache.org/r/4287/diff Testing ------- Built docs and verified. Thanks, Kathleen

            -----------------------------------------------------------
            This is an automatically generated e-mail. To reply, visit:
            https://reviews.apache.org/r/4287/#review5833
            -----------------------------------------------------------

            Thanks for the patch Kathleen. Changes look good, one minor suggestion below for you to consider:

            ./src/docs/user/troubleshooting.txt
            <https://reviews.apache.org/r/4287/#comment12735>

            The error is more of a SQL syntax error instead of a connection error.

            I suggest that you modify the title to:

            Oracle: ORA-00933 error (SQL command not properly ended)

            • Arvind

            On 2012-03-11 17:14:43, Kathleen Ting wrote:

            -----------------------------------------------------------

            This is an automatically generated e-mail. To reply, visit:

            https://reviews.apache.org/r/4287/

            -----------------------------------------------------------

            (Updated 2012-03-11 17:14:43)

            Review request for Sqoop and Arvind Prabhakar.

            Summary

            -------

            Updated Documentation.

            This addresses bug SQOOP-461.

            https://issues.apache.org/jira/browse/SQOOP-461

            Diffs

            -----

            ./src/docs/user/troubleshooting.txt 1299394

            Diff: https://reviews.apache.org/r/4287/diff

            Testing

            -------

            Built docs and verified.

            Thanks,

            Kathleen

            jiraposter@reviews.apache.org jiraposter@reviews.apache.org added a comment - ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/4287/#review5833 ----------------------------------------------------------- Thanks for the patch Kathleen. Changes look good, one minor suggestion below for you to consider: ./src/docs/user/troubleshooting.txt < https://reviews.apache.org/r/4287/#comment12735 > The error is more of a SQL syntax error instead of a connection error. I suggest that you modify the title to: Oracle: ORA-00933 error (SQL command not properly ended) Arvind On 2012-03-11 17:14:43, Kathleen Ting wrote: ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/4287/ ----------------------------------------------------------- (Updated 2012-03-11 17:14:43) Review request for Sqoop and Arvind Prabhakar. Summary ------- Updated Documentation. This addresses bug SQOOP-461 . https://issues.apache.org/jira/browse/SQOOP-461 Diffs ----- ./src/docs/user/troubleshooting.txt 1299394 Diff: https://reviews.apache.org/r/4287/diff Testing ------- Built docs and verified. Thanks, Kathleen
            kathleen Kathleen Ting added a comment -

            Thanks Arvind for the feedback, which I've incorporated in the attached file SQOOP-461-1.patch.

            kathleen Kathleen Ting added a comment - Thanks Arvind for the feedback, which I've incorporated in the attached file SQOOP-461 -1.patch.

            -----------------------------------------------------------
            This is an automatically generated e-mail. To reply, visit:
            https://reviews.apache.org/r/4287/
            -----------------------------------------------------------

            (Updated 2012-03-12 18:18:58.435413)

            Review request for Sqoop and Arvind Prabhakar.

            Changes
            -------

            Thanks Arvind for your feedback, which I've incorporated.

            Summary
            -------

            Updated Documentation.

            This addresses bug SQOOP-461.
            https://issues.apache.org/jira/browse/SQOOP-461

            Diffs (updated)


            ./src/docs/user/troubleshooting.txt 1299737

            Diff: https://reviews.apache.org/r/4287/diff

            Testing
            -------

            Built docs and verified.

            Thanks,

            Kathleen

            jiraposter@reviews.apache.org jiraposter@reviews.apache.org added a comment - ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/4287/ ----------------------------------------------------------- (Updated 2012-03-12 18:18:58.435413) Review request for Sqoop and Arvind Prabhakar. Changes ------- Thanks Arvind for your feedback, which I've incorporated. Summary ------- Updated Documentation. This addresses bug SQOOP-461 . https://issues.apache.org/jira/browse/SQOOP-461 Diffs (updated) ./src/docs/user/troubleshooting.txt 1299737 Diff: https://reviews.apache.org/r/4287/diff Testing ------- Built docs and verified. Thanks, Kathleen

            Patch committed. Thanks Kathleen!

            aprabhakar Arvind Prabhakar added a comment - Patch committed. Thanks Kathleen!

            -----------------------------------------------------------
            This is an automatically generated e-mail. To reply, visit:
            https://reviews.apache.org/r/4287/#review5843
            -----------------------------------------------------------

            Ship it!

            +1

            • Arvind

            On 2012-03-12 18:18:58, Kathleen Ting wrote:

            -----------------------------------------------------------

            This is an automatically generated e-mail. To reply, visit:

            https://reviews.apache.org/r/4287/

            -----------------------------------------------------------

            (Updated 2012-03-12 18:18:58)

            Review request for Sqoop and Arvind Prabhakar.

            Summary

            -------

            Updated Documentation.

            This addresses bug SQOOP-461.

            https://issues.apache.org/jira/browse/SQOOP-461

            Diffs

            -----

            ./src/docs/user/troubleshooting.txt 1299737

            Diff: https://reviews.apache.org/r/4287/diff

            Testing

            -------

            Built docs and verified.

            Thanks,

            Kathleen

            jiraposter@reviews.apache.org jiraposter@reviews.apache.org added a comment - ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/4287/#review5843 ----------------------------------------------------------- Ship it! +1 Arvind On 2012-03-12 18:18:58, Kathleen Ting wrote: ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/4287/ ----------------------------------------------------------- (Updated 2012-03-12 18:18:58) Review request for Sqoop and Arvind Prabhakar. Summary ------- Updated Documentation. This addresses bug SQOOP-461 . https://issues.apache.org/jira/browse/SQOOP-461 Diffs ----- ./src/docs/user/troubleshooting.txt 1299737 Diff: https://reviews.apache.org/r/4287/diff Testing ------- Built docs and verified. Thanks, Kathleen
            hudson Hudson added a comment -

            Integrated in Sqoop-ant-jdk-1.6 #96 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6/96/)
            SQOOP-461. Adding Oracle error to troubleshooting section of user guide.

            (Kathleen Ting via Arvind Prabhakar) (Revision 1299784)

            Result = SUCCESS
            arvind : http://svn.apache.org/viewvc/?view=rev&rev=1299784
            Files :

            • /incubator/sqoop/trunk/src/docs/user/troubleshooting.txt
            hudson Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6 #96 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6/96/ ) SQOOP-461 . Adding Oracle error to troubleshooting section of user guide. (Kathleen Ting via Arvind Prabhakar) (Revision 1299784) Result = SUCCESS arvind : http://svn.apache.org/viewvc/?view=rev&rev=1299784 Files : /incubator/sqoop/trunk/src/docs/user/troubleshooting.txt

            People

              kathleen Kathleen Ting
              kathleen Kathleen Ting
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: