]
Steven Hawkins commented on TEIID-3451:
---------------------------------------
There are two issues here not caught by TEIID-3358. The insert statement creation is not
using the Table full name in the creation of the sql. Also as stated in the issue the
fully qualified entity set name is not used for the table lookup - although it was
considered to resolve the entityset.
OData does not inject schema into queries
-----------------------------------------
Key: TEIID-3451
URL:
https://issues.jboss.org/browse/TEIID-3451
Project: Teiid
Issue Type: Bug
Components: OData
Affects Versions: 8.7
Reporter: Debbie Steigner
Assignee: Steven Hawkins
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/o...
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