January 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2800) Teiid Login Issue with special characters

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2800?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2800: --------------------------------------- >So after this change, we should set the user/password parameters directly on teiidDataSource Before this change if you set a property on TeiidDataSource that needs url encoding, it will need to be encoded form. After this change properties such as user/password on the TeiidDataSource will not need to be encoded. > If the user password is passed to getConnection() it will not be encoded. Am I correct? Before this change user/password on getConnection(user, password) are ignored. After this change, they will be used and do not need to be encoded. > Teiid Login Issue with special characters > ----------------------------------------- > > Key: TEIID-2800 > URL: https://issues.jboss.org/browse/TEIID-2800 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.1 > Environment: Mainframe Jboss 7.1.1 > Reporter: Gautam Banerjee > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.7 > > > When we try to login to teiid programmatically through datasource, we are having problem with username having special characters. > We are encoding the special character as per url encoding > eg : username %xyz is encoded as %25xyz but teiid does not decode the special character while passing username. So the username passed by teiid is %25xyz which fails authentication as the actual username is %xyz -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2800) Teiid Login Issue with special characters

by Gautam Banerjee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2800?page=com.atlassian.jira.plugin... ] Gautam Banerjee edited comment on TEIID-2800 at 1/16/14 1:52 AM: ----------------------------------------------------------------- So after this change, we should set the user/password parameters directly on teiidDataSource. If the user password is passed to getConnection() it will not be encoded. Am I correct? was (Author: gtmbanerjee): So after this change, we should set the user/password parameters directly on teiidDataSource. If the user password is not passed to getConnection() it will not be encoded. Am I correct? > Teiid Login Issue with special characters > ----------------------------------------- > > Key: TEIID-2800 > URL: https://issues.jboss.org/browse/TEIID-2800 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.1 > Environment: Mainframe Jboss 7.1.1 > Reporter: Gautam Banerjee > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.7 > > > When we try to login to teiid programmatically through datasource, we are having problem with username having special characters. > We are encoding the special character as per url encoding > eg : username %xyz is encoded as %25xyz but teiid does not decode the special character while passing username. So the username passed by teiid is %25xyz which fails authentication as the actual username is %xyz -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2800) Teiid Login Issue with special characters

by Gautam Banerjee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2800?page=com.atlassian.jira.plugin... ] Gautam Banerjee commented on TEIID-2800: ---------------------------------------- So after this change, we should set the user/password parameters directly on teiidDataSource. If the user password is not passed to getConnection() it will not be encoded. Am I correct? > Teiid Login Issue with special characters > ----------------------------------------- > > Key: TEIID-2800 > URL: https://issues.jboss.org/browse/TEIID-2800 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.1 > Environment: Mainframe Jboss 7.1.1 > Reporter: Gautam Banerjee > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.7 > > > When we try to login to teiid programmatically through datasource, we are having problem with username having special characters. > We are encoding the special character as per url encoding > eg : username %xyz is encoded as %25xyz but teiid does not decode the special character while passing username. So the username passed by teiid is %25xyz which fails authentication as the actual username is %xyz -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2788) Create maven archtype for translator development

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2788?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-2788: ------------------------------- Git Pull Request: https://github.com/teiid/teiid/pull/177 Created the first (translator) of 2 arche types (translator and connector) > Create maven archtype for translator development > ------------------------------------------------ > > Key: TEIID-2788 > URL: https://issues.jboss.org/browse/TEIID-2788 > Project: Teiid > Issue Type: Feature Request > Components: Tools > Affects Versions: 8.7 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Optional > > Create a maven archtype project for creating translator projects. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2761) Enable/disable transport per model/view/virtual procedure

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2761?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2761: ---------------------------------- Fix Version/s: 8.7 > Enable/disable transport per model/view/virtual procedure > --------------------------------------------------------- > > Key: TEIID-2761 > URL: https://issues.jboss.org/browse/TEIID-2761 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 8.5 > Reporter: Patrick Deenen > Assignee: Steven Hawkins > Fix For: 8.7 > > > It would be nice to be able to enable and disable access to models, tables, views or (virtual) procedures for a specific transport (JDBC, ODBC, OData, REST, Web services). > One may want to have access to virtual procedures only by Odata for example. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2802) HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2802?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2802: --------------------------------------- So more than likely this would happen even without the union as it seems like the presence of the grouping requires the order by to use the output names from the select clause. Can you confirm if the direct to Hive (not through Teiid) query: SELECT v_0.c_0 FROM (SELECT c_0 FROM (SELECT g_1.name AS c_0 FROM opportunities_small g_1 UNION ALL SELECT g_0.name AS c_0 FROM opportunities g_0) X__) v_0 GROUP BY v_0.c_0 ORDER BY c_0 works as expected. > HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2 > ----------------------------------------------------------------------------------------- > > Key: TEIID-2802 > URL: https://issues.jboss.org/browse/TEIID-2802 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: TEIID with HIVE2 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Labels: teiid > > If I tried to combine 2 tables from a same HIVE2 data source using UNION ALL, I got "Invalid table alias or column reference" error. > Query that I submitted to Teiid originally: > select "name" > from (Select * from hive2.opportunities_small UNION ALL Select * from > hive2.opportunities) "query" > group by "name" > order by "name" > Query that Teiid generated: > SELECT v_0.c_0 FROM (SELECT c_0 FROM (SELECT g_1.name AS c_0 FROM > opportunities_small g_1 UNION ALL SELECT g_0.name AS c_0 FROM opportunities > g_0) X__) v_0 GROUP BY v_0.c_0 ORDER BY v_0.c_0 > Error: > Invalid table alias or column reference 'v_0': (possible column names are: c_0) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2802) HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2

