Using Teiid Connection importer doesn't completely import the DDL ----------------------------------------------------------------- Key: TEIIDDES-2210 URL: https://issues.jboss.org/browse/TEIIDDES-2210 Project: Teiid Designer Issue Type: Bug Components: Teiid Integration Affects Versions: 8.5 Reporter: Van Halbert Assignee: Barry LaFond Fix For: 8.7, 8.6.1 When using Teiid connection importer, there's a couple of issues importing the ddl: 1. this property isn't being loaded: "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person' 2. NIS for Foreign key isn't being set: CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones') Example DDL: CREATE FOREIGN TABLE Person ( PersonObject object OPTIONS (NAMEINSOURCE 'this', SEARCHABLE 'Unsearchable', NATIVE_TYPE 'java.lang.Object'), name string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'), id integer OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.Integer'), email string OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'), CONSTRAINT PK_ID PRIMARY KEY(id) ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.Person'); CREATE FOREIGN TABLE PhoneNumber ( number string OPTIONS (NAMEINSOURCE 'phone.number', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'), type string OPTIONS (NAMEINSOURCE 'phone.type', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'), Id integer NOT NULL OPTIONS (SELECTABLE FALSE, SEARCHABLE 'Unsearchable', NATIVE_TYPE 'int'), CONSTRAINT FK_PERSON FOREIGN KEY(Id) REFERENCES Person (Id) OPTIONS (NAMEINSOURCE 'phones') ) OPTIONS (NAMEINSOURCE 'PersonsCache', "teiid_infinispan:entity_class" 'org.jboss.as.quickstarts.datagrid.hotrod.query.domain.PhoneNumber');