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

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-1976:
-------------------------------------

Mark,

I do not see "getColumns" call on the DatabaseMetadata interface. Which version of JDBC API are you using? I tried below, and it works correctly.

{code:JAVA}
ResultSetMetaData metadata = results.getMetaData();
int columns = metadata.getColumnCount();
			
System.out.println("Results");
for (int row = 0; row < columns; row++) {
        System.out.print(metadata.getColumnName(row+1));
	System.out.print("(");
	System.out.print(metadata.getColumnTypeName(row+1));
	System.out.print(")");
	System.out.print(",");
}
{code}
                
> 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
>
>
> 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