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

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development