Sqoop
  1. Sqoop
  2. SQOOP-461

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

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.1-incubating
    • Fix Version/s: 1.4.2
    • Component/s: docs
    • Labels:
      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.

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

        Issue Links

          Activity

          Hide
          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

          Show
          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
          Hide
          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

          Show
          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
          Hide
          Kathleen Ting added a comment -

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

          Show
          Kathleen Ting added a comment - Thanks Arvind for the feedback, which I've incorporated in the attached file SQOOP-461 -1.patch.
          Hide
          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

          Show
          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
          Hide
          Arvind Prabhakar added a comment -

          Patch committed. Thanks Kathleen!

          Show
          Arvind Prabhakar added a comment - Patch committed. Thanks Kathleen!
          Hide
          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

          Show
          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
          Hide
          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
          Show
          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

            • Assignee:
              Kathleen Ting
              Reporter:
              Kathleen Ting
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development