by Ivan Chan (JIRA)

[ https://issues.jboss.org/browse/TEIID-2802?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-2802: ---------------------------------- It works with only order by or group by, but not order by and group by together. It is ok to run the following queries: select "name" from (Select * from hive2.opportunities_small UNION ALL Select * from hive2.opportunities) "query" group by "name" select "name" from (Select * from hive2.opportunities_small UNION ALL Select * from hive2.opportunities) "query" order by "name" but not this one: select "name" from (Select * from hive2.opportunities_small UNION ALL Select * from hive2.opportunities) "query" group by "name" order by "name" > HIVE2: got Invalid table alias or column reference when running UNION ALL query on HIVE2 > ----------------------------------------------------------------------------------------- > > Key: TEIID-2802 > URL: https://issues.jboss.org/browse/TEIID-2802 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.6 > Environment: TEIID with HIVE2 > Reporter: Ivan Chan > Assignee: Steven Hawkins > Labels: teiid > > If I tried to combine 2 tables from a same HIVE2 data source using UNION ALL, I got "Invalid table alias or column reference" error. > Query that I submitted to Teiid originally: > select "name" > from (Select * from hive2.opportunities_small UNION ALL Select * from > hive2.opportunities) "query" > group by "name" > order by "name" > Query that Teiid generated: > SELECT v_0.c_0 FROM (SELECT c_0 FROM (SELECT g_1.name AS c_0 FROM > opportunities_small g_1 UNION ALL SELECT g_0.name AS c_0 FROM opportunities > g_0) X__) v_0 GROUP BY v_0.c_0 ORDER BY v_0.c_0 > Error: > Invalid table alias or column reference 'v_0': (possible column names are: c_0) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2800) Teiid Login Issue with special characters

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2800?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2800. ----------------------------------- Resolution: Done Changed the TeiidDataSource logic to pass properties directly rather than reparsing them to avoid going through another encode/decode loop. Also ensured that the user/password are utilized from getConnection. As for a workaround, there isn't a good one for getConnection - the old logic will ignore the parameters. If the user/password as set as properties without this change they, then they need url encoding. > Teiid Login Issue with special characters > ----------------------------------------- > > Key: TEIID-2800 > URL: https://issues.jboss.org/browse/TEIID-2800 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.1 > Environment: Mainframe Jboss 7.1.1 > Reporter: Gautam Banerjee > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.7 > > > When we try to login to teiid programmatically through datasource, we are having problem with username having special characters. > We are encoding the special character as per url encoding > eg : username %xyz is encoded as %25xyz but teiid does not decode the special character while passing username. So the username passed by teiid is %25xyz which fails authentication as the actual username is %xyz -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2800) Teiid Login Issue with special characters

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2800?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2800: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1053792 > Teiid Login Issue with special characters > ----------------------------------------- > > Key: TEIID-2800 > URL: https://issues.jboss.org/browse/TEIID-2800 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.1 > Environment: Mainframe Jboss 7.1.1 > Reporter: Gautam Banerjee > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.7 > > > When we try to login to teiid programmatically through datasource, we are having problem with username having special characters. > We are encoding the special character as per url encoding > eg : username %xyz is encoded as %25xyz but teiid does not decode the special character while passing username. So the username passed by teiid is %25xyz which fails authentication as the actual username is %xyz -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 12 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2800) Teiid Login Issue with special characters

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2800?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2800: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1053792|https://bugzilla.redhat.com/show_bug.cgi?id=1053792] from NEW to ASSIGNED > Teiid Login Issue with special characters > ----------------------------------------- > > Key: TEIID-2800 > URL: https://issues.jboss.org/browse/TEIID-2800 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 8.1 > Environment: Mainframe Jboss 7.1.1 > Reporter: Gautam Banerjee > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.7 > > > When we try to login to teiid programmatically through datasource, we are having problem with username having special characters. > We are encoding the special character as per url encoding > eg : username %xyz is encoded as %25xyz but teiid does not decode the special character while passing username. So the username passed by teiid is %25xyz which fails authentication as the actual username is %xyz -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 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-issues January 2014