[JBoss JIRA] (TEIIDDES-2823) "Generate Dynamic VDB" utility should use correct property names
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2823?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2823:
-----------------------------------
    Labels: release_notes verified_jbdsis-9.0.1  (was: )
> "Generate Dynamic VDB" utility should use correct property names
> ----------------------------------------------------------------
>
>                 Key: TEIIDDES-2823
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2823
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: Dynamic VDBs
>    Affects Versions: 9.2
>            Reporter: Colin Mondesir
>            Assignee: Barry LaFond
>              Labels: release_notes, verified_jbdsis-9.0.1
>             Fix For: 10.0.1
>
>
> When we generate a Dynamic VDB from a Multisource VDB the output contains:
> <property name="supports-multi-source-bindings" value="true"/>
> As far as I can see this is the old property name, I believe the designer to use the new "multisource" property name instead.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
            
        
        
        
                
                        
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2841) Deprecate XML, XSD and XML Document metamodels
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2841?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2841:
-----------------------------------
    Labels: release_notes verified_jbdsis-9.0.1  (was: )
> Deprecate XML, XSD and XML Document metamodels
> ----------------------------------------------
>
>                 Key: TEIIDDES-2841
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2841
>             Project: Teiid Designer
>          Issue Type: Task
>          Components: Modeling, Web Services Support
>    Affects Versions: 10.0
>            Reporter: Barry LaFond
>            Assignee: Barry LaFond
>            Priority: Critical
>              Labels: release_notes, verified_jbdsis-9.0.1
>             Fix For: 10.0.1
>
>
> Support for creating Web Services, XML Document and Schema (XSD) models should be deprecated. The direction of Teiid runtime metadata has changed and these features should be phased out. 
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2835) NullPointerException at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) when "Create source model for JDBC Data Source" from the Guide UI
                                
                                
                                
                                    
                                        by Matus Makovy (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2835?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2835:
-----------------------------------
    Labels: release_notes verified_jbdsis-9.0.1  (was: )
> NullPointerException at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) when "Create source model for JDBC Data Source" from the Guide UI
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIIDDES-2835
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2835
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: Dialogs, Patch Release
>    Affects Versions: 10.0
>         Environment: Teiid Designed 10.0.0.Final.
> eclipse.buildId=4.5.2.M20160212-1500
> java.version=1.8.0_91
> java.vendor=Oracle Corporation
> BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
> Framework arguments:  -product org.eclipse.epp.package.jee.product -product org.eclipse.epp.package.jee.product -product org.eclipse.epp.package.jee.product
> Command-line arguments:  -os win32 -ws win32 -arch x86_64 -product org.eclipse.epp.package.jee.product -product org.eclipse.epp.package.jee.product -data file:/C:/Users/ggregory/workspaces/teiid-designer-mars/ -product org.eclipse.epp.package.jee.product
>            Reporter: Gary Gregory
>            Assignee: Barry LaFond
>              Labels: release_notes, verified_jbdsis-9.0.1
>             Fix For: 10.0.1
>
>         Attachments: npe.png, screenshot-1.png, teiid-mars-config.txt
>
>
> - Install stock plain Eclipse Mars (4.5.2)
> - Install Teiid Designer 10.0.0.Final per http://teiiddesigner.jboss.org/designer_summary/downloads
> - Following the guide http://docs.jboss.org/teiid/designer/10.0/user-guide/en-US/html/dive-righ...
> - Created MySQL 5.0 JDBC data source
> - Created Oracle 10g JDBC "thin" XE data source
> - On step 4 "Create source model for JDBC data source", launching the step from the guide causes an NPE:
> {{java.lang.NullPointerException
> 	at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444)
> 	at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionTab(JdbcImportOptionsPage.java:245)
> 	at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createControl(JdbcImportOptionsPage.java:228)
> 	at org.teiid.designer.ui.common.wizard.AbstractWizard.createPageControls(AbstractWizard.java:153)
> 	at org.teiid.designer.ui.common.wizard.AbstractWizard.createPageControls(AbstractWizard.java:138)
> 	at org.teiid.designer.jdbc.ui.wizards.JdbcImportWizard.createPageControls(JdbcImportWizard.java:250)
> 	at org.eclipse.jface.wizard.WizardDialog.createPageControls(WizardDialog.java:705)
> 	at org.eclipse.jface.wizard.WizardDialog.createContents(WizardDialog.java:597)
> 	at org.eclipse.jface.window.Window.create(Window.java:430)
> 	at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:1096)
> 	at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils$7.run(ModelerUiViewUtils.java:250)
> 	at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:186)
> 	at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:145)
> 	at org.eclipse.swt.widgets.Display.syncExec(Display.java:4761)
> 	at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils.launchWizard(ModelerUiViewUtils.java:240)
> 	at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils$5.run(ModelerUiViewUtils.java:185)
> 	at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:186)
> 	at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:145)
> 	at org.eclipse.swt.widgets.Display.syncExec(Display.java:4761)
> 	at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils.launchWizard(ModelerUiViewUtils.java:167)
> 	at org.teiid.designer.advisor.ui.actions.AdvisorActionFactory.launchWizard(AdvisorActionFactory.java:904)
> 	at org.teiid.designer.advisor.ui.actions.AdvisorActionFactory.executeAction(AdvisorActionFactory.java:437)
> 	at org.teiid.designer.advisor.ui.views.guides.TeiidGuidesSection.launchGuidesAction(TeiidGuidesSection.java:281)
> 	at org.teiid.designer.advisor.ui.views.guides.TeiidGuidesSection.access$1(TeiidGuidesSection.java:271)
> 	at org.teiid.designer.advisor.ui.views.guides.TeiidGuidesSection$4.doubleClick(TeiidGuidesSection.java:174)
> 	at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:832)
> 	at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
> 	at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:50)
> 	at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:173)
> 	at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:829)
> 	at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1470)
> 	at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1263)
> 	at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:252)
> 	at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:249)
> 	at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:311)
> 	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> 	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4362)
> 	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1113)
> 	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4180)
> 	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3769)
> 	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)
> 	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
> 	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)
> 	at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)
> 	at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:694)
> 	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
> 	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:606)
> 	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> 	at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:139)
> 	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:380)
> 	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> 	at java.lang.reflect.Method.invoke(Unknown Source)
> 	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)
> 	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)
> 	at org.eclipse.equinox.launcher.Main.run(Main.java:1515)
> }}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2835) NullPointerException at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) when "Create source model for JDBC Data Source" from the Guide UI
                                
                                
                                
                                    
                                        by Matus Makovy (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2835?page=com.atlassian.jira.plu... ]
