October 2015 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2232) Cannot create JDBC/Oracle connection profile using ServiceName syntax

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ] Van Halbert edited comment on TEIIDDES-2232 at 10/16/15 4:53 PM: ----------------------------------------------------------------- Would it be possible to contribute a new connection profile to support the use of servicename? Because the default translator is set to the generic jdbc translator, it leads to mistakes. was (Author: van.halbert): Would it be possible to contribute a new connection profile to support the use of servicename? > Cannot create JDBC/Oracle connection profile using ServiceName syntax > --------------------------------------------------------------------- > > Key: TEIIDDES-2232 > URL: https://issues.jboss.org/browse/TEIIDDES-2232 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 8.4 > Reporter: Tom Johnston > Assignee: Barry LaFond > > Cannot successfully create a jdbc url like: > "jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename" > which is found here: > http://docs.oracle.com/cd/B14117_01/java.101/b10979/urls.htm > Note the "../myservicename" -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2232) Cannot create JDBC/Oracle connection profile using ServiceName syntax

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2232: --------------------------------------- Would it be possible to contribute a new connection profile to support the use of servicename? > Cannot create JDBC/Oracle connection profile using ServiceName syntax > --------------------------------------------------------------------- > > Key: TEIIDDES-2232 > URL: https://issues.jboss.org/browse/TEIIDDES-2232 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 8.4 > Reporter: Tom Johnston > Assignee: Barry LaFond > > Cannot successfully create a jdbc url like: > "jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename" > which is found here: > http://docs.oracle.com/cd/B14117_01/java.101/b10979/urls.htm > Note the "../myservicename" -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2232) Cannot create JDBC/Oracle connection profile using ServiceName syntax

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ] Van Halbert reassigned TEIIDDES-2232: ------------------------------------- Assignee: Barry LaFond > Cannot create JDBC/Oracle connection profile using ServiceName syntax > --------------------------------------------------------------------- > > Key: TEIIDDES-2232 > URL: https://issues.jboss.org/browse/TEIIDDES-2232 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 8.4 > Reporter: Tom Johnston > Assignee: Barry LaFond > > Cannot successfully create a jdbc url like: > "jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename" > which is found here: > http://docs.oracle.com/cd/B14117_01/java.101/b10979/urls.htm > Note the "../myservicename" -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2232) Cannot create JDBC/Oracle connection profile using ServiceName syntax

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ] RH Bugzilla Integration updated TEIIDDES-2232: ---------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1272599 Bugzilla Update: Perform > Cannot create JDBC/Oracle connection profile using ServiceName syntax > --------------------------------------------------------------------- > > Key: TEIIDDES-2232 > URL: https://issues.jboss.org/browse/TEIIDDES-2232 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 8.4 > Reporter: Tom Johnston > > Cannot successfully create a jdbc url like: > "jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename" > which is found here: > http://docs.oracle.com/cd/B14117_01/java.101/b10979/urls.htm > Note the "../myservicename" -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2264) Problem Saving view model: outer scope rule issue

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2264?page=com.atlassian.jira.plu... ] Johnathon Lee updated TEIIDDES-2264: ------------------------------------ > Problem Saving view model: outer scope rule issue > ------------------------------------------------- > > Key: TEIIDDES-2264 > URL: https://issues.jboss.org/browse/TEIIDDES-2264 > Project: Teiid Designer > Issue Type: Bug > Components: Teiid Integration > Affects Versions: 8.5 > Reporter: Tom Johnston > > While trying to figure out what corrupted my workspace I have done the following: > Cloned my project. > figured out the likely model containing the problem > one by one copied off the transformations > deleted the table that I felt was the issue. > Saved > I got this message upon saving: > Problem occured: > Attempted to beginRule: F/August/views, does not match outer scope rule: L/August/views/metadataStuff.xmi > Attempted to beginRule: F/August/views, does not match outer scope rule: L/August/views/metadataStuff.xmi > This is the stacktrace: > java.lang.IllegalArgumentException: Attempted to beginRule: F/August/views, does not match outer scope rule: L/August/views/metadataStuff.xmi > at org.eclipse.core.runtime.Assert.isLegal(Assert.java:63) > at org.eclipse.core.internal.jobs.ThreadJob.illegalPush(ThreadJob.java:134) > at org.eclipse.core.internal.jobs.ThreadJob.push(ThreadJob.java:333) > at org.eclipse.core.internal.jobs.ImplicitJobs.begin(ImplicitJobs.java:85) > at org.eclipse.core.internal.jobs.JobManager.beginRule(JobManager.java:286) > at org.eclipse.core.internal.resources.WorkManager.checkIn(WorkManager.java:118) > at org.eclipse.core.internal.resources.Workspace.prepareOperation(Workspace.java:2283) > at org.eclipse.core.internal.resources.Resource.refreshLocal(Resource.java:1691) > at org.eclipse.core.internal.resources.File.refreshLocal(File.java:333) > at org.teiid.designer.core.workspace.ModelBufferImpl.save(ModelBufferImpl.java:509) > at org.teiid.designer.core.workspace.OpenableImpl.save(OpenableImpl.java:319) > at org.teiid.designer.core.workspace.ModelResourceImpl.save(ModelResourceImpl.java:1013) > at org.teiid.designer.ui.viewsupport.ModelUtilities.saveModelResource(ModelUtilities.java:1750) > at org.teiid.designer.ui.editors.ModelEditor$1.runInWorkspace(ModelEditor.java:416) > at org.eclipse.core.internal.resources.InternalWorkspaceJob.run(InternalWorkspaceJob.java:38) > at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[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: ---------------------------------------- The Dyn. VDB generator had assumed that CREATE VIRTUAL PROCEDURE XXXXX was *NOT* in the SQL. This was a change in Teiid awhile back. So some *older* VDBs may still have the *old* SQL statement which would result in the generated DDL in your description. My fix was to look at the SQL first, then strip off the CREATE VIRTUAL PROCEDURE from the T-form's SQL string first before appending the SQL to the string builder. > 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)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2688) Dynamic VDB Generation - Problem with DDL generated for procedure

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2688?page=com.atlassian.jira.plu... ] Matus Makovy commented on TEIIDDES-2688: ---------------------------------------- The SQL in the view model doesn't include CREATE VIRTUAL PROCEDURE. > 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)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2692) Operation editor still show that SQL is invalid but it is valid.

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2692?page=com.atlassian.jira.plu... ] RH Bugzilla Integration updated TEIIDDES-2692: ---------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1272104 Bugzilla Update: Perform > Operation editor still show that SQL is invalid but it is valid. > ---------------------------------------------------------------- > > Key: TEIIDDES-2692 > URL: https://issues.jboss.org/browse/TEIIDDES-2692 > Project: Teiid Designer > Issue Type: Bug > Components: Editors, Validation > Affects Versions: 9.0.4 > Environment: Fedora 22 > Reporter: Matej Kralik > Priority: Minor > Attachments: ProductsProject.zip, Snímka obrazovky z 2015-10-15 15-50-28.png > > > I rename incorrect name in xml document to correct. When I try validate SQL in the web operation, nothing happend. As soon as I freely adjusted SQL in the operation, validate is correct. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2693) Allow warnings to be presented to the user when importing from JDBC

