[
https://issues.jboss.org/browse/TEIID-4670?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4670:
---------------------------------------
I don't see this behavior with my DB2 instance. For a vargraphic column, I see a sql
type of 12 being reported by the driver, which maps to string. The only way this exception
would happen is if the driver reports a 0 (java.sql.Types.NULL) for the type. What
specific DB2 driver/server combination are you using, and what sql type metadata do you
see reported in other JDBC tools?
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)