Matus Makovy closed TEIIDDES-2835.
----------------------------------
> NullPointerException at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444) when "Create source model for JDBC Data Source" from the Guide UI
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIIDDES-2835
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2835
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: Dialogs, Patch Release
>    Affects Versions: 10.0
>         Environment: Teiid Designed 10.0.0.Final.
> eclipse.buildId=4.5.2.M20160212-1500
> java.version=1.8.0_91
> java.vendor=Oracle Corporation
> BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US
> Framework arguments:  -product org.eclipse.epp.package.jee.product -product org.eclipse.epp.package.jee.product -product org.eclipse.epp.package.jee.product
> Command-line arguments:  -os win32 -ws win32 -arch x86_64 -product org.eclipse.epp.package.jee.product -product org.eclipse.epp.package.jee.product -data file:/C:/Users/ggregory/workspaces/teiid-designer-mars/ -product org.eclipse.epp.package.jee.product
>            Reporter: Gary Gregory
>            Assignee: Barry LaFond
>              Labels: release_notes, verified_jbdsis-9.0.1
>             Fix For: 10.0.1
>
>         Attachments: npe.png, screenshot-1.png, teiid-mars-config.txt
>
>
> - Install stock plain Eclipse Mars (4.5.2)
> - Install Teiid Designer 10.0.0.Final per http://teiiddesigner.jboss.org/designer_summary/downloads
> - Following the guide http://docs.jboss.org/teiid/designer/10.0/user-guide/en-US/html/dive-righ...
> - Created MySQL 5.0 JDBC data source
> - Created Oracle 10g JDBC "thin" XE data source
> - On step 4 "Create source model for JDBC data source", launching the step from the guide causes an NPE:
> {{java.lang.NullPointerException
> 	at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionPanel(JdbcImportOptionsPage.java:444)
> 	at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createModelDefinitionTab(JdbcImportOptionsPage.java:245)
> 	at org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.createControl(JdbcImportOptionsPage.java:228)
> 	at org.teiid.designer.ui.common.wizard.AbstractWizard.createPageControls(AbstractWizard.java:153)
> 	at org.teiid.designer.ui.common.wizard.AbstractWizard.createPageControls(AbstractWizard.java:138)
> 	at org.teiid.designer.jdbc.ui.wizards.JdbcImportWizard.createPageControls(JdbcImportWizard.java:250)
> 	at org.eclipse.jface.wizard.WizardDialog.createPageControls(WizardDialog.java:705)
> 	at org.eclipse.jface.wizard.WizardDialog.createContents(WizardDialog.java:597)
> 	at org.eclipse.jface.window.Window.create(Window.java:430)
> 	at org.eclipse.jface.dialogs.Dialog.create(Dialog.java:1096)
> 	at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils$7.run(ModelerUiViewUtils.java:250)
> 	at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:186)
> 	at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:145)
> 	at org.eclipse.swt.widgets.Display.syncExec(Display.java:4761)
> 	at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils.launchWizard(ModelerUiViewUtils.java:240)
> 	at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils$5.run(ModelerUiViewUtils.java:185)
> 	at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:186)
> 	at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:145)
> 	at org.eclipse.swt.widgets.Display.syncExec(Display.java:4761)
> 	at org.teiid.designer.ui.viewsupport.ModelerUiViewUtils.launchWizard(ModelerUiViewUtils.java:167)
> 	at org.teiid.designer.advisor.ui.actions.AdvisorActionFactory.launchWizard(AdvisorActionFactory.java:904)
> 	at org.teiid.designer.advisor.ui.actions.AdvisorActionFactory.executeAction(AdvisorActionFactory.java:437)
> 	at org.teiid.designer.advisor.ui.views.guides.TeiidGuidesSection.launchGuidesAction(TeiidGuidesSection.java:281)
> 	at org.teiid.designer.advisor.ui.views.guides.TeiidGuidesSection.access$1(TeiidGuidesSection.java:271)
> 	at org.teiid.designer.advisor.ui.views.guides.TeiidGuidesSection$4.doubleClick(TeiidGuidesSection.java:174)
> 	at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:832)
> 	at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)
> 	at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:50)
> 	at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:173)
> 	at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:829)
> 	at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1470)
> 	at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1263)
> 	at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:252)
> 	at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:249)
> 	at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:311)
> 	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> 	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4362)
> 	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1113)
> 	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4180)
> 	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3769)
> 	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)
> 	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
> 	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)
> 	at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)
> 	at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:694)
> 	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)
> 	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:606)
> 	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> 	at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:139)
> 	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:380)
> 	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> 	at java.lang.reflect.Method.invoke(Unknown Source)
> 	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)
> 	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)
> 	at org.eclipse.equinox.launcher.Main.run(Main.java:1515)
> }}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ]
Matej Kralik updated TEIIDDES-2697:
-----------------------------------
    Labels: release_notes verified_jbdsis-9.0.1  (was: )
