August 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-3615: ------------------------------- Description: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: * /portfoliorest_1/rest/foo * /portfoliorest_1/rest/getAllStocks * /portfoliorest_1/rest/getAllStockById/{id} * /portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ was: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: * /portfoliorest_1/rest/foo/{id} * /portfoliorest_1/rest/getAllStocks * /portfoliorest_1/rest/getAllStockById/{id} * /portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ > Add a api-docs page with Swagger-UI in REST Service Through VDB > --------------------------------------------------------------- > > Key: TEIID-3615 > URL: https://issues.jboss.org/browse/TEIID-3615 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12 > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.0 > > > With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: > * foo > * getAllStocks > * getAllStockById > * getAllStockBySymbol > Correspondingly, there are 4 api: > * /portfoliorest_1/rest/foo > * /portfoliorest_1/rest/getAllStocks > * /portfoliorest_1/rest/getAllStockById/{id} > * /portfoliorest_1/rest/getAllStockBySymbol/{symbol} > With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. > [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB > [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... > [3] http://petstore.swagger.io/ -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-3615: ------------------------------- Description: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: * /portfoliorest_1/rest/foo/{id} * /portfoliorest_1/rest/getAllStocks * /portfoliorest_1/rest/getAllStockById/{id} * /portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ was: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: /portfoliorest_1/rest/foo/{id} /portfoliorest_1/rest/getAllStocks /portfoliorest_1/rest/getAllStockById/{id} /portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ > Add a api-docs page with Swagger-UI in REST Service Through VDB > --------------------------------------------------------------- > > Key: TEIID-3615 > URL: https://issues.jboss.org/browse/TEIID-3615 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12 > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.0 > > > With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: > * foo > * getAllStocks > * getAllStockById > * getAllStockBySymbol > Correspondingly, there are 4 api: > * /portfoliorest_1/rest/foo/{id} > * /portfoliorest_1/rest/getAllStocks > * /portfoliorest_1/rest/getAllStockById/{id} > * /portfoliorest_1/rest/getAllStockBySymbol/{symbol} > With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. > [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB > [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... > [3] http://petstore.swagger.io/ -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-3615: ------------------------------- Description: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: /portfoliorest_1/rest/foo/{id} /portfoliorest_1/rest/getAllStocks /portfoliorest_1/rest/getAllStockById/{id} /portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ was: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: ~~~ http://{host}:8080/portfoliorest_1/rest/foo/{id} http://{host}:8080/portfoliorest_1/rest/getAllStocks http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} ~~~ With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ > Add a api-docs page with Swagger-UI in REST Service Through VDB > --------------------------------------------------------------- > > Key: TEIID-3615 > URL: https://issues.jboss.org/browse/TEIID-3615 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12 > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.0 > > > With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: > * foo > * getAllStocks > * getAllStockById > * getAllStockBySymbol > Correspondingly, there are 4 api: > /portfoliorest_1/rest/foo/{id} > /portfoliorest_1/rest/getAllStocks > /portfoliorest_1/rest/getAllStockById/{id} > /portfoliorest_1/rest/getAllStockBySymbol/{symbol} > With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. > [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB > [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... > [3] http://petstore.swagger.io/ -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-3615: ------------------------------- Description: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: ~~~ http://{host}:8080/portfoliorest_1/rest/foo/{id} http://{host}:8080/portfoliorest_1/rest/getAllStocks http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} ~~~ With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ was: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: http://{host}:8080/portfoliorest_1/rest/foo/{id} http://{host}:8080/portfoliorest_1/rest/getAllStocks http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ > Add a api-docs page with Swagger-UI in REST Service Through VDB > --------------------------------------------------------------- > > Key: TEIID-3615 > URL: https://issues.jboss.org/browse/TEIID-3615 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12 > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.0 > > > With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: > * foo > * getAllStocks > * getAllStockById > * getAllStockBySymbol > Correspondingly, there are 4 api: > ~~~ > http://{host}:8080/portfoliorest_1/rest/foo/{id} > http://{host}:8080/portfoliorest_1/rest/getAllStocks > http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} > http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} > ~~~ > With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. > [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB > [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... > [3] http://petstore.swagger.io/ -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-3615: ------------------------------- Description: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: http://{host}:8080/portfoliorest_1/rest/foo/{id} http://{host}:8080/portfoliorest_1/rest/getAllStocks http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ was: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: * http://{host}:8080/portfoliorest_1/rest/foo/{id} * http://{host}:8080/portfoliorest_1/rest/getAllStocks * http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} * http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ > Add a api-docs page with Swagger-UI in REST Service Through VDB > --------------------------------------------------------------- > > Key: TEIID-3615 > URL: https://issues.jboss.org/browse/TEIID-3615 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12 > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.0 > > > With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: > * foo > * getAllStocks > * getAllStockById > * getAllStockBySymbol > Correspondingly, there are 4 api: > http://{host}:8080/portfoliorest_1/rest/foo/{id} > http://{host}:8080/portfoliorest_1/rest/getAllStocks > http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} > http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} > With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. > [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB > [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... > [3] http://petstore.swagger.io/ -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB

