July 2014 - teiid-designer-issues

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

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2232: ---------------------------------------- The Oracle Thin driver UI contribution to Eclipse Data Tools provides hooks to edit contents of the URL, but constructs the actual URL via a pre-defined template: *jdbc:oracle:thin:@server:1521:db* So a URL like *jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename* is not possible since *scott/tiger@//myhost* would be prefixed with an extra *@* character and the */* after the port number *1521* would be by default the colon *:* This URL, however, suffices for Data Tools and their jdbc connections work for this format. > 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 > Security Level: Public(Everyone can see) > 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.2.6#6264)

11 years, 3 months

1
0
0 / 0

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

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-2232: ---------------------------------------- you should be able to define a new connection structure using the service name in Connection Profile framework, then afterwards when you select that profile it will have the correct URL template > 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 > Security Level: Public(Everyone can see) > 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.2.6#6264)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2234) Unable to set numeric bounds to values greater than 999999

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2234?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2234: ---------------------------------------- org.teiid.designer.xsd.ui.editor.FacetHelper hard-codes the max limit: public static final int DEFAULT_MAX_BOUNDS = 999999; public static final int DEFAULT_MIN_BOUNDS = -DEFAULT_MAX_BOUNDS; Not sure what our limit should be... suggestions? > Unable to set numeric bounds to values greater than 999999 > ---------------------------------------------------------- > > Key: TEIIDDES-2234 > URL: https://issues.jboss.org/browse/TEIIDDES-2234 > Project: Teiid Designer > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Modeling > Affects Versions: 8.3.3 > Environment: JBoss Developer Studio 7 on Mac OS X Mavericks > Reporter: Sean Haynes > > Creating a XSD Simple Type Model in the TEIID editor. Numeric values (tried integer, decimal, and float types) do not allow bounds to be set greater 999,999. If the XSD is edited manually, the designer will revert the value back to 999,999 if you click on the type that has manually edited value. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2152) Adding source table with quoted name results in wrong generated SQL statement

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2152?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2152: ---------------------------------------- We've relaxed the name validation in Designer to allow '.' delimiter, so the need to d-quote these names has gone away. However, if a user does d-quote a name with '.' delimiter, there are issues with the v8.Teiid8ParserTokenManager, v8.Teiid8Parser classes. 1) Creating a table with name "aaa.bbb" and add as source table, the generated SQL == SELECT * FROM MyModel."""aaa"."bbb""" - Should generate SELECT * FROM MyModel."aaa.bbb" 2) Creating a table with name "aaa.bbb.ccc" and add as source table, the generated SQL == SELECT * FROM MyModel."""aaa".bbb."ccc""" - Should generate SELECT * FROM MyModel."aaa.bbb.ccc" 3) Creating a table with name "aaa.bbb.ccc.ddd" and add as source table, the generated SQL == SELECT * FROM MyModel."""aaa".bbb.ccc."ddd""" - Should generate SELECT * FROM MyModel."aaa.bbb.ccc.ddd" The parser/resolver framework should not add all of the extra d-quotes > Adding source table with quoted name results in wrong generated SQL statement > ----------------------------------------------------------------------------- > > Key: TEIIDDES-2152 > URL: https://issues.jboss.org/browse/TEIIDDES-2152 > Project: Teiid Designer > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Transformations > Affects Versions: 8.5 > Reporter: Barry LaFond > Assignee: Paul Richardson > Fix For: 8.3.4, 8.6, 8.5.1 > > > 1) Created source model with simple table named "My.Quoted.Table" (including quotes > 2) Created simple virtual table and pasted: SELECT * FROM "My.Quoted.Table" > 3) Parser returned a command resulting in the SQL: SELECT * FROM My.Quoted."Table" > Parser should be able to handle quoted names properly. In this case the SQL should have been valid as is. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2234) Unable to set numeric bounds to values greater than 999999

by Sean Haynes (JIRA)