> Virtual procedure in generated dynamic VDB does not return result set
> ---------------------------------------------------------------------
>
>                 Key: TEIIDDES-2697
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2697
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: VDB & Execution
>    Affects Versions: 9.0.4
>            Reporter: Andrej Šmigala
>            Assignee: Barry LaFond
>              Labels: release_notes, verified_jbdsis-9.0.1
>             Fix For: 9.2, 10.0, 9.2.1
>
>         Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a virtual procedure is exported as a dynamic VDB, the virtual procedure does not return any results. This is because the generated DDL does not contain the RETURNS clause.
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000))
> 	AS
>  BEGIN
> 	SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
> Expected DDL:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE ( xml_out xml)
> 	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
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set
                                
                                
                                
                                    
                                        by Matej Kralik (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ]
Matej Kralik closed TEIIDDES-2697.
----------------------------------
> Virtual procedure in generated dynamic VDB does not return result set
> ---------------------------------------------------------------------
>
>                 Key: TEIIDDES-2697
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2697
>             Project: Teiid Designer
>          Issue Type: Bug
>          Components: VDB & Execution
>    Affects Versions: 9.0.4
>            Reporter: Andrej Šmigala
>            Assignee: Barry LaFond
>              Labels: release_notes, verified_jbdsis-9.0.1
>             Fix For: 9.2, 10.0, 9.2.1
>
>         Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a virtual procedure is exported as a dynamic VDB, the virtual procedure does not return any results. This is because the generated DDL does not contain the RETURNS clause.
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000))
> 	AS
>  BEGIN
> 	SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
> Expected DDL:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE ( xml_out xml)
> 	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
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months
                        
                        
                 
         
 
        
            
        
        
        
                
                        
                                
                                
                                        
                                
                         
                        
                                
                                
                                        
                                                
                                        
                                        
                                        [JBoss JIRA] (TEIIDDES-2880) New preview not working with table that calls UDF function
                                
                                
                                
                                    
                                        by Matus Makovy (JIRA)
                                    
                                
                                
                                        
     [ https://issues.jboss.org/browse/TEIIDDES-2880?page=com.atlassian.jira.plu... ]
Matus Makovy updated TEIIDDES-2880:
-----------------------------------
    Description: 
I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this:
{code:SQL}
SELECT
		udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT
	FROM
		hsqldbParts.PARTS
{code}
When I hit Preview Data on that table, the dynamic VDB that is generated looks like this:
{code:xml}
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1">
	<description>Importer VDB</description>
	<property name="UseConnectorMetadata" value="true" />
	<property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" />
	<model name="view" type="VIRTUAL" visible="true">
		<metadata type="DDL"><![CDATA[
CREATE VIEW tab (
	NAME_WEIGHT string
) 
AS
	select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS;
]]></metadata>
	</model>
	<model name="hsqldbParts" type="PHYSICAL" visible="true">
		<source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" />
		<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE PARTS (
	PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'),
	PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'),
	PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'),
	PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'),
	CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID)
) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"')
]]></metadata>
	</model>