by Andrej Šmigala (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2693?page=com.atlassian.jira.plu... ] Andrej Šmigala updated TEIIDDES-2693: ------------------------------------- Description: This came up when resolving TEIIDDES-2458. The fix attempts to get the correct name in source for the sybase tables, but there's a possibility this will fail. We still want to finish the import, but we'd also like to warn the user the NIS might be incorrect. See the comment in this PR: https://github.com/Teiid-Designer/teiid-designer/pull/516 <blafond> asmigala: oops. missed it. Since this warning would probably occur on multiple tables/columns it wouldn't be good to pop up a dialog during the processing. <blafond> asmigala: If we added an IStatus[] to RelationalModelProcessorImpl, we could check it's Severity and throw up a Warning/Error summary dialog after processing? was: This came up when resolving TEIIDDES-2458. The fix attempts to get the correct name in source for the sybase tables, but there's a possibility this will fail. We still want to finish the import, but we'd also like to warn the user the NIS might be incorrect. See the comment this PR: https://github.com/Teiid-Designer/teiid-designer/pull/516 <blafond> asmigala: oops. missed it. Since this warning would probably occur on multiple tables/columns it wouldn't be good to pop up a dialog during the processing. <blafond> asmigala: If we added an IStatus[] to RelationalModelProcessorImpl, we could check it's Severity and throw up a Warning/Error summary dialog after processing? > Allow warnings to be presented to the user when importing from JDBC > ------------------------------------------------------------------- > > Key: TEIIDDES-2693 > URL: https://issues.jboss.org/browse/TEIIDDES-2693 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export > Reporter: Andrej Šmigala > > This came up when resolving TEIIDDES-2458. The fix attempts to get the correct name in source for the sybase tables, but there's a possibility this will fail. We still want to finish the import, but we'd also like to warn the user the NIS might be incorrect. > See the comment in this PR: https://github.com/Teiid-Designer/teiid-designer/pull/516 > <blafond> asmigala: oops. missed it. Since this warning would probably occur on multiple tables/columns it wouldn't be good to pop up a dialog during the processing. > <blafond> asmigala: If we added an IStatus[] to RelationalModelProcessorImpl, we could check it's Severity and throw up a Warning/Error summary dialog after processing? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2693) Allow warnings to be presented to the user when importing from JDBC

by Andrej Šmigala (JIRA)

Andrej Šmigala created TEIIDDES-2693: ---------------------------------------- Summary: Allow warnings to be presented to the user when importing from JDBC Key: TEIIDDES-2693 URL: https://issues.jboss.org/browse/TEIIDDES-2693 Project: Teiid Designer Issue Type: Enhancement Components: Import/Export Reporter: Andrej Šmigala This came up when resolving TEIIDDES-2458. The fix attempts to get the correct name in source for the sybase tables, but there's a possibility this will fail. We still want to finish the import, but we'd also like to warn the user the NIS might be incorrect. See the comment this PR: https://github.com/Teiid-Designer/teiid-designer/pull/516 <blafond> asmigala: oops. missed it. Since this warning would probably occur on multiple tables/columns it wouldn't be good to pop up a dialog during the processing. <blafond> asmigala: If we added an IStatus[] to RelationalModelProcessorImpl, we could check it's Severity and throw up a Warning/Error summary dialog after processing? -- This message was sent by Atlassian JIRA (v6.4.11#64026)

10 years, 6 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2015