[JBoss JIRA] (TEIIDDES-3212) Add Datatools profile plugins as <includes> to designer connectivity feature
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-3212:
--------------------------------------
Summary: Add Datatools profile plugins as <includes> to designer connectivity feature
Key: TEIIDDES-3212
URL: https://issues.jboss.org/browse/TEIIDDES-3212
Project: Teiid Designer
Issue Type: Task
Components: Datatools Integration, Eclipse Integration
Affects Versions: 11.2
Reporter: Barry LaFond
Priority: Blocker
Fix For: 11.2
The Integration stack standalone installer does not include the dependencies to bring in the vendor-specific connection profile plugins provided by datatools (i.e. hsqldb, ingres, mysql, postgresql, etc...)
Need to change Designer features to force this dependency
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
5 years, 10 months
[JBoss JIRA] (TEIIDDES-3207) Data Tools Result View error in Eclipse Photon M6
by Nick Boldt (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3207?page=com.atlassian.jira.plu... ]
Nick Boldt commented on TEIIDDES-3207:
--------------------------------------
by the by, the latest TP is 4.80.1.Final.
http://download.jboss.org/jbosstools/targetplatforms/jbosstoolstarget/4.8...
> Data Tools Result View error in Eclipse Photon M6
> -------------------------------------------------
>
> Key: TEIIDDES-3207
> URL: https://issues.jboss.org/browse/TEIIDDES-3207
> Project: Teiid Designer
> Issue Type: Bug
> Components: Eclipse Integration
> Affects Versions: 11.2
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 11.2
>
> Attachments: td1.png, td2.png, td3.png, td4.png
>
>
> While testing initial Designer upgrade to Photon target platform, my initial test produced an odd error opening the SQL Results View from the Data Tools Eclipse feature.
> I then installed basic Eclipse IDE for Java Developers version and added/installed the *Database Development* category.
> Opening the Database Development perspective then opening the *SQL Results* view throws the same error below:
> {code}
> Root exception:
> java.lang.NoSuchMethodError: org.apache.lucene.index.IndexWriter.addDocument(Ljava/lang/Iterable;)J
> at org.eclipse.datatools.sqltools.result.internal.index.ResultHistoryLuceneIndex.addResults(ResultHistoryLuceneIndex.java:139)
> at org.eclipse.datatools.sqltools.result.ResultsViewPlugin.start(ResultsViewPlugin.java:117)
> at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:779)
> at org.eclipse.osgi.internal.framework.BundleContextImpl$3.run(BundleContextImpl.java:1)
> {code}
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
5 years, 10 months
[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-3208:
-----------------------------------
Fix Version/s: Future
(was: 11.2)
> Support virtual / foreign procedure with VARIADIC parameter
> -----------------------------------------------------------
>
> Key: TEIIDDES-3208
> URL: https://issues.jboss.org/browse/TEIIDDES-3208
> Project: Teiid Designer
> Issue Type: Enhancement
> Affects Versions: 11.1
> Environment: Operating system: Windows 10.
> Reporter: SHI HONG CHIN
> Assignee: Barry LaFond
> Fix For: Future
>
> Attachments: nativeprocparams.png, procedure extra param error.png, procedures with no VARARGS.png
>
>
> I wanted to create a native query procedure which support unlimited number of object type parameters.
> According to the documentation titled "DDL Metadata for Schema Objects" at http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metad..., the following SQL statement define a procedure with VARIADIC parameter by adding the word "VARIADIC" before the parameter name:
> {code:java}
> CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer)
> RETURNS (x string);
> {code}
> In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure.
> Please add this feature to Teiid Designer.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
5 years, 10 months
[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-3208:
----------------------------------------
Per the forum discussion:
*there is no Designer model support that is possible for procedure variadic parameters - they can only be specified in DDL.*
Basically the vdb's generated runtime metadata does not support the variadic parameter and value. Pushing to future release when the runtime can be adjusted.
> Support virtual / foreign procedure with VARIADIC parameter
> -----------------------------------------------------------
>
> Key: TEIIDDES-3208
> URL: https://issues.jboss.org/browse/TEIIDDES-3208
> Project: Teiid Designer
> Issue Type: Enhancement
> Affects Versions: 11.1
> Environment: Operating system: Windows 10.
> Reporter: SHI HONG CHIN
> Assignee: Barry LaFond
> Fix For: Future
>
> Attachments: nativeprocparams.png, procedure extra param error.png, procedures with no VARARGS.png
>
>
> I wanted to create a native query procedure which support unlimited number of object type parameters.
> According to the documentation titled "DDL Metadata for Schema Objects" at http://teiid.github.io/teiid-documents/10.2.x/content/reference/DDL_Metad..., the following SQL statement define a procedure with VARIADIC parameter by adding the word "VARIADIC" before the parameter name:
> {code:java}
> CREATE FOREIGN PROCEDURE proc (x integer, VARIADIC z integer)
> RETURNS (x string);
> {code}
> In Teiid Designer, I cannot find any way to define a VARIADIC parameter in a procedure.
> Please add this feature to Teiid Designer.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
5 years, 10 months
[JBoss JIRA] (TEIIDDES-3206) Unable to add sources to a Multi-source model
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-3206?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-3206.
------------------------------------
Resolution: Done
https://github.com/Teiid-Designer/teiid-designer/commit/c1260522247684c3a...
> Unable to add sources to a Multi-source model
> ---------------------------------------------
>
> Key: TEIIDDES-3206
> URL: https://issues.jboss.org/browse/TEIIDDES-3206
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 11.1.3
> Reporter: Debbie Steigner
> Assignee: Barry LaFond
> Fix For: 11.2
>
>
> With an existing VDB with Multi-source models already defined, if you want to add more clicking on the Add button does nothing. You have to delete one of the existing sources then you can Add additional. I see the below in the .log:
> !ENTRY org.eclipse.ui 4 0 2018-06-14 07:41:18.381
> !MESSAGE Unhandled event loop exception
> !STACK 0
> java.lang.NullPointerException
> at org.teiid.designer.vdb.VdbSourceInfo.add(VdbSourceInfo.java:94)
> at org.teiid.designer.vdb.ui.editor.panels.ModelDetailsPanel$4.widgetSelected(ModelDetailsPanel.java:233)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:249)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:86)
> at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5348)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1348)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4602)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4183)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1150)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1039)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:153)
> at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:680)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:336)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:594)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:148)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:151)
> 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:497)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:653)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:590)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1499)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1472)
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
5 years, 10 months