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).