by Kylin Soong (JIRA)

[ https://issues.jboss.org/browse/TEIID-3615?page=com.atlassian.jira.plugin... ] Kylin Soong updated TEIID-3615: ------------------------------- Description: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: * http://{host}:8080/portfoliorest_1/rest/foo/{id} * http://{host}:8080/portfoliorest_1/rest/getAllStocks * http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} * http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ was: With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: * http://{host}:8080/portfoliorest_1/rest/foo/{id} * http://{host}:8080/portfoliorest_1/rest/getAllStocks * http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} * http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ > Add a api-docs page with Swagger-UI in REST Service Through VDB > --------------------------------------------------------------- > > Key: TEIID-3615 > URL: https://issues.jboss.org/browse/TEIID-3615 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.12 > Reporter: Kylin Soong > Assignee: Kylin Soong > Fix For: 9.0 > > > With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: > * foo > * getAllStocks > * getAllStockById > * getAllStockBySymbol > Correspondingly, there are 4 api: > * http://{host}:8080/portfoliorest_1/rest/foo/{id} > * http://{host}:8080/portfoliorest_1/rest/getAllStocks > * http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} > * http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} > With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. > [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB > [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... > [3] http://petstore.swagger.io/ -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3615) Add a api-docs page with Swagger-UI in REST Service Through VDB

by Kylin Soong (JIRA)

Kylin Soong created TEIID-3615: ---------------------------------- Summary: Add a api-docs page with Swagger-UI in REST Service Through VDB Key: TEIID-3615 URL: https://issues.jboss.org/browse/TEIID-3615 Project: Teiid Issue Type: Feature Request Affects Versions: 8.12 Reporter: Kylin Soong Assignee: Kylin Soong Fix For: 9.0 With document [1], we can use REST API to access the data in VDB, for example, there are 4 procedures defined in PortfolioRest VDB as [2] under 'Rest' Model: * foo * getAllStocks * getAllStockById * getAllStockBySymbol Correspondingly, there are 4 api: * http://{host}:8080/portfoliorest_1/rest/foo/{id} * http://{host}:8080/portfoliorest_1/rest/getAllStocks * http://{host}:8080/portfoliorest_1/rest/getAllStockById/{id} * http://{host}:8080/portfoliorest_1/rest/getAllStockBySymbol/{symbol} With Swagger UI, it's easy to add a api-doc page for all api, [3] is a example. [1] https://docs.jboss.org/author/display/TEIID/REST+Service+Through+VDB [2] https://raw.githubusercontent.com/kylinsoong/teiid-quickstarts/master/dyn... [3] http://petstore.swagger.io/ -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 7 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 commented on TEIID-3490: ------------------------------------------------ Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug 1224377|https://bugzilla.redhat.com/show_bug.cgi?id=1224377] from ON_QA to ASSIGNED > 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, 8.7.4 > > > 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, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3614) Develop a node.js module that works with the Postgres protocol

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3614?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3614: ------------------------------------ That looks like what's needed. I think the original request was made so that if there was something needed or that could be created (that was generic) could be included with Teiid and made the integration effort easier. But it looks to be use-case dependent on how that logic is to be implemented. Which would indicate, there's nothing for Teiid to do in this case. Am I wrong? > Develop a node.js module that works with the Postgres protocol > -------------------------------------------------------------- > > Key: TEIID-3614 > URL: https://issues.jboss.org/browse/TEIID-3614 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.11.2 > Reporter: Van Halbert > Assignee: Ted Jones > > Develop a node.js module that works with the Postgres protocol. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3614) Develop a node.js module that works with the Postgres protocol

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3614?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3614: ------------------------------------- How is different from this http://teiid.blogspot.com/2013/02/access-teiid-from-nodejs.html > Develop a node.js module that works with the Postgres protocol > -------------------------------------------------------------- > > Key: TEIID-3614 > URL: https://issues.jboss.org/browse/TEIID-3614 > Project: Teiid > Issue Type: Feature Request > Affects Versions: 8.11.2 > Reporter: Van Halbert > Assignee: Ted Jones > > Develop a node.js module that works with the Postgres protocol. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 8 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 August 2015