October 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2951) Designer haven't set password to datasource which is created before preview.

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2951?page=com.atlassian.jira.plu... ] Matus Makovy reassigned TEIIDDES-2951: -------------------------------------- Assignee: Matus Makovy > Designer haven't set password to datasource which is created before preview. > ---------------------------------------------------------------------------- > > Key: TEIIDDES-2951 > URL: https://issues.jboss.org/browse/TEIIDDES-2951 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview > Affects Versions: 10.0.2 > Environment: Fedora 24 > Reporter: Matej Kralik > Assignee: Matus Makovy > Priority: Critical > Attachments: screenshot1.png, screenshot2.png > > > I generated source model from a database (SQL Server) via JDBC. When I go through wizard I haven't started server so the data source haven't been set (screenshot1). I started a server and I wanted to preview data, shows me dialog ([TEIIDDES-2904|https://issues.jboss.org/browse/TEIIDDES-2904]) if I had wanted to create DS. I clicked yes and ok but server shows error: > {code:java} > org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for SQL_Server_2008_Books were not available. The command could not be planned properly. > {code} > I tried to create the data source (with the same name) manually but the error is still there [TEIIDDES-2950|https://issues.jboss.org/browse/TEIIDDES-2950]. I had to delete data source from the server and create it again or set another name of the datasource. > I deleted datasource. > When I generated a model from a database via JDBC again (but a server was running) and I checked Auto-create Data Source (screenshot2), preview worked fine. > So I notice that datasource haven't set a password when DS is created before the preview. > I looked to standalone.xml > Datasource which is created before preview: > {code:java} > datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true"> > <connection-url>connection url</connection-url> > <driver>sqljdbc4.jar</driver> > <security> > <user-name>books</user-name> > </security> > </datasource> > {code} > Datasource which is created in the import wizard: > {code:java} > <datasource jndi-name="java:/SQL_Server_2008_Books_DS" pool-name="SQL_Server_2008_Books_DS" enabled="true"> > <connection-url>connection url</connection-url> > <driver>sqljdbc4.jar</driver> > <security> > <user-name>books</user-name> > <password>**</password> > </security> > </datasource> > {code} -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2648) Add option in JDBC importer to set all "updatable" table properties to true/false

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2648?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2648. ---------------------------------- > Add option in JDBC importer to set all "updatable" table properties to true/false > --------------------------------------------------------------------------------- > > Key: TEIIDDES-2648 > URL: https://issues.jboss.org/browse/TEIIDDES-2648 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export, Patch Release > Reporter: Barry LaFond > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > Attachments: jdbc-import-set-updatable-check-box.png > > > Add feature similar to TEIIDDES-2624 in JDBC importer. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2648) Add option in JDBC importer to set all "updatable" table properties to true/false

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2648?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2648: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > Add option in JDBC importer to set all "updatable" table properties to true/false > --------------------------------------------------------------------------------- > > Key: TEIIDDES-2648 > URL: https://issues.jboss.org/browse/TEIIDDES-2648 > Project: Teiid Designer > Issue Type: Enhancement > Components: Import/Export, Patch Release > Reporter: Barry LaFond > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > Attachments: jdbc-import-set-updatable-check-box.png > > > Add feature similar to TEIIDDES-2624 in JDBC importer. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2695) Deployed dynamic VDB not shown in server views

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2695?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2695: ----------------------------------- Labels: verified_jbdsis-9.0.3 (was: ) > Deployed dynamic VDB not shown in server views > ---------------------------------------------- > > Key: TEIIDDES-2695 > URL: https://issues.jboss.org/browse/TEIIDDES-2695 > Project: Teiid Designer > Issue Type: Bug > Components: VDB & Execution > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Labels: verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > > When a dynamic VDB (created from a VDB archive) is deployed on the server, it is not shown in the list of VDBs in the Servers view, only after refreshing the server. Suggesting to show it immediately after deploying, like with regular VDBs. -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Matus Makovy updated TEIIDDES-2481: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.1, 10.0.2 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2481) Add support for recursive common table expressions

