[teiid-issues] [JBoss JIRA] (TEIID-1976) Metadata TYPE_NAME value is null for String Columns
Mark Drilling (JIRA)
jira-events at lists.jboss.org
Fri Mar 30 14:48:47 EDT 2012
[ https://issues.jboss.org/browse/TEIID-1976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mark Drilling updated TEIID-1976:
---------------------------------
Attachment: PortfolioVDB.vdb
attached the VDB I'm using.
Maybe doing something wacky in populating names and types, but other types work...
{code}
ResultSet resultSet = connection.getMetaData().getColumns(null, schemaName, tableName, null);
int columnCount = resultSet.getMetaData().getColumnCount();
while (resultSet.next()) {
String columnName = null;
String columnType = null;
for (int i=1 ; i<=columnCount ; ++i) {
String colName = resultSet.getMetaData().getColumnName(i);
String value = resultSet.getString(i);
if (colName.equalsIgnoreCase("COLUMN_NAME")) {
columnName = value;
} else if(colName.equalsIgnoreCase("TYPE_NAME")) {
columnType = value;
}
}
columnNameList.add(columnName);
columnTypeList.add(columnType);
}
{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
>
> 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
More information about the teiid-issues
mailing list