]
Matej Kralik updated TEIIDDES-3175:
-----------------------------------
Labels: release_notes (was: )
MED for JDG7 set wrong NAMESPACE and properties prefix
------------------------------------------------------
Key: TEIIDDES-3175
URL:
https://issues.jboss.org/browse/TEIIDDES-3175
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 11.1.1
Reporter: Matej Kralik
Assignee: Barry LaFond
Priority: Critical
Labels: release_notes
Fix For: 11.1.2
For workaround in this issue
[
TEIIDDES-3174|https://issues.jboss.org/browse/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:
{code:java}
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.
{code}
I also noticed that name of properties are *teiid_infinispan-hotrod* but should be
*teiid_ispn*.
Generated model in xml vdb:
{code:java}
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');
{code}
Right model (in my opinion):
{code:java}
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');
{code}