</vdb>
{code}
If I see correctly, the UDF procedure is not in the dynamic VDB.
I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. 
But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function)
View model attached
  was:
I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this:
{code:SQL}
SELECT
		udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT
	FROM
		hsqldbParts.PARTS
{code}
When I hit Preview Data on that table, the dynamic VDB that is generated looks like this:
{code:xml}
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1">
	<description>Importer VDB</description>
	<property name="UseConnectorMetadata" value="true" />
	<property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" />
	<model name="view" type="VIRTUAL" visible="true">
		<metadata type="DDL"><![CDATA[
CREATE VIEW tab (
	NAME_WEIGHT string
) 
AS
	select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS;
]]></metadata>
	</model>
	<model name="hsqldbParts" type="PHYSICAL" visible="true">
		<source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" />
		<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE PARTS (
	PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'),
	PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'),
	PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'),
	PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'),
	CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID)
) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"')
]]></metadata>
	</model>
</vdb>
{code}
If I see correctly, the UDF procedure is not in the dynamic VDB.
I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. 
But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually.
View model attached
> New preview not working with table that calls UDF function 
> -----------------------------------------------------------
>
>                 Key: TEIIDDES-2880
>                 URL: https://issues.jboss.org/browse/TEIIDDES-2880
>             Project: Teiid Designer
>          Issue Type: Bug
>    Affects Versions: 10.0.1
>         Environment: MAC
>            Reporter: Matus Makovy
>         Attachments: view.xmi
>
>
> I have a view model with UDF function defined as procedure and a table that uses this UDF procedure. Transformation SQL looks like this:
> {code:SQL}
> SELECT
> 		udfConcatNull(hsqldbParts.PARTS.PART_NAME, hsqldbParts.PARTS.PART_WEIGHT) AS NAME_WEIGHT
> 	FROM
> 		hsqldbParts.PARTS
> {code}
> When I hit Preview Data on that table, the dynamic VDB that is generated looks like this:
> {code:xml}
> <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
> <vdb name="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7" version="1">
> 	<description>Importer VDB</description>
> 	<property name="UseConnectorMetadata" value="true" />
> 	<property name="deployment-name" value="PREVIEW-fd6cadf2-4ae3-4d8f-9420-22f4882201e7-vdb.xml" />
> 	<model name="view" type="VIRTUAL" visible="true">
> 		<metadata type="DDL"><![CDATA[
> CREATE VIEW tab (
> 	NAME_WEIGHT string
> ) 
> AS
> 	select udfConcatNull(hsqldbParts.PARTS.PART_NAME,hsqldbParts.PARTS.PART_WEIGHT) as NAME_WEIGHT from hsqldbParts.PARTS;
> ]]></metadata>
> 	</model>
> 	<model name="hsqldbParts" type="PHYSICAL" visible="true">
> 		<source name="hsqldbParts" translator-name="oracle" connection-jndi-name="null" />
> 		<metadata type="DDL"><![CDATA[
> CREATE FOREIGN TABLE PARTS (
> 	PART_ID string(4) NOT NULL OPTIONS(NAMEINSOURCE '"PART_ID"', NATIVE_TYPE 'CHAR', FIXED_LENGTH 'TRUE'),
> 	PART_NAME string(255) OPTIONS(NAMEINSOURCE '"PART_NAME"', NATIVE_TYPE 'VARCHAR2'),
> 	PART_COLOR string(30) OPTIONS(NAMEINSOURCE '"PART_COLOR"', NATIVE_TYPE 'VARCHAR2'),
> 	PART_WEIGHT string(255) OPTIONS(NAMEINSOURCE '"PART_WEIGHT"', NATIVE_TYPE 'VARCHAR2'),
> 	CONSTRAINT PK_PARTS PRIMARY KEY(PART_ID)
> ) OPTIONS(NAMEINSOURCE '"PARTSSUPPLIER"."PARTS"')
> ]]></metadata>
> 	</model>
> </vdb>
> {code}
> If I see correctly, the UDF procedure is not in the dynamic VDB.
> I know that the situation about dynamic VDBs and UDF functions in JAR files is complicated and I am not sure right now how this should be resolved. 
> But in my opinion the udf procedure should be in the dynamic VDB and there should be a warning that TD won't deploy the JAR to the server and if user wants to make a preview, the JAR should be deployed to the server manually. (If I remember correctly there is one when user is trying to generate dynamic VDB from static VDB with UDF function)
> View model attached
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
                                
                         
                        
                                
                                9 years, 3 months