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

MED for JDG7 set wrong NAMESPACE and properties prefix

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 11.1.2
    • 11.1.1
    • None
      1. Rename namespace and properties prefix from teiid_infinispan-hotrod to teiid_ispn

      For workaround in this issue TEIIDDES-3174 I manually set MED (infinispan-hotrod) for JDG7 source model. When I create vdb as XML, xml file contains namespace 'http://www.teiid.org/translator/infinispan/2017' AS teiid_infinispan-hotrod but when I want to deploy it, on the server shows warning:

      13:07:54,108 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB BookMat.1 model "BookJDGSource" metadata failed to load. Reason:TEIID60017 Invalid prefix teiid_infinispan, teiid_ is reserved for Teiid use.: org.teiid.metadata.MetadataException: TEIID60017 Invalid prefix teiid_infinispan, teiid_ is reserved for Teiid use.
      

      I also noticed that name of properties are teiid_infinispan-hotrod but should be teiid_ispn.

      Generated model in xml vdb:

      SET NAMESPACE 'http://www.teiid.org/translator/infinispan/2017' AS teiid_infinispan-hotrod
      
      CREATE FOREIGN TABLE viewBooks (
      	isbn string(255) NOT NULL,
      	title string(255),
      	publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	type string(255),
      	CONSTRAINT pk_book PRIMARY KEY(isbn) OPTIONS(NAMEINSOURCE 'BOOKS')
      ) OPTIONS(UPDATABLE 'TRUE', "teiid_infinispan-hotrod:CACHE" 'books_indexed');
      
      CREATE FOREIGN TABLE ST_viewBooks (
      	isbn string(255) NOT NULL,
      	title string(255),
      	publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	type string(255),
      	CONSTRAINT pk_book PRIMARY KEY(isbn) OPTIONS(NAMEINSOURCE 'BOOKS')
      ) OPTIONS(UPDATABLE 'TRUE', "teiid_infinispan-hotrod:CACHE" 'books_indexed_st');
      

      Right model (in my opinion):

      SET NAMESPACE 'http://www.teiid.org/translator/infinispan/2017' AS teiid_ispn
      
      CREATE FOREIGN TABLE viewBooks (
      	isbn string(255) NOT NULL,
      	title string(255),
      	publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	type string(255),
      	CONSTRAINT pk_book PRIMARY KEY(isbn) OPTIONS(NAMEINSOURCE 'BOOKS')
      ) OPTIONS(UPDATABLE 'TRUE', "teiid_ispn:CACHE" 'books_indexed');
      
      CREATE FOREIGN TABLE ST_viewBooks (
      	isbn string(255) NOT NULL,
      	title string(255),
      	publisher integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	publishyear integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	edition integer OPTIONS(FIXED_LENGTH 'TRUE'),
      	type string(255),
      	CONSTRAINT pk_book PRIMARY KEY(isbn) OPTIONS(NAMEINSOURCE 'BOOKS')
      ) OPTIONS(UPDATABLE 'TRUE', "teiid_ispn:CACHE" 'books_indexed_st');
      

              blafond Barry LaFond
              mkralik@redhat.com Matej Kralik
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: