June 2018 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-3211) Import DDL fails with error

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3211?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-3211: ---------------------------------------- [~virtualdatabase] Try upgrading your JBDS to 11.2. I just tried that combination and the importered worked as expected. Note too that the Non-Teiid DDL import options (i.e. General) only supports a subset of 4 JDBC database types. Those sequencers/parsers hasn't been worked on in modeshape for probably 8 years and certainly doesn't support any new syntax. the "go" command, for instance won't parse and the *ASC* code is also unknown to the sequencers. > Import DDL fails with error > --------------------------- > > Key: TEIIDDES-3211 > URL: https://issues.jboss.org/browse/TEIIDDES-3211 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 11.1.3 > Environment: Windows 10 > JBDS:Version: 11.0.0.GA > Build id: GA-v20170809-0404-B748 > Build date: 20170809-0404 > Teiid Designer 11.1.3.v20180502-1457 > Reporter: Tom Johnston > > Import DDL results in error: > "java.lang.NoClassDefFoundError: Could not initialize class org.modeshape.common.CommonI18n" -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3211) Import DDL fails with error

by Tom Johnston (JIRA)

Tom Johnston created TEIIDDES-3211: -------------------------------------- Summary: Import DDL fails with error Key: TEIIDDES-3211 URL: https://issues.jboss.org/browse/TEIIDDES-3211 Project: Teiid Designer Issue Type: Bug Affects Versions: 11.1.3 Environment: Windows 10 JBDS:Version: 11.0.0.GA Build id: GA-v20170809-0404-B748 Build date: 20170809-0404 Teiid Designer 11.1.3.v20180502-1457 Reporter: Tom Johnston Import DDL results in error: "java.lang.NoClassDefFoundError: Could not initialize class org.modeshape.common.CommonI18n" -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by SHI HONG CHIN (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] SHI HONG CHIN commented on TEIIDDES-3208: ----------------------------------------- And, the documentation said "It is more proper to use a VARIADIC parameter". I don't know the reason. But, would it be possible to add the VARIADIC property in procedure parameter? > 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: 11.2 > > 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)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3210) Upgraded Designer 11.2 release to Eclipse Photon platform

by Barry LaFond (JIRA)

Barry LaFond created TEIIDDES-3210: -------------------------------------- Summary: Upgraded Designer 11.2 release to Eclipse Photon platform Key: TEIIDDES-3210 URL: https://issues.jboss.org/browse/TEIIDDES-3210 Project: Teiid Designer Issue Type: Task Components: Eclipse Integration Affects Versions: 11.2 Reporter: Barry LaFond Assignee: Barry LaFond Priority: Blocker Fix For: 11.2 Upgrade Designer version to 11.2 Change target platform to support Eclipse Photon -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by SHI HONG CHIN (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] SHI HONG CHIN edited comment on TEIIDDES-3208 at 6/26/18 9:35 PM: ------------------------------------------------------------------ For testing, I created another view model, and created another procedure in the view model to execute the SampleNativeQueryProc1 procedure which you see in the screenshots in comments above. !procedure extra param error.png|thumbnail! As you can see, there is an error telling me extra parameters passed to the procedure. This error will occur, regardless of whether I set the "function" property of SampleNativeQueryProc1 to true or false. Even if I set the "function" property to true, and the VARARGS to true (VARARGS property will only appear if I set "function" property to true), the error still occur. was (Author: cshong): For testing, I created another view model, and created another procedure in the view model to execute the SampleNativeQueryProc1 procedure which you see in the screenshots in comments above. !procedure extra param error.png|thumbnail! As you can see, there is an error telling me extra parameters passed to the procedure. > 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: 11.2 > > 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)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by SHI HONG CHIN (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] SHI HONG CHIN commented on TEIIDDES-3208: ----------------------------------------- For testing, I created another view model, and created another procedure in the view model to execute the SampleNativeQueryProc1 procedure which you see in the screenshots in comments above. !procedure extra param error.png|thumbnail! As you can see, there is an error telling me extra parameters passed to the procedure. > 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: 11.2 > > 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)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by SHI HONG CHIN (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] SHI HONG CHIN updated TEIIDDES-3208: ------------------------------------ Attachment: procedure extra param error.png > 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: 11.2 > > 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)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by SHI HONG CHIN (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] SHI HONG CHIN commented on TEIIDDES-3208: ----------------------------------------- The only way to see the VARARGS property is to set the Function property to true. But, I want to create a procedure, not a function. > 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: 11.2 > > Attachments: nativeprocparams.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)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by SHI HONG CHIN (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] SHI HONG CHIN commented on TEIIDDES-3208: ----------------------------------------- !procedures with no VARARGS.png|thumbnail! !nativeprocparams.png|thumbnail! As you can see in the above screenshot, there is no VARARGS property in procedures nor parameter. > 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: 11.2 > > Attachments: nativeprocparams.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)

6 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-3208) Support virtual / foreign procedure with VARIADIC parameter

by SHI HONG CHIN (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-3208?page=com.atlassian.jira.plu... ] SHI HONG CHIN updated TEIIDDES-3208: ------------------------------------ Attachment: procedures with no VARARGS.png > 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: 11.2 > > Attachments: nativeprocparams.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)

6 years, 8 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues June 2018