Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2210

Using Teiid Connection importer doesn't completely import the DDL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 9.0, 8.6.1
    • 8.5
    • Teiid Integration
    • None

      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');

            blafond Barry LaFond
            van.halbert Van Halbert (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: