[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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 months