[JBoss JIRA] (TEIIDDES-2718) valid characters in add custom property name
by Mirco Marchitiello (JIRA)
Mirco Marchitiello created TEIIDDES-2718:
--------------------------------------------
Summary: valid characters in add custom property name
Key: TEIIDDES-2718
URL: https://issues.jboss.org/browse/TEIIDDES-2718
Project: Teiid Designer
Issue Type: Enhancement
Affects Versions: 9.0
Environment: JBoss Developer Studio 9.0.0 GA
Reporter: Mirco Marchitiello
Priority: Minor
Trying to add a custom property in a VDB some characters are not accepted in the name field, so it is not possible to add properties such as:
{http://teiid.org/rest}passthrough-auth}
the not-accepted characters in this case are "{", "}", ":", "/" and "."
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2699) Issues with Dynamic VDB import/export
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2699?page=com.atlassian.jira.plu... ]
Andrej Šmigala commented on TEIIDDES-2699:
------------------------------------------
[~blafond], there are some features that are not supported by dynamic VDBs (XML models, webservice models, UDFs to some extent), how should we address it?
In current designer, exporting VDB with e.g. WS model results in a <model> element with empty metadata. There does not seem to be an easy way to fix that (other than Teiid adding support for these in dynamic VDBs).
> Issues with Dynamic VDB import/export
> -------------------------------------
>
> Key: TEIIDDES-2699
> URL: https://issues.jboss.org/browse/TEIIDDES-2699
> Project: Teiid Designer
> Issue Type: Task
> Components: VDB & Execution
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Priority: Blocker
> Fix For: 9.3
>
>
> Tracking jira for all issues with dynamic VDB import and export
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2682) Importing Teiid DDL and selecting wrong model type results in error
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2682?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2682:
--------------------------------------
Assignee: Barry LaFond
> Importing Teiid DDL and selecting wrong model type results in error
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2682
> URL: https://issues.jboss.org/browse/TEIIDDES-2682
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 9.0.4
> Environment: MAC OS
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 10.0
>
> Attachments: Screen Shot 2015-10-12 at 13.32.49.png, view.ddl
>
>
> When you import Teiid DDL that was created as export from VIEW MODEL and you select SOURCE MODEL during the import, this process results in error dialogue that is not really helpful for user. (see screenshot)
> I think the error message should be more accurate
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set
by Andrej Šmigala (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ]
Andrej Šmigala reopened TEIIDDES-2697:
--------------------------------------
I tested this with 9.2 and the DDL is now
{code:sql}
CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE (xml_out xml))
AS
BEGIN
SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS c1, 'c2' AS c2)) AS xml_out;
END;
{code}
Note the extra closing brace in the returns clause.
The same problem occurs with scalar return values, e.g.
{code:sql}
CREATE VIRTUAL FUNCTION udfConcatNull (stringLeft string(4000), stringRight string(4000), concatenatedResult string(4000)) RETURNS string
) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')
{code}
> Virtual procedure in generated dynamic VDB does not return result set
> ---------------------------------------------------------------------
>
> Key: TEIIDDES-2697
> URL: https://issues.jboss.org/browse/TEIIDDES-2697
> Project: Teiid Designer
> Issue Type: Bug
> Components: VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Andrej Šmigala
> Assignee: Barry LaFond
> Fix For: 9.2
>
> Attachments: DynamicProcedureProject.zip
>
>
> When a VDB containing view model with a virtual procedure is exported as a dynamic VDB, the virtual procedure does not return any results. This is because the generated DDL does not contain the RETURNS clause.
> Generated DDL:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000))
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
> Expected DDL:
> {code:sql}
> CREATE VIRTUAL PROCEDURE testProc (p1 string(4000)) RETURNS TABLE ( xml_out xml)
> AS
> BEGIN
> SELECT XMLELEMENT(NAME test, XMLFOREST(ProcedureModel.testProc.p1 AS elem1, 'elem2' AS elem2)) AS xml_out;
> END;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2716) Improve importing of dynamic VDBs
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2716:
--------------------------------------
Summary: Improve importing of dynamic VDBs
Key: TEIIDDES-2716
URL: https://issues.jboss.org/browse/TEIIDDES-2716
Project: Teiid Designer
Issue Type: Enhancement
Reporter: Matus Makovy
If you want to import dynamic VDB now, you have to import a file to a project and then right-click the dynamic VDB and select Modeling -> Generate VDB archive and models.
I thnik it could be more user friendly. For example there could be an option to import dynamic VDB using: File -> Import -> Dynamic VDB. One wizard would guide you through the whole import of the vdb xml file to the project.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months
[JBoss JIRA] (TEIIDDES-2469) [Usability] Problem importing SOAP web service via URL
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2469?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2469:
-----------------------------------
Fix Version/s: 9.3
(was: 9.2)
(was: 9.0.4)
> [Usability] Problem importing SOAP web service via URL
> ------------------------------------------------------
>
> Key: TEIIDDES-2469
> URL: https://issues.jboss.org/browse/TEIIDDES-2469
> Project: Teiid Designer
> Issue Type: Quality Risk
> Components: Import/Export
> Affects Versions: 9.0
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 9.3
>
> Attachments: bug.mov, define-rest-procedure-tags-dialog.png
>
>
> Conversation:
> [09:44] <jmarley> vhalbert: do you have a document for import soap web service via url
> [09:45] <jmarley> we are getting hung up on creating relational model
> [09:45] <jmarley> vhalbert: nevermind,
> [09:46] <jmarley> vhalbert: there was an error saying we didn't have a column defined, but it was for a different procedure than the one that was selected, which and we didn't know we needed to select the other procedure and assumed it was issue with current procedure we were working with
> [09:47] <vhalbert> jmarley, hm
> [09:47] <vhalbert> jmarley, so designer was processing something that wasn't selected
> [09:48] <jmarley> vhalbert: yes, and didn't give an indication as to which procedure it was referring to
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 7 months