by Matus Makovy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2481?page=com.atlassian.jira.plu... ] Matus Makovy closed TEIIDDES-2481. ---------------------------------- > Add support for recursive common table expressions > -------------------------------------------------- > > Key: TEIIDDES-2481 > URL: https://issues.jboss.org/browse/TEIIDDES-2481 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling, Patch Release, Teiid Integration > Reporter: Steven Hawkins > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.1, 10.0.2 > > Attachments: RCTE1-vdb.xml > > > Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause -- This message was sent by Atlassian JIRA (v7.2.2#72004)

8 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2858) DDL Importer does drops quotes from quoted column names

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2858?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2858: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > DDL Importer does drops quotes from quoted column names > ------------------------------------------------------- > > Key: TEIIDDES-2858 > URL: https://issues.jboss.org/browse/TEIIDDES-2858 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview, Dynamic VDBs > Affects Versions: 10.0.1 > Environment: Fedora 23 > Reporter: Matej Kralik > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > Attachments: remoteXML.zip, screenshot1.png, screenshot2.png > > > When I wanted preview date from the table which contains column with specific name, server shows me this error: > TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9. > Was expecting: "constraint" | "foreign" | "primary" | "unique" | id > I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks. > "YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE') > When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2) > A similar situation is when I generated dynamic VDB. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2858) DDL Importer does drops quotes from quoted column names

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2858?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2858. ---------------------------------- > DDL Importer does drops quotes from quoted column names > ------------------------------------------------------- > > Key: TEIIDDES-2858 > URL: https://issues.jboss.org/browse/TEIIDDES-2858 > Project: Teiid Designer > Issue Type: Bug > Components: Data Preview, Dynamic VDBs > Affects Versions: 10.0.1 > Environment: Fedora 23 > Reporter: Matej Kralik > Assignee: Barry LaFond > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > Attachments: remoteXML.zip, screenshot1.png, screenshot2.png > > > When I wanted preview date from the table which contains column with specific name, server shows me this error: > TEIID31100 Parsing error: Encountered "'FALSE'), [*]YEAR[*] string(" at line 8, column 9. > Was expecting: "constraint" | "foreign" | "primary" | "unique" | id > I looked on the DDL which designer generated (screenshot1) and I think that column TIME should be between quotation marks. > "YEAR" string(4000) OPTIONS(NAMEINSOURCE '"YEAR"', UPDATABLE 'FALSE') > When I change column name from TIME to "TIME", the preview passed and showed me data. (screenshot2) > A similar situation is when I generated dynamic VDB. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2876) Clean up wording in Stored Procedure Prompt

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2876?page=com.atlassian.jira.plu... ] Matej Kralik closed TEIIDDES-2876. ---------------------------------- > Clean up wording in Stored Procedure Prompt > ------------------------------------------- > > Key: TEIIDDES-2876 > URL: https://issues.jboss.org/browse/TEIIDDES-2876 > Project: Teiid Designer > Issue Type: Bug > Reporter: Steve Tran > Assignee: Barry LaFond > Priority: Minor > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > Attachments: bug.PNG > > > The wording on the Stored Procedure prompt contains grammatical typos. See screenshot of the issues. These messages are in a shared messages.properties file, so if there are other typos, we should clean those up as well. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2876) Clean up wording in Stored Procedure Prompt

by Matej Kralik (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2876?page=com.atlassian.jira.plu... ] Matej Kralik updated TEIIDDES-2876: ----------------------------------- Labels: release_notes verified_jbdsis-9.0.3 (was: ) > Clean up wording in Stored Procedure Prompt > ------------------------------------------- > > Key: TEIIDDES-2876 > URL: https://issues.jboss.org/browse/TEIIDDES-2876 > Project: Teiid Designer > Issue Type: Bug > Reporter: Steve Tran > Assignee: Barry LaFond > Priority: Minor > Labels: release_notes, verified_jbdsis-9.0.3 > Fix For: 10.0.2 > > Attachments: bug.PNG > > > The wording on the Stored Procedure prompt contains grammatical typos. See screenshot of the issues. These messages are in a shared messages.properties file, so if there are other typos, we should clean those up as well. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 12 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues October 2016