January 2016 - teiid-designer-issues

[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 updated TEIIDDES-2773: ---------------------------------- Summary: while generating Rest war via Teiid Designer 9.2 , Designer is appending extra semi colon in TeiidRSProviderPost class code (was: Teiid Designer 9.2 while generating Rest jar appending extra semi colon in TeiidRSProviderPost class ) > 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 > > 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, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2773) Teiid Designer 9.2 while generating Rest jar appending extra semi colon in TeiidRSProviderPost class

by sunil kumar (JIRA)

sunil kumar created TEIIDDES-2773: ------------------------------------- Summary: Teiid Designer 9.2 while generating Rest jar appending extra semi colon in TeiidRSProviderPost class 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 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, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2729) Bad export of carriage return in SQL transformation

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2729?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2729: ---------------------------------------- [~jpmat] thx!! I'll take a look at it > Bad export of carriage return in SQL transformation > --------------------------------------------------- > > Key: TEIIDDES-2729 > URL: https://issues.jboss.org/browse/TEIIDDES-2729 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 9.2 > Environment: Eclipse 4.4.2 > Teiid Designer 9.2.0.Final-v20151028-1427-B4011 > Windows 7 Enterprise 64-bit > Reporter: Jean-Pierre Matsumoto > Attachments: error.png, SimpleOracle.zip, sql.txt, TEIIDDES-2729-fix.patch > > > Carriage returns characters makes errors with export + import SQL. > Can be related to TEIIDDES-735. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2769) NPE when trying to edit a Data Role created in older teiid designer version

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2769?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2769: ----------------------------------- Attachment: org.teiid.designer.vdb-TEIIDDES-2769.patch > NPE when trying to edit a Data Role created in older teiid designer version > ---------------------------------------------------------------------------- > > Key: TEIIDDES-2769 > URL: https://issues.jboss.org/browse/TEIIDDES-2769 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 9.0.4 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 9.0.6, 10.0.1, 9.2.1 > > Attachments: org.teiid.designer.vdb-TEIIDDES-2769.patch > > > migrating VDBs from EDS 5.3.1 to JDV 6.2.0 and noticed that if we open the data role editor for VDB that was created in the Teiid designer 5.0 for EDS, it is throwing java.lang.NullPointerException when trying to edit a role and it is required for us to completely recreated data roles manually for the VDB > This issue doesn't happen in Teiid Designer 9.0.3 only 9.0.4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2769) NPE when trying to edit a Data Role created in older teiid designer version

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2769?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2769: ----------------------------------- Fix Version/s: 9.0.6 10.0.1 9.2.1 > NPE when trying to edit a Data Role created in older teiid designer version > ---------------------------------------------------------------------------- > > Key: TEIIDDES-2769 > URL: https://issues.jboss.org/browse/TEIIDDES-2769 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Affects Versions: 9.0.4 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 9.0.6, 10.0.1, 9.2.1 > > > migrating VDBs from EDS 5.3.1 to JDV 6.2.0 and noticed that if we open the data role editor for VDB that was created in the Teiid designer 5.0 for EDS, it is throwing java.lang.NullPointerException when trying to edit a role and it is required for us to completely recreated data roles manually for the VDB > This issue doesn't happen in Teiid Designer 9.0.3 only 9.0.4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2729) Bad export of carriage return in SQL transformation

