[jira] [Updated] (SQOOP-2021) GenericJDBCConnector stores string "null" for null objects ( It is a not according to the object format spec of sqoop IDF)

[Veena Basavaraj (JIRA)]

     [ 
https://issues.apache.org/jira/browse/SQOOP-2021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Veena Basavaraj updated SQOOP-2021:
-----------------------------------
    Description: 
  public static final String SQL_NULL_VALUE = "null";

{code}
  if(resultSet.getObject(i + 1) == null) {
            array[i] = GenericJdbcConnectorConstants.SQL_NULL_VALUE ;
            continue;
          }

{code}

a null should be object null and not STRING null

  was:
treat INT as 4 bytes since both MySQL and Oracle and Postgres do it so

http://dev.mysql.com/doc/refman/5.0/en/integer-types.html

https://docs.oracle.com/cd/E17952_01/refman-5.5-en/storage-requirements.html

http://www.postgresql.org/docs/9.1/static/datatype-numeric.html



>  GenericJDBCConnector stores string "null" for null objects ( It is a not 
> according to the object format spec of sqoop IDF)
> ---------------------------------------------------------------------------------------------------------------------------
>
>                 Key: SQOOP-2021
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2021
>             Project: Sqoop
>          Issue Type: Bug
>            Reporter: Veena Basavaraj
>            Assignee: Veena Basavaraj
>             Fix For: 1.99.5
>
>
>   public static final String SQL_NULL_VALUE = "null";
> {code}
>   if(resultSet.getObject(i + 1) == null) {
>             array[i] = GenericJdbcConnectorConstants.SQL_NULL_VALUE ;
>             continue;
>           }
> {code}
> a null should be object null and not STRING null



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