Sqoop
  1. Sqoop
  2. SQOOP-1178

Sqoop2: get connections for connector columns out of order

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.99.2
    • Fix Version/s: 1.99.3
    • Component/s: None
    • Labels:
      None

      Description

      Compare the select statement with how it's used:

        // DML: Select all connections for a specific connector.
        public static final String STMT_SELECT_CONNECTION_FOR_CONNECTOR =
          "SELECT "
          + COLUMN_SQN_ID + ", "
          + COLUMN_SQN_NAME + ", "
          + COLUMN_SQN_CONNECTOR + ", "
          + COLUMN_SQN_CREATION_USER + ", "
          + COLUMN_SQN_CREATION_DATE + ", "
          + COLUMN_SQN_ENABLED + ", "
          + COLUMN_SQN_UPDATE_USER + ", "
          + COLUMN_SQN_UPDATE_DATE
          + " FROM " + TABLE_SQ_CONNECTION
          + " WHERE " + COLUMN_SQN_CONNECTOR + " = ?";
      
      long id = rsConnection.getLong(1);
      String name = rsConnection.getString(2);
      long connectorId = rsConnection.getLong(3);
      boolean enabled = rsConnection.getBoolean(4);
      String creationUser = rsConnection.getString(5);
      Date creationDate = rsConnection.getTimestamp(6);
      String updateUser = rsConnection.getString(7);
      Date lastUpdateDate = rsConnection.getTimestamp(8);
      

      The column "enabled" is misplaced.

      1. SQOOP-1178.0.patch
        0.8 kB
        Abraham Elmahrek

        Issue Links

          Activity

          Hide
          ASF subversion and git services added a comment -

          Commit 22f6ca5a403e4690749bf5e0427e744c39d1a884 in branch refs/heads/sqoop2 from Jarek Jarcec Cecho
          [ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=22f6ca5 ]

          SQOOP-1178: Sqoop2: get connections for connector columns out of order

          (Abraham Elmahrek via Jarek Jarcec Cecho)

          Show
          ASF subversion and git services added a comment - Commit 22f6ca5a403e4690749bf5e0427e744c39d1a884 in branch refs/heads/sqoop2 from Jarek Jarcec Cecho [ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=22f6ca5 ] SQOOP-1178 : Sqoop2: get connections for connector columns out of order (Abraham Elmahrek via Jarek Jarcec Cecho)
          Hide
          Jarek Jarcec Cecho added a comment -

          Excellent catch Abraham Elmahrek! Thank you very much for fixing it!

          Show
          Jarek Jarcec Cecho added a comment - Excellent catch Abraham Elmahrek ! Thank you very much for fixing it!
          Hide
          Hudson added a comment -

          SUCCESS: Integrated in Sqoop2-hadoop200 #497 (See https://builds.apache.org/job/Sqoop2-hadoop200/497/)
          SQOOP-1178: Sqoop2: get connections for connector columns out of order (jarcec: https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=22f6ca5a403e4690749bf5e0427e744c39d1a884)

          • repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
          Show
          Hudson added a comment - SUCCESS: Integrated in Sqoop2-hadoop200 #497 (See https://builds.apache.org/job/Sqoop2-hadoop200/497/ ) SQOOP-1178 : Sqoop2: get connections for connector columns out of order (jarcec: https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=22f6ca5a403e4690749bf5e0427e744c39d1a884 ) repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
          Hide
          Hudson added a comment -

          SUCCESS: Integrated in Sqoop2-hadoop100 #558 (See https://builds.apache.org/job/Sqoop2-hadoop100/558/)
          SQOOP-1178: Sqoop2: get connections for connector columns out of order (jarcec: https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=22f6ca5a403e4690749bf5e0427e744c39d1a884)

          • repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java
          Show
          Hudson added a comment - SUCCESS: Integrated in Sqoop2-hadoop100 #558 (See https://builds.apache.org/job/Sqoop2-hadoop100/558/ ) SQOOP-1178 : Sqoop2: get connections for connector columns out of order (jarcec: https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=22f6ca5a403e4690749bf5e0427e744c39d1a884 ) repository/repository-derby/src/main/java/org/apache/sqoop/repository/derby/DerbySchemaQuery.java

            People

            • Assignee:
              Abraham Elmahrek
              Reporter:
              Abraham Elmahrek
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development