[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
[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
[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
[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
[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
[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
[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
[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
[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