June 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3151) Add Support for SAP HANA Sources

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-3151?page=com.atlassian.jira.plugin... ] Ted Jones resolved TEIID-3151. ------------------------------ Resolution: Done Added HANA translator to 8.11 and 62-8.7.x branches. > Add Support for SAP HANA Sources > -------------------------------- > > Key: TEIID-3151 > URL: https://issues.jboss.org/browse/TEIID-3151 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.8 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.7.1.6_2, 8.11 > > > Need to add support SAP HANA. SAP provides a JDBC and ODBC driver for it. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3151) Add Support for SAP HANA Sources

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-3151?page=com.atlassian.jira.plugin... ] Ted Jones commented on TEIID-3151: ---------------------------------- Back-ported to 62-8.7.x without the Geometry type and spatial functions since they did not exist in 8.7.x. > Add Support for SAP HANA Sources > -------------------------------- > > Key: TEIID-3151 > URL: https://issues.jboss.org/browse/TEIID-3151 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.8 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.7.1.6_2, 8.11 > > > Need to add support SAP HANA. SAP provides a JDBC and ODBC driver for it. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3151) Add Support for SAP HANA Sources

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-3151?page=com.atlassian.jira.plugin... ] Ted Jones updated TEIID-3151: ----------------------------- Git Pull Request: https://github.com/teiid/teiid/pull/467, https://github.com/teiid/teiid/pull/472, https://github.com/teiid/teiid/pull/474, https://github.com/teiid/teiid/pull/479 (was: https://github.com/teiid/teiid/pull/467, https://github.com/teiid/teiid/pull/472, https://github.com/teiid/teiid/pull/474) > Add Support for SAP HANA Sources > -------------------------------- > > Key: TEIID-3151 > URL: https://issues.jboss.org/browse/TEIID-3151 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.8 > Reporter: Ted Jones > Assignee: Ted Jones > Fix For: 8.7.1.6_2, 8.11 > > > Need to add support SAP HANA. SAP provides a JDBC and ODBC driver for it. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3548) Creation of embedded complex not supported by odata production

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3548?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3548: --------------------------------------- Also it's not complete. Key properties cannot be complex and multiple complex properties cannot have the same property names (as the logic that reads the result set is just going by column name and doesn't have the extension metadata), both could be fixed but will keep expanding the change. > Creation of embedded complex not supported by odata production > -------------------------------------------------------------- > > Key: TEIID-3548 > URL: https://issues.jboss.org/browse/TEIID-3548 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.12 > > > Prior to 8.11 we would always produce the flattened version with or without the complex type extension metadata. With TEIID-3543 the extension metadata will cause production to throw an exception. The workaround until this is fixed is to not use the complex type extension metadata. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3538) Make OData V2 compatible with LINQPad

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3538?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-3538. --------------------------------- Labels: Final (was: ) Fix Version/s: 8.7.1.6_2 Resolution: Done - Converted List(Edm.xxx) to Collection(Edm.xxx) - Made sure all key columns are are defined as non-nulls - Moved the OReva version 0.8.7, adding the "@Produces" header to all the relevant API calls, such that request with "Accept" headers like "application/xml" and "application/json" work correctly with RestEasy bug RESTEASY-1175 - Also fixed the invalid EntityType name, in case if the Teiid source's metadata was result of another OData service. - Tested with LINQPad. V2 works correctly. - V4 support is not available in LINQPad or Visual Studio > Make OData V2 compatible with LINQPad > ------------------------------------- > > Key: TEIID-3538 > URL: https://issues.jboss.org/browse/TEIID-3538 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.7.1.6_2, 8.11 > > > Current OData V2 implementation is not able to load in LINQPad https://www.linqpad.net/ > Couple issues found > - List(Edm.xxx) based collections are not supported. V2 Spec did not specify any List based collections. Only Collection(Edm.xxx) type. So, part of TEIID-3471 need to be rolled back and fix with Collection(Edm.xxx) type > - Explicit definition of "not null" in Entity's key property. > - TEIID-3471 did not go far enough to define accepts header to have "application/xml", "application/atom+xml" and "application/json" without "chaset=utf-8" appended to it. TEIID-3471 only added $metadata and service document. BTW, I was under the impression that I did add all the required places, and was surprised not see in commit :( -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3544) teiid-odata-*.war not deploying in EAP when using domain

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3544?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3544: ------------------------------------ No, there's no cli deployment of the war. Looking in the jboss-integration code, it appears its loading the war's defined in the deployments.properties file. > teiid-odata-*.war not deploying in EAP when using domain > -------------------------------------------------------- > > Key: TEIID-3544 > URL: https://issues.jboss.org/browse/TEIID-3544 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7.1.6_2 > Reporter: Van Halbert > Assignee: Ramesh Reddy > Priority: Critical > > The Teiid odata war, located: > modules/system/layers/dv/org/jboss/teiid/main/deployments/teiid-odata-8.7.1.6_2-redhat-2.war > was not being deployed. It's working in standalone. > The workaround in domain mode is to re-deploy the war using the admin console. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3548) Creation of embedded complex not supported by odata production

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3548?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3548: --------------------------------------- I do have the changes for this, but it's not a very simple fix. > Creation of embedded complex not supported by odata production > -------------------------------------------------------------- > > Key: TEIID-3548 > URL: https://issues.jboss.org/browse/TEIID-3548 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.12 > > > Prior to 8.11 we would always produce the flattened version with or without the complex type extension metadata. With TEIID-3543 the extension metadata will cause production to throw an exception. The workaround until this is fixed is to not use the complex type extension metadata. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3538) Make OData V2 compatible with LINQPad

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3538?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3538: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1233383 > Make OData V2 compatible with LINQPad > ------------------------------------- > > Key: TEIID-3538 > URL: https://issues.jboss.org/browse/TEIID-3538 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.11 > > > Current OData V2 implementation is not able to load in LINQPad https://www.linqpad.net/ > Couple issues found > - List(Edm.xxx) based collections are not supported. V2 Spec did not specify any List based collections. Only Collection(Edm.xxx) type. So, part of TEIID-3471 need to be rolled back and fix with Collection(Edm.xxx) type > - Explicit definition of "not null" in Entity's key property. > - TEIID-3471 did not go far enough to define accepts header to have "application/xml", "application/atom+xml" and "application/json" without "chaset=utf-8" appended to it. TEIID-3471 only added $metadata and service document. BTW, I was under the impression that I did add all the required places, and was surprised not see in commit :( -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3490) WITH [TABLENAME] AS clause being sent to source query

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3490?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3490: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1224377, https://bugzilla.redhat.com/show_bug.cgi?id=1233373 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1224377) > WITH [TABLENAME] AS clause being sent to source query > ----------------------------------------------------- > > Key: TEIID-3490 > URL: https://issues.jboss.org/browse/TEIID-3490 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.11 > > > The transformation for that table is: > WITH MONTHEND AS (SELECT CONVERT(SQLBqt.tinya.DateValue, DATE) AS REFERENCE_VALUE FROM SQLBqt.tinya WHERE SQLBqt.tinya.IntKey = 2) > SELECT > RATES.INTKEY, MAX(CASE WHEN RATES.INTKEY = 20 THEN RATES.STRINGKEY END) AS GBP_RATE, MAX(CASE WHEN RATES.INTKEY = 25 THEN RATES.STRINGKEY END) AS EUR_RATE, MAX(CASE WHEN RATES.INTKEY = 30 THEN RATES.STRINGKEY END) AS USD_RATE > FROM > Oraclebqt.dssmalla2 AS RATES > WHERE > (RATES.INTKEY IN (20, 25, 30)) AND (RATES.DATEVALUE = (SELECT MONTHEND.REFERENCE_VALUE FROM MONTHEND)) > GROUP BY RATES.INTKEY > source queries are showing the With clause being pushed down to Oracle and they shouldn't be. > 11:11:54,283 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue30) Vw26e70yOBmw.6.3.2 Processing NEW request: WITH MONTHEND (REFERENCE_VALUE) AS (SELECT CONVERT(g_0.DateValue, DATE) FROM SQLBqt.tinya AS g_0 WHERE g_0.IntKey = 2) SELECT g_0.INTKEY, MAX(CASE WHEN g_0.INTKEY = 20 THEN g_0.STRINGKEY END), MAX(CASE WHEN g_0.INTKEY = 25 THEN g_0.STRINGKEY END), MAX(CASE WHEN g_0.INTKEY = 30 THEN g_0.STRINGKEY END) FROM Oraclebqt.DSSMALLA2 AS g_0 WHERE (g_0.INTKEY IN (20, 25, 30)) AND (g_0.DATEVALUE = {d'2000-01-03'}) GROUP BY g_0.INTKEY > 11:11:54,283 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (Worker3_QueryProcessorQueue30) Oraclebqt: getConnection(null, WrappedConnectionRequestInfo@2efc4e0e[userName=bqt2]) [0/20] > 11:11:54,283 INFO [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue30) OracleExecutionFactory Commit=true;DatabaseProductName=Oracle;DatabaseProductVersion=Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production > With the Partitioning, OLAP, Data Mining and Real Application Testing options;DriverMajorVersion=11;DriverMajorVersion=2;DriverName=Oracle JDBC driver;DriverVersion=11.2.0.1.0;IsolationLevel=2 > 11:11:54,283 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue30) Vw26e70yOBmw.6.3.2 Obtained execution > 11:11:54,283 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue30) START DATA SRC COMMAND: startTime=2015-05-22 11:11:54.283 requestID=Vw26e70yOBmw.6 sourceCommandID=3 executionID=2 txID=null modelName=Oraclebqt translatorName=oracle sessionID=Vw26e70yOBmw principal=teiiduser@teiid-security sql=WITH MONTHEND (REFERENCE_VALUE) AS (SELECT CONVERT(g_0.DateValue, DATE) FROM SQLBqt.tinya AS g_0 WHERE g_0.IntKey = 2) SELECT g_0.INTKEY, MAX(CASE WHEN g_0.INTKEY = 20 THEN g_0.STRINGKEY END), MAX(CASE WHEN g_0.INTKEY = 25 THEN g_0.STRINGKEY END), MAX(CASE WHEN g_0.INTKEY = 30 THEN g_0.STRINGKEY END) FROM Oraclebqt.DSSMALLA2 AS g_0 WHERE (g_0.INTKEY IN (20, 25, 30)) AND (g_0.DATEVALUE = {d'2000-01-03'}) GROUP BY g_0.INTKEY > 11:11:54,285 DEBUG [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue30) Source-specific command: WITH MONTHEND AS (SELECT trunc(cast(g_0."DateValue" AS date)) AS REFERENCE_VALUE FROM "bqt2"."dbo"."tinya" g_0 WHERE g_0."IntKey" = 2) SELECT g_0."INTKEY", MAX(CASE WHEN g_0."INTKEY" = 20 THEN g_0."STRINGKEY" END), MAX(CASE WHEN g_0."INTKEY" = 25 THEN g_0."STRINGKEY" END), MAX(CASE WHEN g_0."INTKEY" = 30 THEN g_0."STRINGKEY" END) FROM "BQT2"."DSSMALLA2" g_0 WHERE g_0."INTKEY" IN (20, 25, 30) AND g_0."DATEVALUE" = {d '2000-01-03'} GROUP BY g_0."INTKEY" > 11:11:54,285 TRACE [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue30) Source sql WITH MONTHEND AS (SELECT trunc(cast(g_0."DateValue" AS date)) AS REFERENCE_VALUE FROM "bqt2"."dbo"."tinya" g_0 WHERE g_0."IntKey" = 2) SELECT g_0."INTKEY", MAX(CASE WHEN g_0."INTKEY" = 20 THEN g_0."STRINGKEY" END), MAX(CASE WHEN g_0."INTKEY" = 25 THEN g_0."STRINGKEY" END), MAX(CASE WHEN g_0."INTKEY" = 30 THEN g_0."STRINGKEY" END) FROM "BQT2"."DSSMALLA2" g_0 WHERE g_0."INTKEY" IN (20, 25, 30) AND g_0."DATEVALUE" = {d '2000-01-03'} GROUP BY g_0."INTKEY" > 11:11:55,514 DEBUG [org.teiid.COMMAND_LOG] (Worker3_QueryProcessorQueue30) ERROR SRC COMMAND: endTime=2015-05-22 11:11:55.514 requestID=Vw26e70yOBmw.6 sourceCommandID=3 executionID=2 txID=null modelName=Oraclebqt translatorName=oracle sessionID=Vw26e70yOBmw principal=teiiduser@teiid-security finalRowCount=null > 11:11:55,514 WARN [org.teiid.CONNECTOR] (Worker3_QueryProcessorQueue30) Connector worker process failed for atomic-request=Vw26e70yOBmw.6.3.2: org.teiid.translator.jdbc.JDBCExecutionException: 907 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: WITH MONTHEND AS (SELECT trunc(cast(g_0."DateValue" AS date)) AS REFERENCE_VALUE FROM "bqt2"."dbo"."tinya" g_0 WHERE g_0."IntKey" = 2) SELECT g_0."INTKEY", MAX(CASE WHEN g_0."INTKEY" = 20 THEN g_0."STRINGKEY" END), MAX(CASE WHEN g_0."INTKEY" = 25 THEN g_0."STRINGKEY" END), MAX(CASE WHEN g_0."INTKEY" = 30 THEN g_0."STRINGKEY" END) FROM "BQT2"."DSSMALLA2" g_0 WHERE g_0."INTKEY" IN (20, 25, 30) AND g_0."DATEVALUE" = {d '2000-01-03'} GROUP BY g_0."INTKEY"] -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3548) Creation of embedded complex not supported by odata production

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3548?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-3548: ----------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > Creation of embedded complex not supported by odata production > -------------------------------------------------------------- > > Key: TEIID-3548 > URL: https://issues.jboss.org/browse/TEIID-3548 > Project: Teiid > Issue Type: Bug > Components: OData > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 8.12 > > > Prior to 8.11 we would always produce the flattened version with or without the complex type extension metadata. With TEIID-3543 the extension metadata will cause production to throw an exception. The workaround until this is fixed is to not use the complex type extension metadata. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2015