Bug 1214445 (TEIID-3451) - OData does not inject schema into queries
Summary: OData does not inject schema into queries
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: TEIID-3451
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.1.0
Hardware: All
OS: All
high
high
Target Milestone: ---
: One-off release
Assignee: jolee
QA Contact: Juraj Duráni
URL:
Whiteboard:
Depends On:
Blocks: 1213582
TreeView+ depends on / blocked
 
Reported: 2015-04-22 17:54 UTC by dsteigne
Modified: 2019-06-13 08:25 UTC (History)
7 users (show)

Fixed In Version:
Clone Of:
: 1215675 (view as bug list)
Environment:
Last Closed: 2016-02-10 08:49:48 UTC
Type: Support Patch
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-3451 0 Major Closed OData does not inject schema into queries 2016-01-26 13:58:57 UTC
Red Hat Knowledge Base (Solution) 1423353 0 None None None Never

Description dsteigne 2015-04-22 17:54:13 UTC
Description of problem:
The DV 6.1.0 OData service does not inject a fully qualified object names for tables for  POSTS, PUTs, and DELETEs:

12:50:34,367 DEBUG [org.teiid.COMMAND_LOG] (http-localhost/127.0.0.1:8080-1)    START USER COMMAND:     startTime=2015-04-22 12:50:34.367       requestID=XxHTbednhDq7.0        txID=null       sessionID=XxHTbednhDq7  applicationName=JDBC    principal=teiidUser@teiid-security      vdbName=ImsOne   vdbVersion=2    sql=INSERT INTO Subscription (SUBSCRIPTION_ID, CLIENT_NAME, DEST_CONNECTION_URI, DEST_SCHEMA_NAME, DEST_TABLE_NAME, PROVIDER_URL, TOPIC_NAME) VALUES (?, ?, ?, ?, ?, ?, ?)
12:50:34,380 DEBUG [org.teiid.COMMAND_LOG] (http-localhost/127.0.0.1:8080-1)    ERROR USER COMMAND:     endTime=2015-04-22 12:50:34.379 requestID=XxHTbednhDq7.0        txID=null       sessionID=XxHTbednhDq7  principal=teiidUser@teiid-security      vdbName=ImsOne  vdbVersion=2    finalRowCount=null
12:50:34,380 WARN  [org.teiid.PROCESSOR] (http-localhost/127.0.0.1:8080-1) TEIID30020 Processing exception for request XxHTbednhDq7.0 'Group specified is ambiguous, resubmit the query by fully qualifying the group name: Subscription'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
12:50:34,383 WARN  [org.teiid.ODATA] (http-localhost/127.0.0.1:8080-1) TEIID16012 Could not produce a successful OData response.  Returning status ServerErrorException with message Group specified is ambiguous, resubmit the query by fully qualifying the group name: Subscription.

Same insert works fine over JDBC.  Offending line from 8.7.0 public github:

https://github.com/teiid/teiid/blob/8.7.x/odata/src/main/java/org/teiid/odata/ODataSQLBuilder.java#L969

Note that private Table findTable() on line 925 depends upon org.odata4j.core.EdmEntitySet#getName to return the name, but this is not fully qualified

Version-Release number of selected component (if applicable):
6.1

How reproducible:


Steps to Reproduce:
1.
2.
3.

Actual results:


Expected results:


Additional info:


Document URL: 

Section Number and Name: 

Describe the issue: 

Suggestions for improvement: 

Additional information:

Comment 3 jolee 2015-05-19 15:34:34 UTC
integration	git:jboss-integration/teiid.git 
upstream	git:teiid/teiid.git

[jolee@jolee540 teiid]$ git push upstream TEIID-3451:8.7.x 
Counting objects: 40, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (27/27), done.
Writing objects: 100% (40/40), 3.86 KiB | 0 bytes/s, done.
Total 40 (delta 15), reused 7 (delta 0)
To git:teiid/teiid.git
   f31e342..73f2c71  TEIID-3451 -> 8.7.x

[jolee@jolee540 teiid]$ git push integration TEIID-3451:8.7.x-prod-ipv6.1 
Counting objects: 40, done.
Delta compression using up to 8 threads.
Compressing objects: 100% (27/27), done.
Writing objects: 100% (40/40), 4.08 KiB | 0 bytes/s, done.
Total 40 (delta 15), reused 7 (delta 0)
To git:jboss-integration/teiid.git
   f31e342..73f2c71  TEIID-3451 -> 8.7.x-prod-ipv6.1

Comment 4 JBoss JIRA Server 2015-06-22 15:22:57 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-3451 to Closed


Note You need to log in before you can comment on or make changes to this bug.