August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4323) Add support for first/last/absolute/relative "FETCH " syntax

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4323?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4323: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1353928|https://bugzilla.redhat.com/show_bug.cgi?id=1353928] from VERIFIED to CLOSED > Add support for first/last/absolute/relative "FETCH " syntax > ------------------------------------------------------------ > > Key: TEIID-4323 > URL: https://issues.jboss.org/browse/TEIID-4323 > Project: Teiid > Issue Type: Feature Request > Components: ODBC > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.1, 8.7.8.6_2, 8.12.6.6_3 > > > Add Support for the below FETCH syntax: > FETCH LAST FROM cursor_name > FETCH ABSOLUTE fetch_when FROM cursor_name > FETCH RELATIVE fetch_when FROM cursor_name > FETCH FIRST FROM cursor_name -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4258) Cannot connect to Teiid if server runs on JVM 1.6

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4258?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4258: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1343956|https://bugzilla.redhat.com/show_bug.cgi?id=1343956] from VERIFIED to CLOSED > Cannot connect to Teiid if server runs on JVM 1.6 > ------------------------------------------------- > > Key: TEIID-4258 > URL: https://issues.jboss.org/browse/TEIID-4258 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.5 > Environment: JVM 1.6 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.12.5 > > > If Teiid runs on JVM 1.6. connection fails with EOFException \[1\] > \[1\] Exception thrown (used squirrel client) > {code:plain} > java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at java.util.concurrent.FutureTask.report(FutureTask.java:122) > at java.util.concurrent.FutureTask.get(FutureTask.java:206) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:744) > Caused by: java.lang.RuntimeException: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104) > ... 5 more > Caused by: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) > at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66) > at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107) > at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55) > at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133) > at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167) > ... 7 more > Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: TEIID20020 Error establishing socket to host and port: localhost:31000. Reason: null > at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:161) > at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95) > at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316) > at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64) > ... 11 more > Caused by: java.io.EOFException > at java.io.DataInputStream.readInt(DataInputStream.java:392) > at org.teiid.netty.handler.codec.serialization.ObjectDecoderInputStream.readObjectOverride(ObjectDecoderInputStream.java:97) > at java.io.ObjectInputStream.readObject(ObjectInputStream.java:365) > at org.teiid.net.socket.OioOjbectChannelFactory$OioObjectChannel.read(OioOjbectChannelFactory.java:117) > at org.teiid.net.socket.SocketServerInstanceImpl.doHandshake(SocketServerInstanceImpl.java:128) > at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:96) > at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:277) > at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:239) > at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125) > ... 14 more > {code} > I have tried several combinations: > |client|server|result| > |JVM 1.6| JVM 1.6|fail| > |JVM 1.8| JVM 1.6|fail| > |JVM 1.6| JVM 1.8|OK| -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4044) OData ignores entities with empty list of related entities if $filter is applied to expanded entities

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4044?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4044: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1316476|https://bugzilla.redhat.com/show_bug.cgi?id=1316476] from VERIFIED to CLOSED > OData ignores entities with empty list of related entities if $filter is applied to expanded entities > ----------------------------------------------------------------------------------------------------- > > Key: TEIID-4044 > URL: https://issues.jboss.org/browse/TEIID-4044 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > If user want to apply filter for related entities, OData service should return all entities, not only those with non-empty collection of related entities. > *Example:* > *URL:* http://localhost:8080/odata4/olingo_basic/Source/Customers/?$expand=Order... > *Result:* OData returns only 2 customers (both have at least one order with place "town") > *Expectation:* OData should return all 4 customers (two of them should have empty list of orders) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4103) OData - wrong string indexing in string functions indexof and substring

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4103?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4103: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1320535|https://bugzilla.redhat.com/show_bug.cgi?id=1320535] from VERIFIED to CLOSED > OData - wrong string indexing in string functions indexof and substring > ------------------------------------------------------------------------ > > Key: TEIID-4103 > URL: https://issues.jboss.org/browse/TEIID-4103 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: Alpha3 > Fix For: 9.0, 8.12.5 > > > By documentation \[1\] function indexof returns the zero-based character position of the first occurrence of the second parameter value in the first parameter value. > Function substring doens't have explicitly specified indexing, but based on _Example 60_ \[2\] is function substring _zero-based_ too. > *indexof* > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Customers/?$filter=i...,'lfreds') eq 1 > *Result:* Customer with CompanyName equals "Alfreds Futterkiste" > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter...,'alue') eq 1 > *Result:* No entities > *Expected result:* Entity with intkey 1,2,3,4,8,9,10,11,12 > *substring* > Reference service which supports OData V4: > *URL:* http://services.odata.org/V4/Northwind/Northwind.svc/Customers/?$filter=i...,'lfreds') eq 1 > *Result:* Customer with CompanyName equals "Alfreds Futterkiste" > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter..., 1) eq 'alue_asdf' > *Result:* No entities > *Expected result:* Entity with intkey 10 > \[1\] https://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-u... > \[2\] https://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-u... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4039) Resolving of entityid with additional system options fail

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4039?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4039: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1316469|https://bugzilla.redhat.com/show_bug.cgi?id=1316469] from VERIFIED to CLOSED > Resolving of entityid with additional system options fail > --------------------------------------------------------- > > Key: TEIID-4039 > URL: https://issues.jboss.org/browse/TEIID-4039 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/$entity/?$id=Customers(1... > *Returned status code:* 404 > *URL:* http://localhost:8080/odata4/olingo_basic/Source/$entity/?$id=Customers(1... > *Returned status code:* 500 > In this case response does not contain mandatory OData-version header and server throws exception: > {code:plain} > 12:20:40,911 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/odata4].[odata4]] (http-/127.0.0.1:8080-1) JBWEB000236: Servlet.service() for servlet odata4 threw exception: java.util.EmptyStackException > at java.util.Stack.peek(Stack.java:102) [rt.jar:1.8.0-internal] > at org.apache.olingo.server.core.uri.parser.UriParseTreeVisitor.visitSelectSegment(UriParseTreeVisitor.java:2195) > at org.apache.olingo.server.core.uri.antlr.UriParserParser$SelectSegmentContext.accept(UriParserParser.java:3611) > at org.apache.olingo.server.core.uri.parser.UriParseTreeVisitor.visitSelectItem(UriParseTreeVisitor.java:2168) > at org.apache.olingo.server.core.uri.antlr.UriParserParser$SelectItemContext.accept(UriParserParser.java:3541) > at org.apache.olingo.server.core.uri.parser.UriParseTreeVisitor.visitSelectEOF(UriParseTreeVisitor.java:2153) > at org.apache.olingo.server.core.uri.parser.Parser.parseUri(Parser.java:228) > at org.apache.olingo.server.core.ErrorHandler.handleServerError(ErrorHandler.java:93) > at org.apache.olingo.server.core.ErrorHandler.handleException(ErrorHandler.java:85) > at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:70) > at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:50) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar:1.0.2.Final-redhat-2] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:194) [teiid-olingo-8.12.5.redhat-2.jar:8.12.5.redhat-2] > at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:512) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.5.4.Final-redhat-4.jar:7.5.4.Final-redhat-4] > at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.5.11.Final-redhat-1.jar:7.5.11.Final-redhat-1] > at java.lang.Thread.run(Thread.java:744) [rt.jar:1.8.0-internal] > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4082) OData - null literal is not supported

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4082?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4082: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1318432|https://bugzilla.redhat.com/show_bug.cgi?id=1318432] from VERIFIED to CLOSED > OData - null literal is not supported > ------------------------------------- > > Key: TEIID-4082 > URL: https://issues.jboss.org/browse/TEIID-4082 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null,"message": "OData Library: An exception without message text was thrown."}} > *Expected result:* Return all entities where stringval equals _null_ > See: http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... > http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3971) Clob.getSubstring(int, int) returns empty or whole string

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3971?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3971: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1306679|https://bugzilla.redhat.com/show_bug.cgi?id=1306679] from VERIFIED to CLOSED > Clob.getSubstring(int,int) returns empty or whole string > -------------------------------------------------------- > > Key: TEIID-3971 > URL: https://issues.jboss.org/browse/TEIID-3971 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver, Query Engine > Affects Versions: 8.3 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5, 8.13.1, 8.7.3.6_2 > > > Method java.sql.Clob.getSubstring(int,int) returns either empty string (if second argument, length, is 0) or whole string (if length >= 1). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4146) Using JDG Library Mode, unable to perform insert (

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4146?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4146: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1327752|https://bugzilla.redhat.com/show_bug.cgi?id=1327752] from VERIFIED to CLOSED > Using JDG Library Mode, unable to perform insert ( > -------------------------------------------------- > > Key: TEIID-4146 > URL: https://issues.jboss.org/browse/TEIID-4146 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.0, 8.12.5 > > > Trying to run the JDG local cache quickstart, get the following error when trying to perform an insert: > 15:09:34,027 WARN [org.teiid.PROCESSOR] (Worker1_QueryProcessorQueue12) TEIID30020 Processing exception for request O25SlCY41bD5.6 'TEIID30492 Element StockCache.Stock.StockObject of StockCache.Stock is neither nullable nor has a default value. A value must be specified in the insert.'. Originally QueryValidatorException Request.java:330. Enable more detailed logging to see the entire stacktrace. > The issue is because the StockObject column is set to be NullType.unknown, instead of NullType.Nullable. This is because the metadata processor in the translator-object is setting it incorrectly. > Workaround: > - Using Teiid Designer to import the source model and change the null type. > - use dynamic vdb and define the DDL metadata to set the null type. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4007) Unparseable model name if user changes odata4 context root

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4007?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4007: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1313626|https://bugzilla.redhat.com/show_bug.cgi?id=1313626] from VERIFIED to CLOSED > Unparseable model name if user changes odata4 context root > ---------------------------------------------------------- > > Key: TEIID-4007 > URL: https://issues.jboss.org/browse/TEIID-4007 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.12.x > Reporter: Juraj Duráni > Assignee: Juraj Duráni > Fix For: 9.0, 8.12.5, 8.13.2 > > > If user changes root context of odata4 service, Teiid does not parse model name from the URI and throws TEIID16022 instead. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3621) HBase translator - UPDATE statement requires primary key

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3621?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3621: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1252333|https://bugzilla.redhat.com/show_bug.cgi?id=1252333] from VERIFIED to CLOSED > HBase translator - UPDATE statement requires primary key > -------------------------------------------------------- > > Key: TEIID-3621 > URL: https://issues.jboss.org/browse/TEIID-3621 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.7.1.6_2 > Environment: Hbase: 1.1.1 > Phoenix: 4.5.0-HBase-1.1 > Reporter: Juraj Duráni > Assignee: Kylin Soong > Fix For: 8.12 > > > The HBase translator requires table to have a primary key defined. Is the PK really needed? If the table has no PK defined, then all columns are PK. E.g. query *UPDATE hbase.SmallA SET StringNum = '555' WHERE hbase.SmallA.StringNum IS NULL* is translated as *UPSERT INTO smalla (stringnum, intkey) SELECT '555', smalla.intkey FROM smalla WHERE smalla.stringnum IS NULL* (intkey is PK). Teiid can simply add all columns (except those defined in 'SET'). > Yes, I know that HBase requires the PK to be defined, but what happen if a user decide to change PK in VDB [1]? It could be a problem whether PK is in VDB defined or not. > I suggest to add a hbase-translator-specific execution property which define PK in the source table and remove AssertionError [2]. > [1] > *HBase table:* create table mytable(id integer primary key, nickname varchar(1)) > *Teiid table:* create table mytable(id integer, username varchar(1) primary key) > Both, id and username, are valid PK (artificial/natural). > [2] > https://github.com/teiid/teiid/blob/master/connectors/translator-hbase/sr... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 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 2016