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 Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2773?page=com.atlassian.jira.plu... ] Ted Jones commented on TEIIDDES-2773: ------------------------------------- @ramesh, no reason. A local connection would sure simplify things. Thanks > 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, 4 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 Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2773?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-2773: ---------------------------------------- [~tejones] I see lot of users making this mistake, is there a reason you choose to use JNDI name for the VDB, instead of using the a "local" connection to the VDB? BTW, both auto generated rest war and OData use the local connections. > 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, 4 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 Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2773?page=com.atlassian.jira.plu... ] Ted Jones edited comment on TEIIDDES-2773 at 1/29/16 12:48 PM: --------------------------------------------------------------- The screenshot indicates your source model is using the VDB DS with the Oracle translator which is why you are getting the error. You need two separate DS definitions.. one for the Oracle source with its own JNDI and another for the VDB (like the one you have defined in the standalone config) with its onw JNDI. That is the JNDI you need to use for the generated WAR. was (Author: tejones): The screenshot indicates your source model is using the VDB DS with the Oracle translator which is why you are getting the error. You need to separate DS definitions.. one for the Oracle source with its own JNDI and another for the VDB (like the one you have defined in the standalone config) with its onw JNDI. That is the JNDI you need to use for the generated WAR. > 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, 4 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 Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2773?page=com.atlassian.jira.plu... ] Ted Jones commented on TEIIDDES-2773: ------------------------------------- The screenshot indicates your source model is using the VDB DS with the Oracle translator which is why you are getting the error. You need to separate DS definitions.. one for the Oracle source with its own JNDI and another for the VDB (like the one you have defined in the standalone config) with its onw JNDI. That is the JNDI you need to use for the generated WAR. > 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, 4 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 updated TEIIDDES-2773: ---------------------------------- Attachment: data-source.docx i have attached thid for teiid driver > 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, 4 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 edited comment on TEIIDDES-2773 at 1/29/16 12:37 PM: ----------------------------------------------------------------- i have attached screen shot of vdb jndi name , standalone-teiid.xml data source code sample, and screen snap shot of data source of server was (Author: sunilmatana): i have attached these file for reference > 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, 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, 4 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 updated TEIIDDES-2773: ---------------------------------- Attachment: data-source.docx ds-detail.png i have attached these file for reference > 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, 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, 4 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 updated TEIIDDES-2773: ---------------------------------- Attachment: screenshot-1.png > 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, 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, 4 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: --------------------------------------- Hi Ted Jones, i have created vdb datasource and in vdb also jndi name is vdb jndi name after that , i am getting issue in war class file of appending semi colon issue > 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, 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, 4 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 Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2773?page=com.atlassian.jira.plu... ] Ted Jones commented on TEIIDDES-2773: ------------------------------------- Hi Sunil, The error indicates you are using the Oracle JNDI for your generated REST war. You need to generate a data source for the VDB and then use that JNDI for your WAR. Thanks, Ted > 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, 4 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