[JBoss JIRA] (TEIIDDES-2956) Designer has generated the wrong jar in the JDG module
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2956?page=com.atlassian.jira.plu... ]
Van Halbert commented on TEIIDDES-2956:
---------------------------------------
Can you attach your jar?
> Designer has generated the wrong jar in the JDG module
> -------------------------------------------------------
>
> Key: TEIIDDES-2956
> URL: https://issues.jboss.org/browse/TEIIDDES-2956
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Environment: Windows 10 1607
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 10.0.2
>
> Attachments: Book.jar, Book_4.11.2016_win.jar, Book_fedora.jar, Book_windows10.jar, completeJDGproject3.zip, express-zip-contents-on-windows.png, jarInFedora.png, jarInWindows.png, screenshotJar_4.11.2016.png
>
>
> I want to deploy dynamic vdb with JDG materialization on the server and server shows me error that:
> {code:java}
> IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: java.lang.ClassNotFoundException: org.teiid.jdg.pojo.Book from [Module "org.teiid.jdg.pojo:main" from local module loader @16f65612 (finder: local module finder @311d617d (roots: C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules,C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules\system\layers\dv,C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules\system\layers\base\.overlays\layer-base-jboss-eap-6.4.9.CP,C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules\system\layers\base))]
> {code}
> I noticed that something is wrong with generated jar file in the windows because when I use jar file which I generated in the fedora, materialization works fine. I uploaded both jar files.
> The strange thing is that when I open .jar (which was generated in the windows ) via 7-file in the windows, file contains folders to Book.class (org/teiid/jdg/pojo) (jarInWindows.png) but when I open this same .jar in the fedora, file contains .class which have name org\teiid\jdg\pojo/Book.class (jarInFedora.png). Maybe this is the problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2942) Procedure input parameter has result in the generated DDL
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2942?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2942.
----------------------------------
> Procedure input parameter has result in the generated DDL
> ---------------------------------------------------------
>
> Key: TEIIDDES-2942
> URL: https://issues.jboss.org/browse/TEIIDDES-2942
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Labels: release_notes, verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: ddlProject.zip
>
>
> I have a procedure with one input parameter. When I want to preview this procedure or deploy dynamic VDB, server shows me error that:
> {code:java}
> TEIID31100 Parsing error: Encountered "(4000) [*]result[*]) RETURNS" at line 2, column 52.
> Procedure testProc RESULT param p1 must be of type OUT.
> {code}
> I noticed that generated dynamic VDB contains 'result' in this parameter but this parameter has set direction to IN. When I delete the result from dynamic VDB, the procedure works fine.
> Actual DDL:
> {code:java}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000) result) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}')
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
> expected DDL:
> {code:java}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}')
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2942) Procedure input parameter has result in the generated DDL
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2942?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2942:
-----------------------------------
Labels: release_notes verified_jbdsis-9.0.3 (was: )
> Procedure input parameter has result in the generated DDL
> ---------------------------------------------------------
>
> Key: TEIIDDES-2942
> URL: https://issues.jboss.org/browse/TEIIDDES-2942
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Labels: release_notes, verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: ddlProject.zip
>
>
> I have a procedure with one input parameter. When I want to preview this procedure or deploy dynamic VDB, server shows me error that:
> {code:java}
> TEIID31100 Parsing error: Encountered "(4000) [*]result[*]) RETURNS" at line 2, column 52.
> Procedure testProc RESULT param p1 must be of type OUT.
> {code}
> I noticed that generated dynamic VDB contains 'result' in this parameter but this parameter has set direction to IN. When I delete the result from dynamic VDB, the procedure works fine.
> Actual DDL:
> {code:java}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000) result) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}')
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
> expected DDL:
> {code:java}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml) OPTIONS ("REST:METHOD" 'GET', "REST:URI" 'test/{p1}')
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2956) Designer has generated the wrong jar in the JDG module
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2956?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2956:
-----------------------------------
Attachment: Book_4.11.2016_win.jar
screenshotJar_4.11.2016.png
> Designer has generated the wrong jar in the JDG module
> -------------------------------------------------------
>
> Key: TEIIDDES-2956
> URL: https://issues.jboss.org/browse/TEIIDDES-2956
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Environment: Windows 10 1607
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 10.0.2
>
> Attachments: Book.jar, Book_4.11.2016_win.jar, Book_fedora.jar, Book_windows10.jar, completeJDGproject3.zip, express-zip-contents-on-windows.png, jarInFedora.png, jarInWindows.png, screenshotJar_4.11.2016.png
>
>
> I want to deploy dynamic vdb with JDG materialization on the server and server shows me error that:
> {code:java}
> IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: java.lang.ClassNotFoundException: org.teiid.jdg.pojo.Book from [Module "org.teiid.jdg.pojo:main" from local module loader @16f65612 (finder: local module finder @311d617d (roots: C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules,C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules\system\layers\dv,C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules\system\layers\base\.overlays\layer-base-jboss-eap-6.4.9.CP,C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules\system\layers\base))]
> {code}
> I noticed that something is wrong with generated jar file in the windows because when I use jar file which I generated in the fedora, materialization works fine. I uploaded both jar files.
> The strange thing is that when I open .jar (which was generated in the windows ) via 7-file in the windows, file contains folders to Book.class (org/teiid/jdg/pojo) (jarInWindows.png) but when I open this same .jar in the fedora, file contains .class which have name org\teiid\jdg\pojo/Book.class (jarInFedora.png). Maybe this is the problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2956) Designer has generated the wrong jar in the JDG module
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2956?page=com.atlassian.jira.plu... ]
Matej Kralik commented on TEIIDDES-2956:
----------------------------------------
My windows still generate the wrong JAR. Now, jar doesn't contains any folder. I uploaded Book_4.11.2016_win.jar and screenshot from windows screenshotJar_4.11.2016.png
> Designer has generated the wrong jar in the JDG module
> -------------------------------------------------------
>
> Key: TEIIDDES-2956
> URL: https://issues.jboss.org/browse/TEIIDDES-2956
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Environment: Windows 10 1607
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 10.0.2
>
> Attachments: Book.jar, Book_4.11.2016_win.jar, Book_fedora.jar, Book_windows10.jar, completeJDGproject3.zip, express-zip-contents-on-windows.png, jarInFedora.png, jarInWindows.png, screenshotJar_4.11.2016.png
>
>
> I want to deploy dynamic vdb with JDG materialization on the server and server shows me error that:
> {code:java}
> IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: java.lang.ClassNotFoundException: org.teiid.jdg.pojo.Book from [Module "org.teiid.jdg.pojo:main" from local module loader @16f65612 (finder: local module finder @311d617d (roots: C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules,C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules\system\layers\dv,C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules\system\layers\base\.overlays\layer-base-jboss-eap-6.4.9.CP,C:\Users\jboss\Downloads\testJDG\EAP-6.4.0\modules\system\layers\base))]
> {code}
> I noticed that something is wrong with generated jar file in the windows because when I use jar file which I generated in the fedora, materialization works fine. I uploaded both jar files.
> The strange thing is that when I open .jar (which was generated in the windows ) via 7-file in the windows, file contains folders to Book.class (org/teiid/jdg/pojo) (jarInWindows.png) but when I open this same .jar in the fedora, file contains .class which have name org\teiid\jdg\pojo/Book.class (jarInFedora.png). Maybe this is the problem.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2930) Dynamic VDB should contain full path to the materialized table
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2930?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2930.
----------------------------------
> Dynamic VDB should contain full path to the materialized table
> --------------------------------------------------------------
>
> Key: TEIIDDES-2930
> URL: https://issues.jboss.org/browse/TEIIDDES-2930
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Labels: verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: completeJDGproject.zip, customer-cache-table-info.png, customer-view-info.png, jdgCustomer.zip, screenshot1.png, screenshotProp.png
>
>
> I have a table (CustomerViewMat.Customer) and I set materialized table to another model (CustomerMatCache.Customer) (screenshot1) .I create VDB and dynamic VDB. When I want to deploy this dynamic VDB to the server, server shows me error:
> TEIID31088 The materialization table Customer defined on view CustomerViewMat.Customer, must be defined with "schema" qualifier that represents PHYSICAL model.
> I noticed that in the dynamicVDB in the CustomerViewMat model is:
> {code:java}
> OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'Customer', "teiid_rel: ...
> {code}
> I think that this happens because Customer table is in the CustomerViewMat and CustomerMatCache too. But in the properties (Screenshot1) is set correctly model. (CustomerMatCache)
> When I set full path, vdb was deployed sucessfully
> {code:java}
> OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel: ...
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2930) Dynamic VDB should contain full path to the materialized table
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2930?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2930:
-----------------------------------
Labels: verified_jbdsis-9.0.3 (was: )
> Dynamic VDB should contain full path to the materialized table
> --------------------------------------------------------------
>
> Key: TEIIDDES-2930
> URL: https://issues.jboss.org/browse/TEIIDDES-2930
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Labels: verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: completeJDGproject.zip, customer-cache-table-info.png, customer-view-info.png, jdgCustomer.zip, screenshot1.png, screenshotProp.png
>
>
> I have a table (CustomerViewMat.Customer) and I set materialized table to another model (CustomerMatCache.Customer) (screenshot1) .I create VDB and dynamic VDB. When I want to deploy this dynamic VDB to the server, server shows me error:
> TEIID31088 The materialization table Customer defined on view CustomerViewMat.Customer, must be defined with "schema" qualifier that represents PHYSICAL model.
> I noticed that in the dynamicVDB in the CustomerViewMat model is:
> {code:java}
> OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'Customer', "teiid_rel: ...
> {code}
> I think that this happens because Customer table is in the CustomerViewMat and CustomerMatCache too. But in the properties (Screenshot1) is set correctly model. (CustomerMatCache)
> When I set full path, vdb was deployed sucessfully
> {code:java}
> OPTIONS(MATERIALIZED 'TRUE', MATERIALIZED_TABLE 'CustomerMatCache.Customer', "teiid_rel: ...
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2931) Dynamic VDB doesn't contains updateble option
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2931?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2931:
-----------------------------------
Labels: release_notes verified_jbdsis-9.0.3 (was: )
> Dynamic VDB doesn't contains updateble option
> ---------------------------------------------
>
> Key: TEIIDDES-2931
> URL: https://issues.jboss.org/browse/TEIIDDES-2931
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Reporter: Matej Kralik
> Priority: Critical
> Labels: release_notes, verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: updateProject.zip
>
>
> I have source model which have a table which has support updatable to 'true' and all its columns have updatable to 'true'.
> I create vdb, deploy and execute insert query. The query is successful but when I create dynamicVDB and deploy, insert query doesn't pass and server shows error: Metadata does not allow updates on the group
> current
> {code:java}
> OPTIONS(NAMEINSOURCE '"BOOKS"."AUTHORS"', CARDINALITY '60')
> {code}
> expected:
> {code:java}
> OPTIONS(UPDATABLE 'TRUE',NAMEINSOURCE '"BOOKS"."AUTHORS"', CARDINALITY '60')
> {code}
> This influence JDG metadata because when I deploy dynamic vdb with materialization, the server shows an error that status table (and others tables which should be updatable) don't allow updates.
> {code:java}
> TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE ((updateStmt || ' AND loadNumber = ') || matcursor.loadNumber) USING loadNumber = (matcursor.loadNumber + 1), vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = loadMatView.viewName, updated = now(), LoadState = 'LOADING', valid = (matcursor.valid) AND (NOT (invalidate)), cardinality = matcursor.cardinality" with the SQL statement "UPDATE sourceMSQmodel.testJDG.status SET LoadNumber = DVARS.LoadNumber, LoadState = DVARS.LoadState, valid = DVARS.valid, Updated = DVARS.updated, Cardinality = DVARS.cardinality WHERE VDBName = DVARS.vdbName AND VDBVersion = DVARS.vdbVersion AND schemaName = DVARS.schemaName AND Name = DVARS.viewName AND loadNumber = 59" due to: TEIID30492 Metadata does not allow updates on the group: sourceMSQmodel.testJDG.status
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months
[JBoss JIRA] (TEIIDDES-2931) Dynamic VDB doesn't contains updateble option
by Matej Kralik (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2931?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2931.
----------------------------------
> Dynamic VDB doesn't contains updateble option
> ---------------------------------------------
>
> Key: TEIIDDES-2931
> URL: https://issues.jboss.org/browse/TEIIDDES-2931
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs
> Affects Versions: 10.0.2
> Reporter: Matej Kralik
> Priority: Critical
> Labels: release_notes, verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: updateProject.zip
>
>
> I have source model which have a table which has support updatable to 'true' and all its columns have updatable to 'true'.
> I create vdb, deploy and execute insert query. The query is successful but when I create dynamicVDB and deploy, insert query doesn't pass and server shows error: Metadata does not allow updates on the group
> current
> {code:java}
> OPTIONS(NAMEINSOURCE '"BOOKS"."AUTHORS"', CARDINALITY '60')
> {code}
> expected:
> {code:java}
> OPTIONS(UPDATABLE 'TRUE',NAMEINSOURCE '"BOOKS"."AUTHORS"', CARDINALITY '60')
> {code}
> This influence JDG metadata because when I deploy dynamic vdb with materialization, the server shows an error that status table (and others tables which should be updatable) don't allow updates.
> {code:java}
> TEIID30168 Couldn't execute the dynamic SQL command "EXECUTE IMMEDIATE ((updateStmt || ' AND loadNumber = ') || matcursor.loadNumber) USING loadNumber = (matcursor.loadNumber + 1), vdbName = VARIABLES.vdbName, vdbVersion = VARIABLES.vdbVersion, schemaName = schemaName, viewName = loadMatView.viewName, updated = now(), LoadState = 'LOADING', valid = (matcursor.valid) AND (NOT (invalidate)), cardinality = matcursor.cardinality" with the SQL statement "UPDATE sourceMSQmodel.testJDG.status SET LoadNumber = DVARS.LoadNumber, LoadState = DVARS.LoadState, valid = DVARS.valid, Updated = DVARS.updated, Cardinality = DVARS.cardinality WHERE VDBName = DVARS.vdbName AND VDBVersion = DVARS.vdbVersion AND schemaName = DVARS.schemaName AND Name = DVARS.viewName AND loadNumber = 59" due to: TEIID30492 Metadata does not allow updates on the group: sourceMSQmodel.testJDG.status
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 11 months