[JBoss JIRA] (TEIIDDES-2918) Document Optimal JDBC Parameters for Teiid Connection Import
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2918:
--------------------------------------
Summary: Document Optimal JDBC Parameters for Teiid Connection Import
Key: TEIIDDES-2918
URL: https://issues.jboss.org/browse/TEIIDDES-2918
Project: Teiid Designer
Issue Type: Task
Components: Documentation
Affects Versions: 9.0.4
Reporter: Matus Makovy
As per e-mail conversation (included in 2663) with Van Halbert I am creating this issue / task.
This is a task created as a replacement for TEIIDDES-2663.
In order to import from data source through TC import, there are a couple of parameter values that help decrease the import time.
For example:
*schemaPattern* = {targetSchema}
*tableTypes* = TABLE
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 7 months
[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2688:
----------------------------------------
10.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/f6e52f12c4aa039eb...
> Dynamic VDB Generation - Problem with DDL generated for procedure
> -----------------------------------------------------------------
>
> Key: TEIIDDES-2688
> URL: https://issues.jboss.org/browse/TEIIDDES-2688
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Barry LaFond
> Fix For: 9.2
>
>
> I have a VDB that was created for consumption of REST Web Service.
> There is a procedure named getProgrammes(). DDL generated for dynamic VDB is:
> {quote}
> CREATE VIRTUAL PROCEDURE getProgrammes ()
> AS
> CREATE VIRTUAL PROCEDURE
> BEGIN
> DECLARE STRING VARIABLES.qp = '';
> SELECT
> A.pid AS pid, A."start" AS "start", A."end" AS "end", A.title AS title
> FROM
> (EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE')) AS f, XMLTABLE('/schedule' PASSING XMLPARSE(DOCUMENT f.result) COLUMNS pid string PATH 'day/broadcasts/broadcast/pid/text()', "start" string PATH 'day/broadcasts/broadcast/start/text()', "end" string PATH 'day/broadcasts/broadcast/end/text()', title string PATH 'day/broadcasts/broadcast/programme/title/text()') AS A;
> END;
> {quote}
> Obviously, there is one extra "CREATE VIRTUAL PROCEDURE".
> Even after fixing this issue there is another error:
> {quote}
> VDB: REST State: INACTIVE ERROR: TEIID31080 ViewModel.getProgrammes validation error: TEIID31118 Element "f.result" is not defined by any relevant group. ERROR: TEIID31080 ViewModel.getProgrammes1 validation error: TEIID31118 Element "f.result" is not defined by any relevant group. Models: SourceModel ViewModel
> {quote}
> "f" should be a refrence to "EXEC SourceModel.invokeHttp(action=>'GET',endpoint=>VARIABLES.qp,stream=>'TRUE'))" as descibed in the SQL
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 7 months
[JBoss JIRA] (TEIIDDES-2916) Create temporary table results in "Error in parsing of sql - null"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2916?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2916.
------------------------------------
Resolution: Rejected
Right.. see work done on https://issues.jboss.org/browse/TEIIDDES-2600
basic temp table definition is a runtime concept, so supporting that DDL/structure at design time doesn't mean anything.
> Create temporary table results in "Error in parsing of sql - null"
> ------------------------------------------------------------------
>
> Key: TEIIDDES-2916
> URL: https://issues.jboss.org/browse/TEIIDDES-2916
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 10.1
> Environment: Windows 7, Eclipse mars.2 64 bit with teiid designer 10.1.0.Final-v20160815-1405-B4103
> Reporter: Bram Gadeyne
> Priority: Critical
>
> Hi,
> I'm trying to create a virtual procedure in a view model.
> I've first developed the procedure script but when I paste it I get the same error over and over again.
> I've then reduced it to the following content (which is the start of the script).
> BEGIN
> create temporary table tmp_cohort(
> patientid integer not null,
> prod boolean not null,
> PRIMARY KEY(patientid)
> );
> END
> The designer does not seem to accept the sql and it fails with the message "ERROR: Error in parsing of sql - null"
> There a no messages in the eclipse log file.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 7 months
[JBoss JIRA] (TEIIDDES-2856) Designer perspective shown twice
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2856?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2856:
----------------------------------------
The only way I can make that happen is to use the *Window > Perspective > Save Perspective As....* action which will clone a perspective. Then you can have 2 of them. Not sure how you'd make that happen without deliberately calling that action though.
> Designer perspective shown twice
> --------------------------------
>
> Key: TEIIDDES-2856
> URL: https://issues.jboss.org/browse/TEIIDDES-2856
> Project: Teiid Designer
> Issue Type: Enhancement
> Affects Versions: 10.0, 10.1
> Reporter: Bram Gadeyne
> Attachments: designer-brackets.png, designer-no-brackets.png
>
>
> Hi,
> The designer perspective is shown twice in the selection list. Is there a difference between both? The first is shown between <> and the second is shown without.
> I've added some screenshots. In the second the database models seem to be greyed out and the default server panel is not shown.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
7 years, 7 months