[
https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin...
]
Ramesh Reddy commented on TEIID-2519:
-------------------------------------
Still no good, I do not see any tables in your model at all. Where are other system models
like System and PG show up fine. If you want you can issue
http://localhost:8080/odata/portfolio.1/SYS.Tables
and see results. I still think there is an issue with your source. Again, use SquirreL to
log into Teiid VDB and see if you have tables under "schoolsMySQL" model. Can
you issue a "select * from {table}" from SquirreL?
if all else fails deploy this VDB
{code:title=loopy-vdb.xml}
<?xml version="1.0" encoding="UTF-8"
standalone="yes"?>
<vdb name="Loopy" version="1">
<model name="MarketData">
<source name="connector" translator-name="loopback" />
<metadata type="DDL"><![CDATA[
CREATE FOREIGN TABLE G1 (e1 string, e2 integer);
CREATE FOREIGN TABLE G2 (e1 string, e2 integer) OPTIONS (UPDATABLE
'true');
]]> </metadata>
</model>
</vdb>
{code}
and then go to
{code}
http://localhost:8080/odata/loopy.1/MarketData.G1
{code}
did that work?
Odata Table Query Not Workng
----------------------------
Key: TEIID-2519
URL:
https://issues.jboss.org/browse/TEIID-2519
Project: Teiid
Issue Type: Bug
Affects Versions: 8.3
Environment: CentOS, JBOSS AS 7.1.1, Teiid 8.3.
Reporter: devin pinkston
Assignee: Ramesh Reddy
Priority: Minor
Labels: odata,, service,, web
Fix For: 8.4
Attachments: metadata.txt, portfolio-vdb.xml, portfolio-vdb.xml
When trying to query a table through Odata, a error is diplayed: EdmEntitySet
refinedSalariesModel.refinedSalaries is not found
When issuing the query:
http://localhost:8080/odata/Portfolio.1/refinedSalariesModel.refinedSalaries
We have also tried using:
http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalaries
When issuing the second query, this error is thrown:
<error><code/><message lang="en-US">Could not find resource
for relative : /refinedSalariesModel/refinedSalaries of full path:
http://localhost:8080/odata/Portfolio.1/refinedSalariesModel/refinedSalar...
We can successfully display the metadata and see the details of the VDB by using:
http://localhost:8080/odata/Portfolio.1/$metadata
Please let me know if you need any more information
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira