[JBoss JIRA] (TEIID-2851) ODATA POST fails if table column is of IDENTITY type (sql server)
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2851?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-2851:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1110806
> ODATA POST fails if table column is of IDENTITY type (sql server)
> -----------------------------------------------------------------
>
> Key: TEIID-2851
> URL: https://issues.jboss.org/browse/TEIID-2851
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: OData
> Affects Versions: 8.6
> Reporter: Alex Khvatov
> Assignee: Ramesh Reddy
> Labels: Alpha3
> Fix For: 8.7
>
>
> While INSERT into virtual table created from a table that has IDENTITY (autoincrement) feild (in sql server) works if inserted via JDBC, POST to the same table using ODATA fails.
> I am attaching the stack trace we get.
> {code}
> 09:49:24,010 ERROR [org.teiid.ODATA] (http-localhost/127.0.0.1:8080-5) null TEIID16013 Error occured producing OData result.: java.lang.RuntimeException: No elements match the predicate
> at org.core4j.Enumerable.first(Enumerable.java:125) [core4j-0.5.jar:]
> at org.odata4j.core.OEntities$OEntityImpl.getProperty(OEntities.java:219) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
> at org.teiid.odata.ODataSQLBuilder.buildEntityKey(ODataSQLBuilder.java:1005) [classes:]
> at org.teiid.odata.TeiidProducer.createEntity(TeiidProducer.java:172) [classes:]
> at org.odata4j.producer.resources.EntitiesRequestResource.createEntity(EntitiesRequestResource.java:124) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
> at org.odata4j.producer.resources.EntitiesRequestResource.createEntity(EntitiesRequestResource.java:111) [odata4j-core-0.8.0-SNAPSHOT-redhat.jar:]
> at sun.reflect.GeneratedMethodAccessor150.invoke(Unknown Source) [:1.7.0_17]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) [rt.jar:1.7.0_17]
> at java.lang.reflect.Method.invoke(Unknown Source) [rt.jar:1.7.0_17]
> at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
> at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
> at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
> at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
> at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
> at org.teiid.odata.ODataServletContainerDispatcher.service(ODataServletContainerDispatcher.java:97) [classes:]
> at org.teiid.odata.ODataServlet.service(ODataServlet.java:61) [classes:]
> at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.6.Final-redhat-1.jar:2.3.6.Final-redhat-1]
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.2.0.Final-redhat-8.jar:7.2.0.Final-redhat-8]
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:336) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:920) [jbossweb-7.2.0.Final-redhat-1.jar:7.2.0.Final-redhat-1]
> at java.lang.Thread.run(Unknown Source) [rt.jar:1.7.0_17]
> {code}
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years
[JBoss JIRA] (TEIID-2981) Add an OData query parameter that caches the resultset
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-2981?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-2981.
-----------------------------------
Labels: Caching (was: Caching OData,)
Resolution: Done
Marking as resolved based upon setting the resulsetcachemode via a connection/execution property. Additional cache controls can be looked as needed.
> Add an OData query parameter that caches the resultset
> ------------------------------------------------------
>
> Key: TEIID-2981
> URL: https://issues.jboss.org/browse/TEIID-2981
> Project: Teiid
> Issue Type: Feature Request
> Security Level: Public(Everyone can see)
> Components: OData
> Affects Versions: 8.7
> Reporter: John Muller
> Assignee: Steven Hawkins
> Priority: Minor
> Labels: Caching
> Fix For: 8.8
>
>
> The Teiid caching guide indicates that the /*+ cache */ SQL hint is neccessary in order to cache results [1] . We would like two features added to the OData support: (1) to have a query parameter that basically injects the hint into the SQL statement run against the VDB and (2) a configuration setting that turns on OData resultset caching for all result sets smaller than some size (perhaps 256 as the default)
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years
[JBoss JIRA] (TEIID-3011) rewrite skipped
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3011?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3011.
-----------------------------------
Resolution: Done
Made the check more complete in the rewriter about when to skip.
> rewrite skipped
> ---------------
>
> Key: TEIID-3011
> URL: https://issues.jboss.org/browse/TEIID-3011
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.7.1, 8.7
>
>
> The rewrite of a set predicate is being bypassed when all of the in values are constants, but when pushed through a view with a convert on the left expression there is still optimizations that can be performed.
> For example:
> select * from (select e1, e2 from pm1.g1 union all select convert(e2, string), e2 from pm1.g2) x where e1 in ('1', '2')
> such that e1 is string and e2 is integer, we expect that the second branch will have criteria of the form "e2 in (1, 2)" - with no conversion.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years
[JBoss JIRA] (TEIID-3010) odata webapp missing joda time dependency
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3010?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3010.
-----------------------------------
Resolution: Done
Added joda time to the web app manifest.mf
> odata webapp missing joda time dependency
> -----------------------------------------
>
> Key: TEIID-3010
> URL: https://issues.jboss.org/browse/TEIID-3010
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: OData
> Affects Versions: 8.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.7.1, 8.8
>
>
> Usage of a datetime literal (datetime'2000-01-01T00:00:00) in a query, results in a no class def error:
> Caused by: java.lang.NoClassDefFoundError: org/joda/time/LocalDateTime
> at org.teiid.odata.ODataSQLBuilder.visit(ODataSQLBuilder.java:454) [classes:]
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years
[JBoss JIRA] (TEIID-3011) rewrite skipped
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3011?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration updated TEIID-3011:
-------------------------------------------
Bugzilla Update: Perform
Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1110409
> rewrite skipped
> ---------------
>
> Key: TEIID-3011
> URL: https://issues.jboss.org/browse/TEIID-3011
> Project: Teiid
> Issue Type: Bug
> Security Level: Public(Everyone can see)
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.7, 8.7.1
>
>
> The rewrite of a set predicate is being bypassed when all of the in values are constants, but when pushed through a view with a convert on the left expression there is still optimizations that can be performed.
> For example:
> select * from (select e1, e2 from pm1.g1 union all select convert(e2, string), e2 from pm1.g2) x where e1 in ('1', '2')
> such that e1 is string and e2 is integer, we expect that the second branch will have criteria of the form "e2 in (1, 2)" - with no conversion.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years
[JBoss JIRA] (TEIID-3011) rewrite skipped
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3011:
-------------------------------------
Summary: rewrite skipped
Key: TEIID-3011
URL: https://issues.jboss.org/browse/TEIID-3011
Project: Teiid
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Query Engine
Affects Versions: 7.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.7.1, 8.7
The rewrite of a set predicate is being bypassed when all of the in values are constants, but when pushed through a view with a convert on the left expression there is still optimizations that can be performed.
For example:
select * from (select e1, e2 from pm1.g1 union all select convert(e2, string), e2 from pm1.g2) x where e1 in ('1', '2')
such that e1 is string and e2 is integer, we expect that the second branch will have criteria of the form "e2 in (1, 2)" - with no conversion.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years
[JBoss JIRA] (TEIID-3006) Support Kerberos pass-thru to relational data sources
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3006?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3006.
-----------------------------------
Resolution: Migrated to another ITS
This is first an issue for JBoss JCA, then the parent TEIID-3005 is sufficient to ensure that the security context is set up correctly (which we believe it already is).
> Support Kerberos pass-thru to relational data sources
> -----------------------------------------------------
>
> Key: TEIID-3006
> URL: https://issues.jboss.org/browse/TEIID-3006
> Project: Teiid
> Issue Type: Sub-task
> Security Level: Public(Everyone can see)
> Components: JDBC Connector
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Support kerberos pass-thru to relational datasources. To start, would like to support these 5; oracle, db2, sql server, mysql and postgres.
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years
[JBoss JIRA] (TEIID-3010) odata webapp missing joda time dependency
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3010:
-------------------------------------
Summary: odata webapp missing joda time dependency
Key: TEIID-3010
URL: https://issues.jboss.org/browse/TEIID-3010
Project: Teiid
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: OData
Affects Versions: 8.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.7.1, 8.8
Usage of a datetime literal (datetime'2000-01-01T00:00:00) in a query, results in a no class def error:
Caused by: java.lang.NoClassDefFoundError: org/joda/time/LocalDateTime
at org.teiid.odata.ODataSQLBuilder.visit(ODataSQLBuilder.java:454) [classes:]
--
This message was sent by Atlassian JIRA
(v6.2.6#6264)
10 years