[
https://issues.jboss.org/browse/TEIIDDES-2954?page=com.atlassian.jira.plu...
]
Matej Kralik commented on TEIIDDES-2954:
----------------------------------------
[~van.halbert] However, this works only with dynamic VDB (-vdb.xml)
The materialize wizard set the extension property with double apostrophe
{code:java}
execute BookCacheSource.native(''truncate cache'');
{code}
but it is valid for static vdb? (Even if static vdb doesn't work with JDG yet [link
TEIIDDES-2953|https://issues.jboss.org/browse/TEIIDDES-2953])
Because when I deploy static VDB on server, server shows me error that:
{code:java}
TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE
array_get(strings, index)" with the SQL statement "execute
BookJDGSource.native(''truncate cache'')" due to: TEIID31100 Parsing
error: Encountered "BookJDGSource.native(''[*]truncate[*]
cache''" at line 1, column 32.
{code}
I think that valid use case should be that the materialize wizard set the extension
property with only one apostrophe ('truncate cache') and when the designer is
generating dynamic VDB then add the next apostrophe.
Dynamic VDB doesn't contains apostrophe around procedure
--------------------------------------------------------
Key: TEIIDDES-2954
URL:
https://issues.jboss.org/browse/TEIIDDES-2954
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs
Affects Versions: 10.0.2
Environment: Fedora 24
Reporter: Matej Kralik
Attachments: completeJDGproject2.zip
I have a project with JDG materialization. I have set
After load script to: execute BookCacheSource.native('swap cache names');
and
Before load script to: execute BookCacheSource.native('truncate cache');
When I generated Dynamic VDB and I want to deploy it, server shows me error that:
{code:java}
org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered
", \"teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT\" 'execute
BookCacheSource.native('[*]swap[*] cache names" at line 10, column 188.
Was expecting: "," | ")"
{code}
When I added another apostrophe to procedures in the DDL,
execute BookCacheSource.native(''truncate cache'');
execute BookCacheSource.native(''swap cache names'');
deploy was successful.
I think that DDL parser should add it automatically.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)