-
Bug
-
Resolution: Done
-
Critical
-
11.1.1
-
None
-
- 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');