Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4670

DB2 table with VARGRAPHIC column causes MetadataException TEIID60009 Unknown datatype null

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 9.0.5
    • None
    • None

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

            rhn-engineering-shawkins Steven Hawkins
            leebreisacher Lee Breisacher (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: