[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2687:
-----------------------------------
Fix Version/s: 10.0.2
(was: 10.0.1)
> Dynamic VDB generation - Default value for string column problem (DDL)
> ----------------------------------------------------------------------
>
> Key: TEIIDDES-2687
> URL: https://issues.jboss.org/browse/TEIIDDES-2687
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Fix For: 10.0.2, 9.2.1
>
>
> I have a model with table that has String column with default value "Stock".
> DDL generated by TD for dynamic VDB looks like this:
> {quote}
> ...
> TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'),
> ...
> {quote}
> *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'*
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIIDDES-2697) Virtual procedure in generated dynamic VDB does not return result set
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2697?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2697.
------------------------------------
Fix Version/s: 10.0.1
9.2.1
Resolution: Done
This has been fixed in master and will be in 10.0.0/10.0.1
> 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: 10.0.1, 9.2.1, 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)
9 years, 1 month
[JBoss JIRA] (TEIIDDES-2773) while generating Rest war via Teiid Designer 9.2 , Designer is appending extra semi colon in TeiidRSProviderPost class code
by sunil kumar (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2773?page=com.atlassian.jira.plu... ]
sunil kumar commented on TEIIDDES-2773:
---------------------------------------
Thansks Ted/ramesh,
it's worked form me , thanks for a correct solution.
> while generating Rest war via Teiid Designer 9.2 , Designer is appending extra semi colon in TeiidRSProviderPost class code
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2773
> URL: https://issues.jboss.org/browse/TEIIDDES-2773
> Project: Teiid Designer
> Issue Type: Bug
> Components: Build
> Affects Versions: 9.2
> Environment: JDK 1.7,
> jboss-devstudio-8.0.0.GA,
> teiid-designer-9.2.0.Final-v20151028-1427-B4011
> Reporter: sunil kumar
> Priority: Critical
> Labels: jboss
> Attachments: data-source.docx, data-source.docx, ds-detail.png, screenshot-1.png
>
>
> while generating rest war via teiid designer , designer is appending extra semi colon in TeiidRSProviderPost .class code
> String str2 = new StringBuilder().append("call ").append(paramString1).append(i != 0 ? "()" : createParmString(paramMap)).append(";").toString();
> localPreparedStatement = localConnection.prepareStatement(str2);
> and in class generating str2 with extra semi colon and passing in prepareStatement and at a time of localPreparedStatement.execute(); it is giving exception : java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month
[JBoss JIRA] (TEIIDDES-2773) while generating Rest war via Teiid Designer 9.2 , Designer is appending extra semi colon in TeiidRSProviderPost class code
by sunil kumar (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2773?page=com.atlassian.jira.plu... ]
sunil kumar closed TEIIDDES-2773.
---------------------------------
Resolution: Done
> while generating Rest war via Teiid Designer 9.2 , Designer is appending extra semi colon in TeiidRSProviderPost class code
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2773
> URL: https://issues.jboss.org/browse/TEIIDDES-2773
> Project: Teiid Designer
> Issue Type: Bug
> Components: Build
> Affects Versions: 9.2
> Environment: JDK 1.7,
> jboss-devstudio-8.0.0.GA,
> teiid-designer-9.2.0.Final-v20151028-1427-B4011
> Reporter: sunil kumar
> Priority: Critical
> Labels: jboss
> Attachments: data-source.docx, data-source.docx, ds-detail.png, screenshot-1.png
>
>
> while generating rest war via teiid designer , designer is appending extra semi colon in TeiidRSProviderPost .class code
> String str2 = new StringBuilder().append("call ").append(paramString1).append(i != 0 ? "()" : createParmString(paramMap)).append(";").toString();
> localPreparedStatement = localConnection.prepareStatement(str2);
> and in class generating str2 with extra semi colon and passing in prepareStatement and at a time of localPreparedStatement.execute(); it is giving exception : java.sql.SQLSyntaxErrorException: ORA-00911: invalid character
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years, 1 month