You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Gwen Shapira (JIRA)" <ji...@apache.org> on 2014/11/09 19:10:36 UTC

[jira] [Commented] (SQOOP-1512) Refactor ConnectionRequestHandler and add ConfigurableRequestHandler

    [ https://issues.apache.org/jira/browse/SQOOP-1512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14204027#comment-14204027 ] 

Gwen Shapira commented on SQOOP-1512:
-------------------------------------

There's a patch here that was never committed? Why is the status "fixed".

I'm placing this at 1.99.4, but I'm really not sure what's going on here...

> Refactor ConnectionRequestHandler and add ConfigurableRequestHandler
> --------------------------------------------------------------------
>
>                 Key: SQOOP-1512
>                 URL: https://issues.apache.org/jira/browse/SQOOP-1512
>             Project: Sqoop
>          Issue Type: Sub-task
>            Reporter: Veena Basavaraj
>            Assignee: Veena Basavaraj
>             Fix For: 1.99.4
>
>         Attachments: SQOOP-1512And1514.patch
>
>
> the new JSON looks like this per connector
> {code}
> {  
>    "connector":[  
>       {  
>          "id":2,
>          "linkConfigValues":[  
>             {  
>                "id":4,
>                "inputs":[  
>                   {  
>                      "id":7,
>                      "name":"linkConfig.jdbcDriver",
>                      "type":"STRING",
>                      "size":128,
>                      "sensitive":false
>                   },
>                   {  
>                      "id":8,
>                      "name":"linkConfig.connectionString",
>                      "type":"STRING",
>                      "size":128,
>                      "sensitive":false
>                   },
>                   {  
>                      "id":9,
>                      "name":"linkConfig.username",
>                      "type":"STRING",
>                      "size":40,
>                      "sensitive":false
>                   },
>                   {  
>                      "id":10,
>                      "name":"linkConfig.password",
>                      "type":"STRING",
>                      "size":40,
>                      "sensitive":true
>                   },
>                   {  
>                      "id":11,
>                      "name":"linkConfig.jdbcProperties",
>                      "type":"MAP",
>                      "sensitive":false
>                   }
>                ],
>                "name":"linkConfig",
>                "type":"LINK"
>             }
>          ],
>          "config-params":{  
>             "linkConfig.jdbcProperties.help":"Enter any JDBC properties that should be supplied during the creation of connection.",
>             "ignored.label":"Ignored",
>             "fromJobConfig.partitionColumn.help":"A specific column for data partition",
>             "fromJobConfig.label":"From database configuration",
>             "fromJobConfig.schemaName.help":"Schema name to process data in the remote database",
>             "fromJobConfig.warehouse.label":"Data warehouse",
>             "linkConfig.connectionString.help":"Enter the value of JDBC connection string to be used by this connector for creating connections.",
>             "toJobConfig.tableName.label":"Table name",
>             "linkConfig.jdbcProperties.label":"JDBC Connection Properties",
>             "fromJobConfig.warehouse.help":"The root directory for data",
>             "fromJobConfig.partitionColumnNull.label":"Nulls in partition column",
>             "ignored.help":"This is completely ignored",
>             "linkConfig.jdbcDriver.help":"Enter the fully qualified class name of the JDBC driver that will be used for establishing this connection.",
>             "ignored.ignored.label":"Ignored",
>             "fromJobConfig.columns.label":"Table column names",
>             "toJobConfig.columns.label":"Table column names",
>             "fromJobConfig.partitionColumn.label":"Partition column name",
>             "toJobConfig.tableName.help":"Table name to process data in the remote database",
>             "toJobConfig.clearStageTable.label":"Clear stage table",
>             "fromJobConfig.boundaryQuery.label":"Boundary query",
>             "fromJobConfig.columns.help":"Specific columns of a table name or a table SQL",
>             "ignored.ignored.help":"This is completely ignored",
>             "linkConfig.username.label":"Username",
>             "toJobConfig.clearStageTable.help":"Indicate if the stage table should be cleared",
>             "toJobConfig.sql.label":"Table SQL statement",
>             "toJobConfig.stageTableName.label":"Stage table name",
>             "toJobConfig.help":"You must supply the information requested in order to create a job object.",
>             "toJobConfig.columns.help":"Specific columns of a table name or a table SQL",
>             "linkConfig.jdbcDriver.label":"JDBC Driver Class",
>             "fromJobConfig.help":"You must supply the information requested in order to create a job object.",
>             "toJobConfig.sql.help":"SQL statement to process data in the remote database",
>             "toJobConfig.label":"To database configuration",
>             "fromJobConfig.dataDirectory.help":"The sub-directory under warehouse for data",
>             "toJobConfig.schemaName.help":"Schema name to process data in the remote database",
>             "fromJobConfig.sql.help":"SQL statement to process data in the remote database",
>             "fromJobConfig.schemaName.label":"Schema name",
>             "fromJobConfig.tableName.help":"Table name to process data in the remote database",
>             "toJobConfig.stageTableName.help":"Name of the stage table to use",
>             "fromJobConfig.sql.label":"Table SQL statement",
>             "fromJobConfig.boundaryQuery.help":"The boundary query for data partition",
>             "fromJobConfig.dataDirectory.label":"Data directory",
>             "linkConfig.username.help":"Enter the username to be used for connecting to the database.",
>             "fromJobConfig.partitionColumnNull.help":"Whether there are null values in partition column",
>             "linkConfig.password.help":"Enter the password to be used for connecting to the database.",
>             "fromJobConfig.tableName.label":"Table name",
>             "toJobConfig.schemaName.label":"Schema name",
>             "linkConfig.label":"Link configuration",
>             "linkConfig.help":"You must supply the information requested in order to create a connection object.",
>             "linkConfig.password.label":"Password",
>             "linkConfig.connectionString.label":"JDBC Connection String"
>          },
>          "name":"generic-jdbc-connector",
>          "class":"org.apache.sqoop.connector.jdbc.GenericJdbcConnector",
>          "jobConfigValues":{  
>             "FROM":[  
>                {  
>                   "id":5,
>                   "inputs":[  
>                      {  
>                         "id":12,
>                         "name":"fromJobConfig.schemaName",
>                         "type":"STRING",
>                         "size":50,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":13,
>                         "name":"fromJobConfig.tableName",
>                         "type":"STRING",
>                         "size":50,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":14,
>                         "name":"fromJobConfig.sql",
>                         "type":"STRING",
>                         "size":2000,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":15,
>                         "name":"fromJobConfig.columns",
>                         "type":"STRING",
>                         "size":50,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":16,
>                         "name":"fromJobConfig.partitionColumn",
>                         "type":"STRING",
>                         "size":50,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":17,
>                         "name":"fromJobConfig.partitionColumnNull",
>                         "type":"BOOLEAN",
>                         "sensitive":false
>                      },
>                      {  
>                         "id":18,
>                         "name":"fromJobConfig.boundaryQuery",
>                         "type":"STRING",
>                         "size":50,
>                         "sensitive":false
>                      }
>                   ],
>                   "name":"fromJobConfig",
>                   "type":"JOB"
>                }
>             ],
>             "TO":[  
>                {  
>                   "id":6,
>                   "inputs":[  
>                      {  
>                         "id":19,
>                         "name":"toJobConfig.schemaName",
>                         "type":"STRING",
>                         "size":50,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":20,
>                         "name":"toJobConfig.tableName",
>                         "type":"STRING",
>                         "size":2000,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":21,
>                         "name":"toJobConfig.sql",
>                         "type":"STRING",
>                         "size":50,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":22,
>                         "name":"toJobConfig.columns",
>                         "type":"STRING",
>                         "size":50,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":23,
>                         "name":"toJobConfig.stageTableName",
>                         "type":"STRING",
>                         "size":2000,
>                         "sensitive":false
>                      },
>                      {  
>                         "id":24,
>                         "name":"toJobConfig.clearStageTable",
>                         "type":"BOOLEAN",
>                         "sensitive":false
>                      }
>                   ],
>                   "name":"toJobConfig",
>                   "type":"JOB"
>                }
>             ]
>          },
>          "version":"2.0.0-SNAPSHOT"
>       }
>    ]
> }
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)