[teiid-issues] [JBoss JIRA] (TEIID-1976) Metadata TYPE_NAME value is null for String Columns

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12680746#comment-12680746 ] 

Steven Hawkins commented on TEIID-1976:
---------------------------------------

You should instead use getString("COLUMN_NAME") and getString("TYPE_NAME"), or at the least resultSet.getMetaData().getColumnLable(i).  We do not guarantee that the column name will match the label since the actual query may not fetch columns with the same names as expected by JDBC.  
                
> Metadata TYPE_NAME value is null for String Columns
> ---------------------------------------------------
>
>                 Key: TEIID-1976
>                 URL: https://issues.jboss.org/browse/TEIID-1976
>             Project: Teiid
>          Issue Type: Bug
>          Components: Common
>    Affects Versions: 8.0
>            Reporter: Mark Drilling
>            Assignee: Ramesh Reddy
>             Fix For: 8.0
>
>         Attachments: PortfolioVDB.vdb
>
>
> The metadata TYPE_NAME value for string datatypes is apparently returning null.  I am running against a JBoss AS7.1Final server with Teiid 8.0Beta2.  
> My application (openshift web client) establishes connection from a DataSource, eg connection = dataSource.getConnection(), 
> then resultSet = connection.getMetaData().getColumns();
> when iterating thru the resultSet, the value for columnName="TYPE_NAME" is null for string types.  Other types seem to return a correct value.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira