[teiid-issues] [JBoss JIRA] (TEIID-4670) DB2 table with VARGRAPHIC column causes MetadataException TEIID60009 Unknown datatype null

[Lee Breisacher (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lee Breisacher closed TEIID-4670.
---------------------------------
    Resolution: Rejected


oops, sorry Steven, my bad! bug in my code. thanks for looking.

> DB2 table with VARGRAPHIC column causes MetadataException TEIID60009 Unknown datatype null
> ------------------------------------------------------------------------------------------
>
>                 Key: TEIID-4670
>                 URL: https://issues.jboss.org/browse/TEIID-4670
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 9.0.5
>         Environment: teiid running on Windows connecting to DB2 database on z/OS. 
>            Reporter: Lee Breisacher
>            Assignee: Steven Hawkins
>
> I have a JDBC connection to a DB2 database which has a table with a column of type VARGRAPHIC (a double-byte character VARCHAR). When gathering metadata during Teiid initialization, I get this exception:
> org.teiid.metadata.MetadataException: TEIID60009 Unknown datatype null
>                 at org.teiid.metadata.MetadataFactory.setDataType(MetadataFactory.java:272)
>                 at org.teiid.metadata.MetadataFactory.addColumn(MetadataFactory.java:254)
>                 at org.teiid.translator.jdbc.JDBCMetdataProcessor.addColumn(JDBCMetdataProcessor.java:425)
>                 at org.teiid.translator.jdbc.JDBCMetdataProcessor.processColumns(JDBCMetdataProcessor.java:386)
>                 at org.teiid.translator.jdbc.JDBCMetdataProcessor.getColumns(JDBCMetdataProcessor.java:361)
>                 at org.teiid.translator.jdbc.JDBCMetdataProcessor.getTables(JDBCMetdataProcessor.java:312)
>                 at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:159)
>                 at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:307)
>                 at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:68)
>                 at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:96)
>                 at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)
>                 at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
>                 at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:794)
>                 at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:210)
>                 at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:744)
>                 at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:685)
> It looks like Teiid does not handle columns of type VARGRAPHIC (as seen in org.teiid.core.types.JDBCSQLTypeInfo). 



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)