Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-1029

Oracle export using procedures does not work

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.3
    • Fix Version/s: 1.4.4
    • Component/s: connectors/oracle
    • Labels:
      None
    • Environment:

      Sqoop 1.4.3

      Description

      The procedure call feature implementation depends on DatabaseMetadata columns but some parts of it implementation defined. THe Ordinal number used to identify the columns differ and in the case of Oracle ordinal 0 is the first column and because of this call using procedure fails on Oracle

      1. SQOOP-1029.patch
        4 kB
        Venkat Ranganathan
      2. SQOOP-1029.patch.2
        6 kB
        Venkat Ranganathan

        Issue Links

          Activity

          Hide
          venkatnrangan Venkat Ranganathan added a comment -

          Thanks Jarek for reviewing. Please see the latest patch attached.

          Show
          venkatnrangan Venkat Ranganathan added a comment - Thanks Jarek for reviewing. Please see the latest patch attached.
          Hide
          jarcec Jarek Jarcec Cecho added a comment -
          Show
          jarcec Jarek Jarcec Cecho added a comment - The patch is in: https://git-wip-us.apache.org/repos/asf?p=sqoop.git;a=commit;h=e76ee6eea5aa3afcfe496967a6280540576e9420 Thank you Venkat for your contribution! Jarcec
          Hide
          hudson Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop23 #842 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/842/)
          SQOOP-1029: Oracle export using procedures does not work (Revision e76ee6eea5aa3afcfe496967a6280540576e9420)

          Result = SUCCESS
          jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e76ee6eea5aa3afcfe496967a6280540576e9420
          Files :

          • src/java/org/apache/sqoop/manager/SqlManager.java
          • src/java/org/apache/sqoop/manager/OracleManager.java
          Show
          hudson Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop23 #842 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop23/842/ ) SQOOP-1029 : Oracle export using procedures does not work (Revision e76ee6eea5aa3afcfe496967a6280540576e9420) Result = SUCCESS jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e76ee6eea5aa3afcfe496967a6280540576e9420 Files : src/java/org/apache/sqoop/manager/SqlManager.java src/java/org/apache/sqoop/manager/OracleManager.java
          Hide
          hudson Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop20 #634 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/634/)
          SQOOP-1029: Oracle export using procedures does not work (Revision e76ee6eea5aa3afcfe496967a6280540576e9420)

          Result = SUCCESS
          jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e76ee6eea5aa3afcfe496967a6280540576e9420
          Files :

          • src/java/org/apache/sqoop/manager/OracleManager.java
          • src/java/org/apache/sqoop/manager/SqlManager.java
          Show
          hudson Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop20 #634 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop20/634/ ) SQOOP-1029 : Oracle export using procedures does not work (Revision e76ee6eea5aa3afcfe496967a6280540576e9420) Result = SUCCESS jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e76ee6eea5aa3afcfe496967a6280540576e9420 Files : src/java/org/apache/sqoop/manager/OracleManager.java src/java/org/apache/sqoop/manager/SqlManager.java
          Hide
          hudson Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop100 #638 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/638/)
          SQOOP-1029: Oracle export using procedures does not work (Revision e76ee6eea5aa3afcfe496967a6280540576e9420)

          Result = SUCCESS
          jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e76ee6eea5aa3afcfe496967a6280540576e9420
          Files :

          • src/java/org/apache/sqoop/manager/OracleManager.java
          • src/java/org/apache/sqoop/manager/SqlManager.java
          Show
          hudson Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop100 #638 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop100/638/ ) SQOOP-1029 : Oracle export using procedures does not work (Revision e76ee6eea5aa3afcfe496967a6280540576e9420) Result = SUCCESS jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e76ee6eea5aa3afcfe496967a6280540576e9420 Files : src/java/org/apache/sqoop/manager/OracleManager.java src/java/org/apache/sqoop/manager/SqlManager.java
          Hide
          hudson Hudson added a comment -

          Integrated in Sqoop-ant-jdk-1.6-hadoop200 #635 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop200/635/)
          SQOOP-1029: Oracle export using procedures does not work (Revision e76ee6eea5aa3afcfe496967a6280540576e9420)

          Result = SUCCESS
          jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e76ee6eea5aa3afcfe496967a6280540576e9420
          Files :

          • src/java/org/apache/sqoop/manager/OracleManager.java
          • src/java/org/apache/sqoop/manager/SqlManager.java
          Show
          hudson Hudson added a comment - Integrated in Sqoop-ant-jdk-1.6-hadoop200 #635 (See https://builds.apache.org/job/Sqoop-ant-jdk-1.6-hadoop200/635/ ) SQOOP-1029 : Oracle export using procedures does not work (Revision e76ee6eea5aa3afcfe496967a6280540576e9420) Result = SUCCESS jarcec : https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=e76ee6eea5aa3afcfe496967a6280540576e9420 Files : src/java/org/apache/sqoop/manager/OracleManager.java src/java/org/apache/sqoop/manager/SqlManager.java

            People

            • Assignee:
              venkatnrangan Venkat Ranganathan
              Reporter:
              venkatnrangan Venkat Ranganathan
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development