[teiid-issues] [JBoss JIRA] (TEIID-2519) Odata Table Query Not Workng

Thu May 30 09:29:54 EDT 2013

    [ https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12778225#comment-12778225 ] 

devin pinkston edited comment on TEIID-2519 at 5/30/13 9:28 AM:
----------------------------------------------------------------

I can see all of my data sources and their tables in Squirrel.  For example:

In Squirrel, I click on the Object Tab, I choose schoolsMySQL, TABLE, and i see 6 of my tables.  If i click on one of the tables for example "schools", i see these values:

catalogName	Portfolio
childTables	<null>
exportedKeys	<null>
importedKeys	<null>
qualifiedName	"schoolsMySQL"."baseballSchools.schools"
remarks	
schemaName	schoolsMySQL
simpleName	baseballSchools.schools
type	TABLE

      was (Author: pinkstondevin):
    I can see all of my data sources and their tables in Squirrel.  For example:

In Squirrel, I click on the Object Tab, I choose schoolsMySQL, TABLE, and i see 6 of my tables.  If i click on one of the tables for example "schools", i see these values:

Property Name	Value
catalogName	Portfolio
childTables	<null>
exportedKeys	<null>
importedKeys	<null>
qualifiedName	"schoolsMySQL"."baseballSchools.testmysqlbig"
remarks	
schemaName	schoolsMySQL
simpleName	baseballSchools.testmysqlbig
type	TABLE

> 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: 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/refinedSalaries</message></error>
> 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