[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:
---------------------------------------
I installed the 10/27 jenkins build and the module.zip doesn't contain the folder structure. example: module.xml - name="org.teiid.jdg.pojo" and the module doesn't contain folders: org/teiid/jdg/pojo/main
> 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_fedora.jar, Book_windows10.jar, completeJDGproject3.zip, express-zip-contents-on-windows.png, jarInFedora.png, jarInWindows.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.2#72004)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2951) Designer haven't set password to datasource which is created before preview.
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2951?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2951.
----------------------------------
> Designer haven't set password to datasource which is created before preview.
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-2951
> URL: https://issues.jboss.org/browse/TEIIDDES-2951
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Labels: verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: screenshot1.png, screenshot2.png
>
>
> I generated source model from a database (SQL Server) via JDBC. When I go through wizard I haven't started server so the data source haven't been set (screenshot1). I started a server and I wanted to preview data, shows me dialog ([TEIIDDES-2904|https://issues.jboss.org/browse/TEIIDDES-2904]) if I had wanted to create DS. I clicked yes and ok but server shows error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for SQL_Server_2008_Books were not available. The command could not be planned properly.
> {code}
> I tried to create the data source (with the same name) manually but the error is still there [TEIIDDES-2950|https://issues.jboss.org/browse/TEIIDDES-2950]. I had to delete data source from the server and create it again or set another name of the datasource.
> I deleted datasource.
> When I generated a model from a database via JDBC again (but a server was running) and I checked Auto-create Data Source (screenshot2), preview worked fine.
> So I notice that datasource haven't set a password when DS is created before the preview.
> I looked to standalone.xml
> Datasource which is created before preview:
> {code:java}
> datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> </security>
> </datasource>
> {code}
> Datasource which is created in the import wizard:
> {code:java}
> <datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> <password>**</password>
> </security>
> </datasource>
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2951) Designer haven't set password to datasource which is created before preview.
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2951?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2951:
-----------------------------------
Labels: verified_jbdsis-9.0.3 (was: )
> Designer haven't set password to datasource which is created before preview.
> ----------------------------------------------------------------------------
>
> Key: TEIIDDES-2951
> URL: https://issues.jboss.org/browse/TEIIDDES-2951
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 10.0.2
> Environment: Fedora 24
> Reporter: Matej Kralik
> Assignee: Barry LaFond
> Priority: Critical
> Labels: verified_jbdsis-9.0.3
> Fix For: 10.0.2
>
> Attachments: screenshot1.png, screenshot2.png
>
>
> I generated source model from a database (SQL Server) via JDBC. When I go through wizard I haven't started server so the data source haven't been set (screenshot1). I started a server and I wanted to preview data, shows me dialog ([TEIIDDES-2904|https://issues.jboss.org/browse/TEIIDDES-2904]) if I had wanted to create DS. I clicked yes and ok but server shows error:
> {code:java}
> org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for SQL_Server_2008_Books were not available. The command could not be planned properly.
> {code}
> I tried to create the data source (with the same name) manually but the error is still there [TEIIDDES-2950|https://issues.jboss.org/browse/TEIIDDES-2950]. I had to delete data source from the server and create it again or set another name of the datasource.
> I deleted datasource.
> When I generated a model from a database via JDBC again (but a server was running) and I checked Auto-create Data Source (screenshot2), preview worked fine.
> So I notice that datasource haven't set a password when DS is created before the preview.
> I looked to standalone.xml
> Datasource which is created before preview:
> {code:java}
> datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> </security>
> </datasource>
> {code}
> Datasource which is created in the import wizard:
> {code:java}
> <datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true">
> <connection-url>connection url</connection-url>
> <driver>sqljdbc4.jar</driver>
> <security>
> <user-name>books</user-name>
> <password>**</password>
> </security>
> </datasource>
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2930) Dynamic VDB should contain full path to the materialized table
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2930?page=com.atlassian.jira.plu... ]
Matus Makovy commented on TEIIDDES-2930:
----------------------------------------
>From my point of view, this is ok for now.
> 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
> 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.2#72004)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2964) Add capability to set a default data role grant
by Debbie Steigner (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2964?page=com.atlassian.jira.plu... ]
Debbie Steigner commented on TEIIDDES-2964:
-------------------------------------------
Per the customer:
If the Flag:
- Grant All --> False
then no-one of the 10 groups receive the "Read" permission.
So, I open the only 1 group in the scope and manually I add "Read" permission.
Actually I don't think that Moving the flag "Grant All" from True to false, and vice-verse, should change VDB permissions already defined.
> Add capability to set a default data role grant
> -----------------------------------------------
>
> Key: TEIIDDES-2964
> URL: https://issues.jboss.org/browse/TEIIDDES-2964
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: VDB & Execution
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Priority: Minor
>
> We use JDV as "data-firewall", so there are a lot of groups configured on JDV data roles section.
> Each time we add a model object to the project, by default all read permission are granted to that model for all groups.
> We think it could be better, to have an option in the "Data Roles" tab, avoiding users to uncheck for all the groups's permission which aren't needed (see page 2 attachment JDV_RFE_security_default_profile).
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2942) Procedure input parameter has result in the generated DDL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2942?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2942:
--------------------------------------
Assignee: Barry LaFond
> 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
> 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.2#72004)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2961) Using JDG CP, unable to create data source without entering AliasCacheName property
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2961?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2961:
-----------------------------------
Fix Version/s: 10.0.2
> Using JDG CP, unable to create data source without entering AliasCacheName property
> -----------------------------------------------------------------------------------
>
> Key: TEIIDDES-2961
> URL: https://issues.jboss.org/browse/TEIIDDES-2961
> Project: Teiid Designer
> Issue Type: Bug
> Components: Modeling
> Affects Versions: 10.0.2
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 10.0.2
>
> Attachments: JDGConnectionInfoProvider.patch, JDGProfileDetailsWizardPage.patch
>
>
> Created a JDG connection profile to connect to an existing JDG cache. When I select the create DataSource option, it present a dialog that indicated the AliashCacheName cannot be null. The AliasCacheName and StagingCacheName should be empty if not using materialization.
> StackTrace:
> java.lang.IllegalArgumentException: No value for the connection property 'AliasCacheName'
> at org.teiid.core.designer.util.CoreArgCheck.isNotZeroLength(CoreArgCheck.java:117)
> at org.teiid.core.designer.util.CoreArgCheck.isNotEmpty(CoreArgCheck.java:249)
> at org.teiid.designer.runtime.TeiidServer.getOrCreateDataSource(TeiidServer.java:662)
> at org.teiid.designer.runtime.ui.connection.CreateDataSourceAction.run(CreateDataSourceAction.java:185)
> at org.eclipse.jface.action.Action.runWithEvent(Action.java:473)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:565)
> at org.eclipse.jface.action.ActionContributionItem.lambda$4(ActionContributionItem.java:397)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5219)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1340)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4553)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4143)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1121)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1022)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:150)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:687)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:604)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:138)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:388)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:243)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:673)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:610)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1519)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1492)
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2948) Created REST Connection Profile isn't appearing in Designer
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2948?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2948.
----------------------------------
> Created REST Connection Profile isn't appearing in Designer
> -----------------------------------------------------------
>
> Key: TEIIDDES-2948
> URL: https://issues.jboss.org/browse/TEIIDDES-2948
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: stanislav kaleta
> Priority: Blocker
> Labels: verified_jbdsis-9.0.3
>
> Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
> Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ (next to combo box) should create CP, however combo box remains empty after creation)
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 2 months
[JBoss JIRA] (TEIIDDES-2948) Created REST Connection Profile isn't appearing in Designer
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2948?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2948:
-----------------------------------
Labels: verified_jbdsis-9.0.3 (was: )
> Created REST Connection Profile isn't appearing in Designer
> -----------------------------------------------------------
>
> Key: TEIIDDES-2948
> URL: https://issues.jboss.org/browse/TEIIDDES-2948
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.0.2
> Reporter: stanislav kaleta
> Priority: Blocker
> Labels: verified_jbdsis-9.0.3
>
> Use Steps to Reproduce to create REST Connection Profile. I assume Connection Profile is created because if u try to create another CP with same name it shows error that CP with given name already exists. However if you check Data Source Explorer, no REST CP is there.
> Also when I try _Import.../Teiid Designer/Web Service Source >> Source and View Model (REST)_, following _REST WebService Source_ combo box is empty. (Using _New..._ (next to combo box) should create CP, however combo box remains empty after creation)
--
This message was sent by Atlassian JIRA
(v7.2.2#72004)
8 years, 2 months