[jira] [Closed] (DERBY-6037) ResultSet.getString() doesn't return null on SQL NULL columns

["Unai Vivi (JIRA)" <ji...@apache.org>]

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

Unai Vivi closed DERBY-6037.
----------------------------

    Resolution: Not A Problem

Sorry guys, I screwed up, not a bug.
There were actually columns containing the "null" string in the DB. It took me all afternoon to notice that (I should use more coffee!).
                
> ResultSet.getString() doesn't return null on SQL NULL columns
> -------------------------------------------------------------
>
>                 Key: DERBY-6037
>                 URL: https://issues.apache.org/jira/browse/DERBY-6037
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC, SQL
>    Affects Versions: 10.8.2.2, 10.9.1.0
>         Environment: Java 7u7
>            Reporter: Unai Vivi
>            Priority: Minor
>
> ResultSet.getString() doesn't return null on SQL NULL columns of type VARCHAR; it returns the string "null" instead.
> I tried derby versions 10.8.2.2 and 10.9.1.0 (derby.jar - embedded) and both show the same behaviour.
> ResultSet javadocs state that the returned value shall be "the column value; if the value is SQL NULL, the value returned is null" (null, not the String containing n-u-l-l of .length() 4).
> I'm not sure if this bug report belongs here or on Oracle's ResultSet implementation.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira