[JBoss JIRA] (TEIIDDES-2276) Windows only - XML File Importer will not let you add elements as columns
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2276?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2276:
-----------------------------------
Fix Version/s: (was: 8.5.1)
> Windows only - XML File Importer will not let you add elements as columns
> -------------------------------------------------------------------------
>
> Key: TEIIDDES-2276
> URL: https://issues.jboss.org/browse/TEIIDDES-2276
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.4, 8.3.3
> Environment: Windows
> Reporter: Debbie Steigner
> Assignee: Mark Drilling
> Fix For: 8.3.4, 8.6
>
>
> This only happens in Window the Linux JBDS works fine. Using the attached xml file, trying importing it as a File source. At the XML File Data Import options, try to select the rss > channel > item > tns:StoreId and click Add to move it to the columns box. It won't do it and gives the below error in the log
> !ENTRY org.eclipse.ui 4 0 2014-08-07 10:24:35.234
> !MESSAGE Unhandled event loop exception
> !STACK 0
> java.lang.NullPointerException
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlColumnInfo.getName(TeiidXmlColumnInfo.java:212)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlColumnInfo.validate(TeiidXmlColumnInfo.java:466)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlColumnInfo.setRelativePath(TeiidXmlColumnInfo.java:290)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlColumnInfo.setRelativePathInternal(TeiidXmlColumnInfo.java:300)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlColumnInfo.<init>(TeiidXmlColumnInfo.java:141)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlColumnInfo.<init>(TeiidXmlColumnInfo.java:95)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlFileInfo.addNewColumn(TeiidXmlFileInfo.java:277)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.panels.XmlFileContentsGroup.createColumn(XmlFileContentsGroup.java:174)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlImportXmlConfigurationPage.createColumn(TeiidXmlImportXmlConfigurationPage.java:233)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.panels.ColumnsInfoPanel$2.widgetSelected(ColumnsInfoPanel.java:112)
> at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)
> at org.eclipse.jface.window.Window.runEventLoop(Window.java:826)
> at org.eclipse.jface.window.Window.open(Window.java:802)
> at org.eclipse.ui.internal.handlers.WizardHandler$Import.executeHandler(WizardHandler.java:152)
> at org.eclipse.ui.internal.handlers.WizardHandler.execute(WizardHandler.java:279)
> at org.eclipse.ui.internal.handlers.HandlerProxy.execute(HandlerProxy.java:290)
> at org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(E4HandlerProxy.java:90)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.eclipse.e4.core.internal.di.MethodRequestor.execute(MethodRequestor.java:56)
> at org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(InjectorImpl.java:243)
> at org.eclipse.e4.core.internal.di.InjectorImpl.invoke(InjectorImpl.java:224)
> at org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(ContextInjectionFactory.java:132)
> at org.eclipse.e4.core.commands.internal.HandlerServiceHandler.execute(HandlerServiceHandler.java:167)
> at org.eclipse.core.commands.Command.executeWithChecks(Command.java:499)
> at org.eclipse.core.commands.ParameterizedCommand.executeWithChecks(ParameterizedCommand.java:508)
> at org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(HandlerServiceImpl.java:213)
> at org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(LegacyHandlerService.java:420)
> at org.eclipse.ui.internal.actions.CommandAction.runWithEvent(CommandAction.java:157)
> at org.eclipse.ui.internal.actions.CommandAction.run(CommandAction.java:171)
> at org.eclipse.ui.actions.ImportResourcesAction.run(ImportResourcesAction.java:97)
> at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168)
> at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)
> at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)
> at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)
> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)
> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)
> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)
> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)
> at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140)
> at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611)
> at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
> at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)
> at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
> at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)
> at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
> at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)
> at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:601)
> at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)
> at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)
> at org.eclipse.equinox.launcher.Main.run(Main.java:1450)
> at org.eclipse.equinox.launcher.Main.main(Main.java:1426)
> !ENTRY org.eclipse.ui 4 0 2014-08-07 10:25:54.277
> !MESSAGE Unhandled event loop exception
> !STACK 0
> java.lang.NullPointerException
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlColumnInfo.getName(TeiidXmlColumnInfo.java:212)
> at org.teiid.designer.transformation.ui.wizards.xmlfile.TeiidXmlColumnInfo.validate(TeiidXmlColumnInfo.java:466)
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2336) Data lost performing Back and Next actions in WS to Source Model (REST) importer
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2336:
--------------------------------------
Summary: Data lost performing Back and Next actions in WS to Source Model (REST) importer
Key: TEIIDDES-2336
URL: https://issues.jboss.org/browse/TEIIDDES-2336
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.5
Reporter: Barry LaFond
Assignee: Ted Jones
Fix For: 8.6.1
Noticing that after clicking NEXT> from the Source Selection page, then defining import options and clicking <BACK, the state of the first page was mostly empty and intitial values and combo selections were gone.
Need to restore all the user data to it's original form on BACK action
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2301) XML File importer - issues with SQL generation
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2301?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2301:
----------------------------------------
Appears that the changes for TEIIDDES-2190 are resulting in the simple XML File use-case generating the wrong SQL text via the changes in *TeiidXmlImportXmlConfigurationPage.updateSqlText()* method. The TeiidXmlFileInfo.getSqlString() method was overloaded. Thinking we need a more concrete way to determine what kind of SQL statement needs to get generated via the File info object, rather than looking at existance of file names....
{code}
void updateSqlText() {
if( this.fileInfo != null ) {
if( this.info.getSourceModelName() != null ) {
String sourceModelName = this.fileInfo.getModelNameWithoutExtension(this.info.getSourceModelName());
if (this.info.getViewModelName() != null) {
String viewModelName = this.fileInfo.getModelNameWithoutExtension(this.info.getViewModelName());
sqlTextViewer.getDocument().set(fileInfo.getSqlString(sourceModelName, viewModelName, this.fileInfo.getViewProcedureName()));
} else {
sqlTextViewer.getDocument().set(fileInfo.getSqlString(sourceModelName));
}
} else {
sqlTextViewer.getDocument().set(fileInfo.getSqlStringTemplate());
}
}
}
{code}
Generated code>
{code}
CREATE VIRTUAL PROCEDURE
BEGIN
DECLARE STRING VARIABLES.qp = '';
SELECT
A.id AS id, A.office AS office, A.first AS first, A.last AS last
FROM
(EXEC SourceModel.invokeHttp('employee_info.xml')) AS f, XMLTABLE(/employee-info' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS id string PATH 'dept/employee/@id', office string PATH 'dept/employee/office/text()', first string PATH 'dept/employee/name/first/text()', last string PATH 'dept/employee/name/last/text()') AS A;
END
{code}
Should probably be:
{code}
SELECT
A.id AS id, A.office AS office, A.first AS first, A.last AS last
FROM
(EXEC SourceModel.invokeHttp('employee_info.xml')) AS f, XMLTABLE(/employee-info' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS id string PATH 'dept/employee/@id', office string PATH 'dept/employee/office/text()', first string PATH 'dept/employee/name/first/text()', last string PATH 'dept/employee/name/last/text()') AS A
{code}
> XML File importer - issues with SQL generation
> ----------------------------------------------
>
> Key: TEIIDDES-2301
> URL: https://issues.jboss.org/browse/TEIIDDES-2301
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.5
> Reporter: Mark Drilling
> Assignee: Barry LaFond
> Fix For: 8.6
>
> Attachments: xmlImportSQLGeneration.png
>
>
> In the course of working TEIIDDES-2276, I noticed that the SQL generation in the XML file import wizard is not working correctly.
> Use the xml file that is attached to 2276 - notice the generated SQL displayed in the wizard is invalid. Attaching a screencap.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months
[JBoss JIRA] (TEIIDDES-2301) XML File importer - issues with SQL generation
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2301?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2301:
--------------------------------------
Assignee: Barry LaFond
> XML File importer - issues with SQL generation
> ----------------------------------------------
>
> Key: TEIIDDES-2301
> URL: https://issues.jboss.org/browse/TEIIDDES-2301
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.5
> Reporter: Mark Drilling
> Assignee: Barry LaFond
> Fix For: 8.6
>
> Attachments: xmlImportSQLGeneration.png
>
>
> In the course of working TEIIDDES-2276, I noticed that the SQL generation in the XML file import wizard is not working correctly.
> Use the xml file that is attached to 2276 - notice the generated SQL displayed in the wizard is invalid. Attaching a screencap.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
11 years, 7 months