Sean Haynes created TEIIDDES-2234: ------------------------------------- Summary: Unable to set numeric bounds to values greater than 999999 Key: TEIIDDES-2234 URL: https://issues.jboss.org/browse/TEIIDDES-2234 Project: Teiid Designer Issue Type: Bug Security Level: Public (Everyone can see) Components: Modeling Affects Versions: 8.3.3 Environment: JBoss Developer Studio 7 on Mac OS X Mavericks Reporter: Sean Haynes Creating a XSD Simple Type Model in the TEIID editor. Numeric values (tried integer, decimal, and float types) do not allow bounds to be set greater 999,999. If the XSD is edited manually, the designer will revert the value back to 999,999 if you click on the type that has manually edited value. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 3 months

1
0
0 / 0

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

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ] Tom Johnston commented on TEIIDDES-2232: ---------------------------------------- Really no error just that you cannot successfully build a usable url as it always inserts the colon. > 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 > Security Level: Public(Everyone can see) > 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.2.6#6264)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2136) File Source (XML) importer reverses Root patch when typed (Windows)

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2136?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-2136: --------------------------------------------------- asmigala(a)redhat.com changed the Status of [bug 1094844|https://bugzilla.redhat.com/show_bug.cgi?id=1094844] from ON_QA to VERIFIED > File Source (XML) importer reverses Root patch when typed (Windows) > -------------------------------------------------------------------- > > Key: TEIIDDES-2136 > URL: https://issues.jboss.org/browse/TEIIDDES-2136 > Project: Teiid Designer > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Import/Export > Affects Versions: 8.3.1 > Environment: JBDS 7.1.1 with Teiid Designer 8.3.2.Final-v20140409-1638 installed on Windows > Reporter: Debbie Steigner > Assignee: Mark Drilling > Fix For: 8.5, 8.3.3 > > > On the File Source(XML)>>Source and View Model Importer. On the XML Data Import Options screen, if you try to type in the Root path, cursor returns to the beginning of the field after ever character, so it's entered in reverse. > Same as in the table and view names in: > https://issues.jboss.org/browse/TEIIDDES-1484 > https://issues.jboss.org/browse/TEIIDDES-1421 -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2233) records lost when query by hiernate

by Lai Chao (JIRA)

Lai Chao created TEIIDDES-2233: ---------------------------------- Summary: records lost when query by hiernate Key: TEIIDDES-2233 URL: https://issues.jboss.org/browse/TEIIDDES-2233 Project: Teiid Designer Issue Type: Feature Request Security Level: Public (Everyone can see) Components: VDB & Execution Affects Versions: 7.3 Environment: window7,eclipse Helios Service Release 2, Teiid v7.3.0 Reporter: Lai Chao Priority: Minor Recently, I get an issue when retrieve data from vdb that some records lost in the list. Fox example, from source table we can get 12100 records, but from vdb query(projects with hibernate) can only get 10800+ records. Meanwhile, there's a set on maxSetSize = 1000, is there any affects? Please advise. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-1901) Teiid Connection Importer is using the pool-name instead of jndi name

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-1901?page=com.atlassian.jira.plu... ] RH Bugzilla Integration commented on TEIIDDES-1901: --------------------------------------------------- Andrej Podhradsky <apodhrad(a)redhat.com> changed the Status of [bug 1023216|https://bugzilla.redhat.com/show_bug.cgi?id=1023216] from ON_QA to VERIFIED > Teiid Connection Importer is using the pool-name instead of jndi name > --------------------------------------------------------------------- > > Key: TEIIDDES-1901 > URL: https://issues.jboss.org/browse/TEIIDDES-1901 > Project: Teiid Designer > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Import/Export > Affects Versions: 8.2 > Reporter: Ramesh Reddy > Assignee: Barry LaFond > Fix For: 8.3, 8.3.3 > > > When using the "Teiid Connection" importer the data sources are identified with "pool-name" rather than the "jndi" name. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 3 months

1
0
0 / 0

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

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2232?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-2232: ---------------------------------------- I know we did this before, what is the error? > 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 > Security Level: Public(Everyone can see) > 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.2.6#6264)

11 years, 3 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 July 2014