[
https://issues.jboss.org/browse/TEIIDDES-2854?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2854:
----------------------------------------
Currently, Designer's JDBC importer is checking the *remarks* field in the result set
for the getTables() request in JdbcTableTypesImpl
{code}
resultSet =
metadata.getTables(catalogName,schemaName,WILDCARD_PATTERN,tableTypes);
while (resultSet != null && resultSet.next()) {
final String tableName = resultSet.getString(3);
final String remarks = resultSet.getString(5);
final JdbcTableImpl table = new JdbcTableImpl(this,tableName);
table.setRemarks(remarks);
children.add(table);
}
{code}
Teiid's *JDBCMetdataProcessor.getTables()* method uses a similar call to retrieve
available remarks and sets the table *annotation* if not null.
This issue requests using Oracle COMMENTS which is probably different than standard JDBC.
We currently have no framework to make additional calls for each JDBC type that might
support *COMMENTS* or like information
Support Oracle comments when performing JDBC import
---------------------------------------------------
Key: TEIIDDES-2854
URL:
https://issues.jboss.org/browse/TEIIDDES-2854
Project: Teiid Designer
Issue Type: Enhancement
Components: Import/Export
Affects Versions: 9.1, 10.0.1
Reporter: Van Halbert
Assignee: Barry LaFond
Fix For: 11.0.2
When performing JDBC import from oracle, the column comments should be imported as part
of the metadata that used to create the source model.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)