February 2016 - teiid-designer-issues

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

8 years, 3 months

1
0
0 / 0

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

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2539) Problems with preserving JDBC username and password on MAC OS X

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2539?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2539: --------------------------------------------------- Matus Makovy <mmakovy(a)redhat.com> changed the Status of [bug 1223298|https://bugzilla.redhat.com/show_bug.cgi?id=1223298] from NEW to CLOSED > Problems with preserving JDBC username and password on MAC OS X > --------------------------------------------------------------- > > Key: TEIIDDES-2539 > URL: https://issues.jboss.org/browse/TEIIDDES-2539 > Project: Teiid Designer > Issue Type: Bug > Affects Versions: 9.0.2 > Environment: MAC OS X > Reporter: Matus Makovy > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-8.0.4.CR3 > Fix For: 9.0.4 > > > When you change the password and username for JDBC connection, start server, stop server and restart JBDS, username and password are not preserved. > See video in comment (video was too big for JIRA) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

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

8 years, 3 months

1
0
0 / 0

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

8 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues February 2016