[JBoss JIRA] (TEIIDDES-1647) Multiple NODEFAULT and DEFAULT NS Added to Generated Procedure When Importing WSDL
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1647?page=com.atlassian.jira.plu... ]
Ted Jones updated TEIIDDES-1647:
--------------------------------
Summary: Multiple NODEFAULT and DEFAULT NS Added to Generated Procedure When Importing WSDL (was: MULTIPLE NODEFAULT and DEFAULT NS Added to Generated Procedure When Importing WSDL)
> Multiple NODEFAULT and DEFAULT NS Added to Generated Procedure When Importing WSDL
> ----------------------------------------------------------------------------------
>
> Key: TEIIDDES-1647
> URL: https://issues.jboss.org/browse/TEIIDDES-1647
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Import/Export
> Affects Versions: 8.1
> Reporter: Ted Jones
> Assignee: Ted Jones
> Fix For: 8.1
>
> Attachments: WSDL XSDs Imported.zip
>
>
> Ex:
> CREATE VIRTUAL PROCEDURE
> BEGIN
> SELECT
> XMLELEMENT(NAME "soap:Envelope", XMLNAMESPACES('http://schemas.xmlsoap.org/soap/envelope/' AS soap, DEFAULT 'http://otda.ny.gov/intake/caseinqwsdl/1_0', DEFAULT 'http://otda.ny.gov/intake/caseinquiryin/1_0'), XMLELEMENT(NAME "soap:Header"), XMLELEMENT(NAME "soap:Body", XMLELEMENT(NAME CaseInquiry, XMLELEMENT(NAME CaseNumber, XMLNAMESPACES(NO DEFAULT), NYCWMSServiceView.CaseInquiry_request.CaseNumber), XMLELEMENT(NAME DistrictNumber, XMLNAMESPACES(NO DEFAULT), NYCWMSServiceView.CaseInquiry_request.DistrictNumber)))) AS
> xml_out;
> END
>
> ERROR: At most only one NO DEFAULT or DEFAULT namespace may be specified.
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1647) MULTIPLE NODEFAULT and DEFAULT NS Added to Generated Procedure When Importing WSDL
by Ted Jones (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1647?page=com.atlassian.jira.plu... ]
Ted Jones updated TEIIDDES-1647:
--------------------------------
Attachment: WSDL XSDs Imported.zip
> MULTIPLE NODEFAULT and DEFAULT NS Added to Generated Procedure When Importing WSDL
> ----------------------------------------------------------------------------------
>
> Key: TEIIDDES-1647
> URL: https://issues.jboss.org/browse/TEIIDDES-1647
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Import/Export
> Affects Versions: 8.1
> Reporter: Ted Jones
> Assignee: Ted Jones
> Fix For: 8.1
>
> Attachments: WSDL XSDs Imported.zip
>
>
> Ex:
> CREATE VIRTUAL PROCEDURE
> BEGIN
> SELECT
> XMLELEMENT(NAME "soap:Envelope", XMLNAMESPACES('http://schemas.xmlsoap.org/soap/envelope/' AS soap, DEFAULT 'http://otda.ny.gov/intake/caseinqwsdl/1_0', DEFAULT 'http://otda.ny.gov/intake/caseinquiryin/1_0'), XMLELEMENT(NAME "soap:Header"), XMLELEMENT(NAME "soap:Body", XMLELEMENT(NAME CaseInquiry, XMLELEMENT(NAME CaseNumber, XMLNAMESPACES(NO DEFAULT), NYCWMSServiceView.CaseInquiry_request.CaseNumber), XMLELEMENT(NAME DistrictNumber, XMLNAMESPACES(NO DEFAULT), NYCWMSServiceView.CaseInquiry_request.DistrictNumber)))) AS
> xml_out;
> END
>
> ERROR: At most only one NO DEFAULT or DEFAULT namespace may be specified.
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1647) MULTIPLE NODEFAULT and DEFAULT NS Added to Generated Procedure When Importing WSDL
by Ted Jones (JIRA)
Ted Jones created TEIIDDES-1647:
-----------------------------------
Summary: MULTIPLE NODEFAULT and DEFAULT NS Added to Generated Procedure When Importing WSDL
Key: TEIIDDES-1647
URL: https://issues.jboss.org/browse/TEIIDDES-1647
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export
Affects Versions: 8.1
Reporter: Ted Jones
Assignee: Ted Jones
Fix For: 8.1
Ex:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT
XMLELEMENT(NAME "soap:Envelope", XMLNAMESPACES('http://schemas.xmlsoap.org/soap/envelope/' AS soap, DEFAULT 'http://otda.ny.gov/intake/caseinqwsdl/1_0', DEFAULT 'http://otda.ny.gov/intake/caseinquiryin/1_0'), XMLELEMENT(NAME "soap:Header"), XMLELEMENT(NAME "soap:Body", XMLELEMENT(NAME CaseInquiry, XMLELEMENT(NAME CaseNumber, XMLNAMESPACES(NO DEFAULT), NYCWMSServiceView.CaseInquiry_request.CaseNumber), XMLELEMENT(NAME DistrictNumber, XMLNAMESPACES(NO DEFAULT), NYCWMSServiceView.CaseInquiry_request.DistrictNumber)))) AS
xml_out;
END
ERROR: At most only one NO DEFAULT or DEFAULT namespace may be specified.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1644) Eclipse Juno SR2 throws exceptions for option "Generate File Translator Procedures"
by Lucie Fabrikova (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1644?page=com.atlassian.jira.plu... ]
Lucie Fabrikova updated TEIIDDES-1644:
--------------------------------------
Affects Version/s: 8.1
> Eclipse Juno SR2 throws exceptions for option "Generate File Translator Procedures"
> -----------------------------------------------------------------------------------
>
> Key: TEIIDDES-1644
> URL: https://issues.jboss.org/browse/TEIIDDES-1644
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 8.0, 8.1
> Environment: - Fedora 17,
> - my default java is from oracle jdk1.6.0_33, however in Preferences/Java there is java jre1.7.0_17
> - eclipse juno 4.2, SR2
> - abridged jboss tools 4.0 from http://download.jboss.org/jbosstools/updates/development/juno
> - teiid designer 8.1.alpha2
> Reporter: Lucie Fabrikova
>
> Alert appears while creating new Teiid Metadata Model (Relational source model), option Generate File Translator Procedures: when I leave all default options and click Finish, model is created, however an alert appears:
> Error creating XML documents
> Failed to execute runnable (java.lang.NoSuchMethodError: org.eclipse.ui.internal.PopupMenuExtender.<init>(Ljava/lang/String;Lorg/eclipse/jface/action/MenuManager;Lorg/eclipse/jface/viewers/ISelectionProvider;Lorg/eclipse/ui/IWorkbenchPart;)V)
> and next:
> Error creating XML documents
> Could not create new module due to Exception: java.lang.NullPointerException
> Eclipse console:
> Exception in thread "org.teiid.designer.ui.common.viewsupport.UiBusyIndicator runnable parent thread" org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NoSuchMethodError: org.eclipse.ui.internal.PopupMenuExtender.<init>(Ljava/lang/String;Lorg/eclipse/jface/action/MenuManager;Lorg/eclipse/jface/viewers/ISelectionProvider;Lorg/eclipse/ui/IWorkbenchPart;)V)
> at org.eclipse.swt.SWT.error(SWT.java:4361)
> at org.eclipse.swt.SWT.error(SWT.java:4276)
> at org.eclipse.swt.widgets.Synchronizer.syncExec(Synchronizer.java:196)
> at org.eclipse.ui.internal.UISynchronizer.syncExec(UISynchronizer.java:150)
> at org.eclipse.swt.widgets.Display.syncExec(Display.java:4299)
> at org.teiid.designer.ui.common.viewsupport.UiBusyIndicator$2.run(UiBusyIndicator.java:202)
> at java.lang.Thread.run(Thread.java:662)
> Caused by: java.lang.NoSuchMethodError: org.eclipse.ui.internal.PopupMenuExtender.<init>(Ljava/lang/String;Lorg/eclipse/jface/action/MenuManager;Lorg/eclipse/jface/viewers/ISelectionProvider;Lorg/eclipse/ui/IWorkbenchPart;)V
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1645) IllegalArgumentException setting SQL text for procedure
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1645?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1645:
-----------------------------------
Attachment: E2eVirtualProceduresTestScript_Teiid7.pdf
> IllegalArgumentException setting SQL text for procedure
> -------------------------------------------------------
>
> Key: TEIIDDES-1645
> URL: https://issues.jboss.org/browse/TEIIDDES-1645
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Transformations
> Affects Versions: 8.1
> Reporter: Barry LaFond
> Priority: Critical
> Fix For: 8.1
>
> Attachments: E2eVirtualProceduresTestScript_Teiid7.pdf, TEIIDDES-1645_MPS.zip
>
>
> While running our E2EVirtualProceduresTestScript (attached) the Transformation frameowork has issues with null datatype being passed down to the datatype finder.
> This occurs on most of the procedures creation in this test.
> {code}
> ava.lang.IllegalArgumentException: Expected argument to be non-null but got null
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:303)
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:289)
> at org.teiid83.type.DataTypeManagerService.getDataTypeClass(DataTypeManagerService.java:68)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.getDatatype(TransformationMappingHelper.java:1500)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.setAttributeType(TransformationMappingHelper.java:1443)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.setGroupAttributeTypes(TransformationMappingHelper.java:1322)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:769)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:823)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileMappingsOnSqlChange(TransformationMappingHelper.java:144)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorCommandEvent(TransformationObjectEditorPage.java:2729)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorEvent(TransformationObjectEditorPage.java:2689)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.processEvent(TransformationObjectEditorPage.java:2649)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.notifyEventListeners(SqlEditorPanel.java:702)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.fireEditorEvent(SqlEditorPanel.java:646)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$DocumentChangeListener.documentChanged(SqlEditorPanel.java:2215)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged2(AbstractDocument.java:769)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:736)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:721)
> at org.eclipse.jface.text.AbstractDocument.fireDocumentChanged(AbstractDocument.java:796)
> at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1237)
> at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1217)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.refreshWithDisplayComponent(SqlEditorPanel.java:608)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:476)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$5.run(SqlEditorPanel.java:517)
> {code}
> * Import attached project
> * open the MMSP03_A procedure in PartsVirtual.xmi model
> * Paste the following SQL text in the transformation editor and click Validate
> {code}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> DECLARE short VARIABLES.x;
> LOOP ON (SELECT PartsVirtual.SupplierInfo.QUANTITY FROM PartsVirtual.SupplierInfo ORDER BY quantity) AS quantityCursor
> BEGIN
> VARIABLES.x = convert((quantityCursor.QUANTITY - 1), short);
> IF(VARIABLES.x = 100)
> BEGIN
> BREAK;
> END
> ELSE
> BEGIN
> CONTINUE;
> END
> END
> SELECT PartsVirtual.SupplierInfo.QUANTITY, VARIABLES.x FROM PartsVirtual.SupplierInfo WHERE PartsVirtual.SupplierInfo.QUANTITY >= VARIABLES.x;
> END
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1645) IllegalArgumentException setting SQL text for procedure
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1645?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1645:
-----------------------------------
Description:
While running our E2EVirtualProceduresTestScript (attached) the Transformation frameowork has issues with null datatype being passed down to the datatype finder.
This occurs on most of the procedures creation in this test.
{code}
ava.lang.IllegalArgumentException: Expected argument to be non-null but got null
at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:303)
at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:289)
at org.teiid83.type.DataTypeManagerService.getDataTypeClass(DataTypeManagerService.java:68)
at org.teiid.designer.transformation.util.TransformationMappingHelper.getDatatype(TransformationMappingHelper.java:1500)
at org.teiid.designer.transformation.util.TransformationMappingHelper.setAttributeType(TransformationMappingHelper.java:1443)
at org.teiid.designer.transformation.util.TransformationMappingHelper.setGroupAttributeTypes(TransformationMappingHelper.java:1322)
at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:769)
at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:823)
at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileMappingsOnSqlChange(TransformationMappingHelper.java:144)
at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorCommandEvent(TransformationObjectEditorPage.java:2729)
at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorEvent(TransformationObjectEditorPage.java:2689)
at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.processEvent(TransformationObjectEditorPage.java:2649)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.notifyEventListeners(SqlEditorPanel.java:702)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.fireEditorEvent(SqlEditorPanel.java:646)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$DocumentChangeListener.documentChanged(SqlEditorPanel.java:2215)
at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged2(AbstractDocument.java:769)
at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:736)
at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:721)
at org.eclipse.jface.text.AbstractDocument.fireDocumentChanged(AbstractDocument.java:796)
at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1237)
at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1217)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.refreshWithDisplayComponent(SqlEditorPanel.java:608)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:476)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$5.run(SqlEditorPanel.java:517)
{code}
* Import attached project
* open the MMSP03_A procedure in PartsVirtual.xmi model
* Paste the following SQL text in the transformation editor and click Validate
{code}
CREATE VIRTUAL PROCEDURE
BEGIN
DECLARE short VARIABLES.x;
LOOP ON (SELECT PartsVirtual.SupplierInfo.QUANTITY FROM PartsVirtual.SupplierInfo ORDER BY quantity) AS quantityCursor
BEGIN
VARIABLES.x = convert((quantityCursor.QUANTITY - 1), short);
IF(VARIABLES.x = 100)
BEGIN
BREAK;
END
ELSE
BEGIN
CONTINUE;
END
END
SELECT PartsVirtual.SupplierInfo.QUANTITY, VARIABLES.x FROM PartsVirtual.SupplierInfo WHERE PartsVirtual.SupplierInfo.QUANTITY >= VARIABLES.x;
END
{code}
was:
While running our E2EVirtualProceduresTestScript (attached) the Transformation frameowork has issues with null datatype being passed down to the datatype finder.
This occurs on most of the procedures creation in this test.
{code}
ava.lang.IllegalArgumentException: Expected argument to be non-null but got null
at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:303)
at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:289)
at org.teiid83.type.DataTypeManagerService.getDataTypeClass(DataTypeManagerService.java:68)
at org.teiid.designer.transformation.util.TransformationMappingHelper.getDatatype(TransformationMappingHelper.java:1500)
at org.teiid.designer.transformation.util.TransformationMappingHelper.setAttributeType(TransformationMappingHelper.java:1443)
at org.teiid.designer.transformation.util.TransformationMappingHelper.setGroupAttributeTypes(TransformationMappingHelper.java:1322)
at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:769)
at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:823)
at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileMappingsOnSqlChange(TransformationMappingHelper.java:144)
at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorCommandEvent(TransformationObjectEditorPage.java:2729)
at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorEvent(TransformationObjectEditorPage.java:2689)
at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.processEvent(TransformationObjectEditorPage.java:2649)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.notifyEventListeners(SqlEditorPanel.java:702)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.fireEditorEvent(SqlEditorPanel.java:646)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$DocumentChangeListener.documentChanged(SqlEditorPanel.java:2215)
at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged2(AbstractDocument.java:769)
at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:736)
at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:721)
at org.eclipse.jface.text.AbstractDocument.fireDocumentChanged(AbstractDocument.java:796)
at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1237)
at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1217)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.refreshWithDisplayComponent(SqlEditorPanel.java:608)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:476)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$5.run(SqlEditorPanel.java:517)
{code}
> IllegalArgumentException setting SQL text for procedure
> -------------------------------------------------------
>
> Key: TEIIDDES-1645
> URL: https://issues.jboss.org/browse/TEIIDDES-1645
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Transformations
> Affects Versions: 8.1
> Reporter: Barry LaFond
> Priority: Critical
> Fix For: 8.1
>
> Attachments: E2eVirtualProceduresTestScript_Teiid7.pdf, TEIIDDES-1645_MPS.zip
>
>
> While running our E2EVirtualProceduresTestScript (attached) the Transformation frameowork has issues with null datatype being passed down to the datatype finder.
> This occurs on most of the procedures creation in this test.
> {code}
> ava.lang.IllegalArgumentException: Expected argument to be non-null but got null
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:303)
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:289)
> at org.teiid83.type.DataTypeManagerService.getDataTypeClass(DataTypeManagerService.java:68)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.getDatatype(TransformationMappingHelper.java:1500)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.setAttributeType(TransformationMappingHelper.java:1443)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.setGroupAttributeTypes(TransformationMappingHelper.java:1322)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:769)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:823)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileMappingsOnSqlChange(TransformationMappingHelper.java:144)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorCommandEvent(TransformationObjectEditorPage.java:2729)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorEvent(TransformationObjectEditorPage.java:2689)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.processEvent(TransformationObjectEditorPage.java:2649)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.notifyEventListeners(SqlEditorPanel.java:702)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.fireEditorEvent(SqlEditorPanel.java:646)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$DocumentChangeListener.documentChanged(SqlEditorPanel.java:2215)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged2(AbstractDocument.java:769)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:736)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:721)
> at org.eclipse.jface.text.AbstractDocument.fireDocumentChanged(AbstractDocument.java:796)
> at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1237)
> at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1217)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.refreshWithDisplayComponent(SqlEditorPanel.java:608)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:476)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$5.run(SqlEditorPanel.java:517)
> {code}
> * Import attached project
> * open the MMSP03_A procedure in PartsVirtual.xmi model
> * Paste the following SQL text in the transformation editor and click Validate
> {code}
> CREATE VIRTUAL PROCEDURE
> BEGIN
> DECLARE short VARIABLES.x;
> LOOP ON (SELECT PartsVirtual.SupplierInfo.QUANTITY FROM PartsVirtual.SupplierInfo ORDER BY quantity) AS quantityCursor
> BEGIN
> VARIABLES.x = convert((quantityCursor.QUANTITY - 1), short);
> IF(VARIABLES.x = 100)
> BEGIN
> BREAK;
> END
> ELSE
> BEGIN
> CONTINUE;
> END
> END
> SELECT PartsVirtual.SupplierInfo.QUANTITY, VARIABLES.x FROM PartsVirtual.SupplierInfo WHERE PartsVirtual.SupplierInfo.QUANTITY >= VARIABLES.x;
> END
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1645) IllegalArgumentException setting SQL text for procedure
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-1645?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-1645:
-----------------------------------
Attachment: TEIIDDES-1645_MPS.zip
> IllegalArgumentException setting SQL text for procedure
> -------------------------------------------------------
>
> Key: TEIIDDES-1645
> URL: https://issues.jboss.org/browse/TEIIDDES-1645
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Transformations
> Affects Versions: 8.1
> Reporter: Barry LaFond
> Priority: Critical
> Fix For: 8.1
>
> Attachments: TEIIDDES-1645_MPS.zip
>
>
> While running our E2EVirtualProceduresTestScript (attached) the Transformation frameowork has issues with null datatype being passed down to the datatype finder.
> This occurs on most of the procedures creation in this test.
> {code}
> ava.lang.IllegalArgumentException: Expected argument to be non-null but got null
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:303)
> at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:289)
> at org.teiid83.type.DataTypeManagerService.getDataTypeClass(DataTypeManagerService.java:68)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.getDatatype(TransformationMappingHelper.java:1500)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.setAttributeType(TransformationMappingHelper.java:1443)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.setGroupAttributeTypes(TransformationMappingHelper.java:1322)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:769)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:823)
> at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileMappingsOnSqlChange(TransformationMappingHelper.java:144)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorCommandEvent(TransformationObjectEditorPage.java:2729)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorEvent(TransformationObjectEditorPage.java:2689)
> at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.processEvent(TransformationObjectEditorPage.java:2649)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.notifyEventListeners(SqlEditorPanel.java:702)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.fireEditorEvent(SqlEditorPanel.java:646)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$DocumentChangeListener.documentChanged(SqlEditorPanel.java:2215)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged2(AbstractDocument.java:769)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:736)
> at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:721)
> at org.eclipse.jface.text.AbstractDocument.fireDocumentChanged(AbstractDocument.java:796)
> at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1237)
> at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1217)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.refreshWithDisplayComponent(SqlEditorPanel.java:608)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:476)
> at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$5.run(SqlEditorPanel.java:517)
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years
[JBoss JIRA] (TEIIDDES-1645) IllegalArgumentException setting SQL text for procedure
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-1645:
--------------------------------------
Summary: IllegalArgumentException setting SQL text for procedure
Key: TEIIDDES-1645
URL: https://issues.jboss.org/browse/TEIIDDES-1645
Project: Teiid Designer
Issue Type: Feature Request
Components: Transformations
Affects Versions: 8.1
Reporter: Barry LaFond
Priority: Critical
Fix For: 8.1
While running our E2EVirtualProceduresTestScript (attached) the Transformation frameowork has issues with null datatype being passed down to the datatype finder.
This occurs on most of the procedures creation in this test.
{code}
ava.lang.IllegalArgumentException: Expected argument to be non-null but got null
at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:303)
at org.teiid.core.util.ArgCheck.isNotNull(ArgCheck.java:289)
at org.teiid83.type.DataTypeManagerService.getDataTypeClass(DataTypeManagerService.java:68)
at org.teiid.designer.transformation.util.TransformationMappingHelper.getDatatype(TransformationMappingHelper.java:1500)
at org.teiid.designer.transformation.util.TransformationMappingHelper.setAttributeType(TransformationMappingHelper.java:1443)
at org.teiid.designer.transformation.util.TransformationMappingHelper.setGroupAttributeTypes(TransformationMappingHelper.java:1322)
at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:769)
at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileTargetAttributes(TransformationMappingHelper.java:823)
at org.teiid.designer.transformation.util.TransformationMappingHelper.reconcileMappingsOnSqlChange(TransformationMappingHelper.java:144)
at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorCommandEvent(TransformationObjectEditorPage.java:2729)
at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.handleSqlEditorEvent(TransformationObjectEditorPage.java:2689)
at org.teiid.designer.transformation.ui.editors.TransformationObjectEditorPage.processEvent(TransformationObjectEditorPage.java:2649)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.notifyEventListeners(SqlEditorPanel.java:702)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.fireEditorEvent(SqlEditorPanel.java:646)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$DocumentChangeListener.documentChanged(SqlEditorPanel.java:2215)
at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged2(AbstractDocument.java:769)
at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:736)
at org.eclipse.jface.text.AbstractDocument.doFireDocumentChanged(AbstractDocument.java:721)
at org.eclipse.jface.text.AbstractDocument.fireDocumentChanged(AbstractDocument.java:796)
at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1237)
at org.eclipse.jface.text.AbstractDocument.set(AbstractDocument.java:1217)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.refreshWithDisplayComponent(SqlEditorPanel.java:608)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel.setTextInTransaction(SqlEditorPanel.java:476)
at org.teiid.designer.transformation.ui.editors.sqleditor.SqlEditorPanel$5.run(SqlEditorPanel.java:517)
{code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years