by Jean-Pierre Matsumoto (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2729?page=com.atlassian.jira.plu... ] Jean-Pierre Matsumoto updated TEIIDDES-2729: -------------------------------------------- Attachment: TEIIDDES-2729-fix.patch Here is a patch to fix the issue. > Bad export of carriage return in SQL transformation > --------------------------------------------------- > > Key: TEIIDDES-2729 > URL: https://issues.jboss.org/browse/TEIIDDES-2729 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 9.2 > Environment: Eclipse 4.4.2 > Teiid Designer 9.2.0.Final-v20151028-1427-B4011 > Windows 7 Enterprise 64-bit > Reporter: Jean-Pierre Matsumoto > Attachments: error.png, SimpleOracle.zip, sql.txt, TEIIDDES-2729-fix.patch > > > Carriage returns characters makes errors with export + import SQL. > Can be related to TEIIDDES-735. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2751: ----------------------------------- Labels: release_notes verified_jbdsis-8.0.5 (was: ) > Add ability to import Oracle Packages via JDBC Import > ----------------------------------------------------- > > Key: TEIIDDES-2751 > URL: https://issues.jboss.org/browse/TEIIDDES-2751 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export, Patch Release > Affects Versions: 9.0.2 > Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Barry LaFond > Priority: Blocker > Labels: release_notes, verified_jbdsis-8.0.5 > Fix For: 9.0.5, 10.0.1, 9.2.1 > > > When using the JDBC importer with an Oracle datasource, Oracle Packages are not available to be selected. I am only allowed to select Tables, Views, and Procedures. There should be an option to select Packages, which in my case contains stored procedures. > A ticket was submitted on the TEIID side to support this functionality. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2751. ---------------------------------- > Add ability to import Oracle Packages via JDBC Import > ----------------------------------------------------- > > Key: TEIIDDES-2751 > URL: https://issues.jboss.org/browse/TEIIDDES-2751 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export, Patch Release > Affects Versions: 9.0.2 > Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3, > JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Barry LaFond > Priority: Blocker > Labels: release_notes, verified_jbdsis-8.0.5 > Fix For: 9.0.5, 10.0.1, 9.2.1 > > > When using the JDBC importer with an Oracle datasource, Oracle Packages are not available to be selected. I am only allowed to select Tables, Views, and Procedures. There should be an option to select Packages, which in my case contains stored procedures. > A ticket was submitted on the TEIID side to support this functionality. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2771) Cannot edit Native Type extension property for procedure parameter with OUT direction

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2771?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2771: ---------------------------------------- Sorry, I accidentally hit some key and assigned this to me. > Cannot edit Native Type extension property for procedure parameter with OUT direction > ------------------------------------------------------------------------------------- > > Key: TEIIDDES-2771 > URL: https://issues.jboss.org/browse/TEIIDDES-2771 > Project: Teiid Designer > Issue Type: Bug > Components: Extension Framework, Modeling > Affects Versions: 9.0.5 > Reporter: Barry LaFond > Assignee: Barry LaFond > Priority: Critical > Fix For: 9.0.6, 10.0.1, 9.2.1 > > > Selecting an OUT parameter and editing the string ends up with empty string, so it's not getting set. > Found that RelationalModelExtensionAssistant.setPropertyValue() wasn't properly checking for NATIVE_TYPE property, so the value was never getting set. Should be simple fix. Verified that once enabled, this property is getting indexed correctly in RuntimeAdapter. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2771) Cannot edit Native Type extension property for procedure parameter with OUT direction

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2771?page=com.atlassian.jira.plu... ] Matus Makovy reassigned TEIIDDES-2771: -------------------------------------- Assignee: (was: Matus Makovy) > Cannot edit Native Type extension property for procedure parameter with OUT direction > ------------------------------------------------------------------------------------- > > Key: TEIIDDES-2771 > URL: https://issues.jboss.org/browse/TEIIDDES-2771 > Project: Teiid Designer > Issue Type: Bug > Components: Extension Framework, Modeling > Affects Versions: 9.0.5 > Reporter: Barry LaFond > Priority: Critical > Fix For: 9.0.6, 10.0.1, 9.2.1 > > > Selecting an OUT parameter and editing the string ends up with empty string, so it's not getting set. > Found that RelationalModelExtensionAssistant.setPropertyValue() wasn't properly checking for NATIVE_TYPE property, so the value was never getting set. Should be simple fix. Verified that once enabled, this property is getting indexed correctly in RuntimeAdapter. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues January 2016