[teiid-issues] [JBoss JIRA] (TEIID-2519) Odata Table Query Not Workng
devin pinkston (JIRA)
jira-events at lists.jboss.org
Thu May 30 13:45:55 EDT 2013
[ https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12778306#comment-12778306 ]
devin pinkston edited comment on TEIID-2519 at 5/30/13 1:45 PM:
----------------------------------------------------------------
I attached a new VDB with just a mysql data source which includes a source model "schoolsMySQL" The result of my metadata:
<edmx:Edmx Version="1.0"><edmx:DataServices m:DataServiceVersion="2.0"><Schema Namespace="schoolsMySQL"><EntityContainer Name="schoolsMySQL" m:IsDefaultEntityContainer="false"/></Schema><Schema Namespace="SYS"><EntityType Name="Columns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key>
was (Author: pinkstondevin):
I attached a new VDB with just a mysql data source which includes a source model "schoolsMySQL" The result of my metadata:
<edmx:Edmx Version="1.0"><edmx:DataServices m:DataServiceVersion="2.0"><Schema Namespace="schoolsMySQL"><EntityContainer Name="schoolsMySQL" m:IsDefaultEntityContainer="false"/></Schema><Schema Namespace="SYS"><EntityType Name="Columns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="false"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DataType" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="Scale" Type="Edm.Int32" Nullable="false"/><Property Name="Length" Type="Edm.Int32" Nullable="false"/><Property Name="IsLengthFixed" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsSelect" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsUpdates" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCaseSensitive" Type="Edm.Boolean" Nullable="false"/><Property Name="IsSigned" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCurrency" Type="Edm.Boolean" Nullable="false"/><Property Name="IsAutoIncremented" Type="Edm.Boolean" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="MinRange" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="MaxRange" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="DistinctCount" Type="Edm.Int32" Nullable="true"/><Property Name="NullCount" Type="Edm.Int32" Nullable="true"/><Property Name="SearchType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="Format" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DefaultValue" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="JavaClass" Type="Edm.String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="CharOctetLength" Type="Edm.Int32" Nullable="true"/><Property Name="Radix" Type="Edm.Int32" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.Columns_FK0" FromRole="Columns" ToRole="Tables"/><NavigationProperty Name="DataTypes" Relationship="SYS.Columns_FK1" FromRole="Columns" ToRole="DataTypes"/></EntityType><EntityType Name="DataTypes"><Key><PropertyRef Name="Name"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="IsStandard" Type="Edm.Boolean" Nullable="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="true"/><Property Name="TypeName" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="JavaClass" Type="Edm.String" Nullable="false" MaxLength="500" FixedLength="false" Unicode="true"/><Property Name="Scale" Type="Edm.Int32" Nullable="true"/><Property Name="TypeLength" Type="Edm.Int32" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="IsSigned" Type="Edm.Boolean" Nullable="false"/><Property Name="IsAutoIncremented" Type="Edm.Boolean" Nullable="false"/><Property Name="IsCaseSensitive" Type="Edm.Boolean" Nullable="false"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="Radix" Type="Edm.Int32" Nullable="true"/><Property Name="SearchType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="RuntimeType" Type="Edm.String" Nullable="true" MaxLength="64" FixedLength="false" Unicode="true"/><Property Name="BaseType" Type="Edm.String" Nullable="true" MaxLength="64" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Columns" Relationship="SYS.Columns_FK1" FromRole="DataTypes" ToRole="Columns"/><NavigationProperty Name="ProcedureParams" Relationship="SYS.ProcedureParams_FK1" FromRole="DataTypes" ToRole="ProcedureParams"/></EntityType><EntityType Name="KeyColumns"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="2048" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="KeyName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="KeyType" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="RefKeyUID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.KeyColumns_FK0" FromRole="KeyColumns" ToRole="Tables"/></EntityType><EntityType Name="Keys"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TableName" Type="Edm.String" Nullable="false" MaxLength="2048" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="IsIndexed" Type="Edm.Boolean" Nullable="false"/><Property Name="RefKeyUID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Tables" Relationship="SYS.Keys_FK0" FromRole="Keys" ToRole="Tables"/></EntityType><EntityType Name="ProcedureParams"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="ProcedureName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="ProcedureName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="DataType" Type="Edm.String" Nullable="false" MaxLength="25" FixedLength="false" Unicode="true"/><Property Name="Position" Type="Edm.Int32" Nullable="false"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true"/><Property Name="Optional" Type="Edm.Boolean" Nullable="false"/><Property Name="Precision" Type="Edm.Int32" Nullable="false"/><Property Name="TypeLength" Type="Edm.Int32" Nullable="false"/><Property Name="Scale" Type="Edm.Int32" Nullable="false"/><Property Name="Radix" Type="Edm.Int32" Nullable="false"/><Property Name="NullType" Type="Edm.String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="true" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Procedures" Relationship="SYS.ProcedureParams_FK0" FromRole="ProcedureParams" ToRole="Procedures"/><NavigationProperty Name="DataTypes" Relationship="SYS.ProcedureParams_FK1" FromRole="ProcedureParams" ToRole="DataTypes"/></EntityType><EntityType Name="Procedures"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="ReturnsResults" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="ProcedureParams" Relationship="SYS.ProcedureParams_FK0" FromRole="Procedures" ToRole="ProcedureParams"/><NavigationProperty Name="Schemas" Relationship="SYS.Procedures_FK0" FromRole="Procedures" ToRole="Schemas"/></EntityType><EntityType Name="Properties"><Key><PropertyRef Name="UID"/><PropertyRef Name="Name"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Value" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><Property Name="ClobValue" Type="Edm.Binary" Nullable="true"/></EntityType><EntityType Name="Schemas"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="PrimaryMetamodelURI" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Procedures" Relationship="SYS.Procedures_FK0" FromRole="Schemas" ToRole="Procedures"/><NavigationProperty Name="Tables" Relationship="SYS.Tables_FK0" FromRole="Schemas" ToRole="Tables"/></EntityType><EntityType Name="Tables"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Type" Type="Edm.String" Nullable="false" MaxLength="20" FixedLength="false" Unicode="true"/><Property Name="NameInSource" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsPhysical" Type="Edm.Boolean" Nullable="false"/><Property Name="SupportsUpdates" Type="Edm.Boolean" Nullable="false"/><Property Name="UID" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/><Property Name="Cardinality" Type="Edm.Int32" Nullable="false"/><Property Name="Description" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="IsSystem" Type="Edm.Boolean" Nullable="true"/><Property Name="IsMaterialized" Type="Edm.Boolean" Nullable="false"/><Property Name="OID" Type="Edm.Int32" Nullable="true"/><NavigationProperty Name="Columns" Relationship="SYS.Columns_FK0" FromRole="Tables" ToRole="Columns"/><NavigationProperty Name="KeyColumns" Relationship="SYS.KeyColumns_FK0" FromRole="Tables" ToRole="KeyColumns"/><NavigationProperty Name="Keys" Relationship="SYS.Keys_FK0" FromRole="Tables" ToRole="Keys"/><NavigationProperty Name="Schemas" Relationship="SYS.Tables_FK0" FromRole="Tables" ToRole="Schemas"/></EntityType><EntityType Name="VirtualDatabases"><Key><PropertyRef Name="Name"/><PropertyRef Name="Version"/></Key><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Version" Type="Edm.String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true"/></EntityType><ComplexType Name="getXMLSchemas_RSParam"><Property Name="schema" Type="Edm.Binary" Nullable="true"/></ComplexType><Association Name="Columns_FK0"><End Type="SYS.Columns" Multiplicity="*" Role="Columns"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Columns"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="Columns_FK1"><End Type="SYS.Columns" Multiplicity="*" Role="Columns"/><End Type="SYS.DataTypes" Multiplicity="0..1" Role="DataTypes"/><ReferentialConstraint><Principal Role="DataTypes"><PropertyRef Name="Name"/></Principal><Dependent Role="Columns"><PropertyRef Name="DataType"/></Dependent></ReferentialConstraint></Association><Association Name="KeyColumns_FK0"><End Type="SYS.KeyColumns" Multiplicity="*" Role="KeyColumns"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="KeyColumns"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="Keys_FK0"><End Type="SYS.Keys" Multiplicity="*" Role="Keys"/><End Type="SYS.Tables" Multiplicity="0..1" Role="Tables"/><ReferentialConstraint><Principal Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Keys"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="TableName"/></Dependent></ReferentialConstraint></Association><Association Name="ProcedureParams_FK0"><End Type="SYS.ProcedureParams" Multiplicity="*" Role="ProcedureParams"/><End Type="SYS.Procedures" Multiplicity="0..1" Role="Procedures"/><ReferentialConstraint><Principal Role="Procedures"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Principal><Dependent Role="ProcedureParams"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="ProcedureName"/></Dependent></ReferentialConstraint></Association><Association Name="ProcedureParams_FK1"><End Type="SYS.ProcedureParams" Multiplicity="*" Role="ProcedureParams"/><End Type="SYS.DataTypes" Multiplicity="0..1" Role="DataTypes"/><ReferentialConstraint><Principal Role="DataTypes"><PropertyRef Name="Name"/></Principal><Dependent Role="ProcedureParams"><PropertyRef Name="DataType"/></Dependent></ReferentialConstraint></Association><Association Name="Procedures_FK0"><End Type="SYS.Procedures" Multiplicity="*" Role="Procedures"/><End Type="SYS.Schemas" Multiplicity="0..1" Role="Schemas"/><ReferentialConstraint><Principal Role="Schemas"><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Procedures"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/></Dependent></ReferentialConstraint></Association><Association Name="Tables_FK0"><End Type="SYS.Tables" Multiplicity="*" Role="Tables"/><End Type="SYS.Schemas" Multiplicity="0..1" Role="Schemas"/><ReferentialConstraint><Principal Role="Schemas"><PropertyRef Name="VDBName"/><PropertyRef Name="Name"/></Principal><Dependent Role="Tables"><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/></Dependent></ReferentialConstraint></Association><EntityContainer Name="SYS" m:IsDefaultEntityContainer="false"><EntitySet Name="Columns" EntityType="SYS.Columns"/><EntitySet Name="DataTypes" EntityType="SYS.DataTypes"/><EntitySet Name="KeyColumns" EntityType="SYS.KeyColumns"/><EntitySet Name="Keys" EntityType="SYS.Keys"/><EntitySet Name="ProcedureParams" EntityType="SYS.ProcedureParams"/><EntitySet Name="Procedures" EntityType="SYS.Procedures"/><EntitySet Name="Properties" EntityType="SYS.Properties"/><EntitySet Name="Schemas" EntityType="SYS.Schemas"/><EntitySet Name="Tables" EntityType="SYS.Tables"/><EntitySet Name="VirtualDatabases" EntityType="SYS.VirtualDatabases"/><AssociationSet Name="Columns_FK0" Association="SYS.Columns_FK0"><End EntitySet="Columns" Role="Columns"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="Columns_FK1" Association="SYS.Columns_FK1"><End EntitySet="Columns" Role="Columns"/><End EntitySet="DataTypes" Role="DataTypes"/></AssociationSet><AssociationSet Name="KeyColumns_FK0" Association="SYS.KeyColumns_FK0"><End EntitySet="KeyColumns" Role="KeyColumns"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="Keys_FK0" Association="SYS.Keys_FK0"><End EntitySet="Keys" Role="Keys"/><End EntitySet="Tables" Role="Tables"/></AssociationSet><AssociationSet Name="ProcedureParams_FK0" Association="SYS.ProcedureParams_FK0"><End EntitySet="ProcedureParams" Role="ProcedureParams"/><End EntitySet="Procedures" Role="Procedures"/></AssociationSet><AssociationSet Name="ProcedureParams_FK1" Association="SYS.ProcedureParams_FK1"><End EntitySet="ProcedureParams" Role="ProcedureParams"/><End EntitySet="DataTypes" Role="DataTypes"/></AssociationSet><AssociationSet Name="Procedures_FK0" Association="SYS.Procedures_FK0"><End EntitySet="Procedures" Role="Procedures"/><End EntitySet="Schemas" Role="Schemas"/></AssociationSet><AssociationSet Name="Tables_FK0" Association="SYS.Tables_FK0"><End EntitySet="Tables" Role="Tables"/><End EntitySet="Schemas" Role="Schemas"/></AssociationSet><FunctionImport Name="getXMLSchemas" ReturnType="Collection(SYS.getXMLSchemas_RSParam)" m:HttpMethod="GET"><Parameter Name="document" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport></EntityContainer></Schema><Schema Namespace="SYSADMIN"><EntityType Name="MatViews"><Key><PropertyRef Name="VDBName"/><PropertyRef Name="SchemaName"/><PropertyRef Name="Name"/></Key><Property Name="VDBName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="SchemaName" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TargetSchemaName" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="TargetName" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="Valid" Type="Edm.Boolean" Nullable="true"/><Property Name="LoadState" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="Updated" Type="Edm.DateTime" Nullable="true"/><Property Name="Cardinality" Type="Edm.Int32" Nullable="true"/></EntityType><EntityType Name="VDBResources"><Key><PropertyRef Name="resourcePath"/></Key><Property Name="resourcePath" Type="Edm.String" Nullable="true" MaxLength="255" FixedLength="false" Unicode="true"/><Property Name="contents" Type="Edm.Binary" Nullable="true"/></EntityType><EntityContainer Name="SYSADMIN" m:IsDefaultEntityContainer="false"><EntitySet Name="MatViews" EntityType="SYSADMIN.MatViews"/><EntitySet Name="VDBResources" EntityType="SYSADMIN.VDBResources"/><FunctionImport Name="isLoggable" m:HttpMethod="POST"><Parameter Name="loggable" Type="Edm.Boolean" Nullable="false"/><Parameter Name="level" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="context" Type="Edm.String" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="logMsg" m:HttpMethod="POST"><Parameter Name="logged" Type="Edm.Boolean" Nullable="false"/><Parameter Name="level" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="context" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="msg" Type="Edm.Binary" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="refreshMatView" m:HttpMethod="POST"><Parameter Name="RowsUpdated" Type="Edm.Int32" Nullable="false"/><Parameter Name="ViewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Invalidate" Type="Edm.Boolean" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="refreshMatViewRow" m:HttpMethod="POST"><Parameter Name="RowsUpdated" Type="Edm.Int32" Nullable="false"/><Parameter Name="ViewName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Key" Type="Edm.Binary" Mode="In" Nullable="false"/></FunctionImport><FunctionImport Name="setColumnStats" m:HttpMethod="POST"><Parameter Name="tableName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="columnName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="distinctCount" Type="Edm.Int32" Mode="In" Nullable="true"/><Parameter Name="nullCount" Type="Edm.Int32" Mode="In" Nullable="true"/><Parameter Name="max" Type="Edm.String" Mode="In" Nullable="true"/><Parameter Name="min" Type="Edm.String" Mode="In" Nullable="true"/></FunctionImport><FunctionImport Name="setProperty" m:HttpMethod="POST"><Parameter Name="OldValue" Type="Edm.Binary" Nullable="false"/><Parameter Name="UID" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Name" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="Value" Type="Edm.Binary" Mode="In" Nullable="true"/></FunctionImport><FunctionImport Name="setTableStats" m:HttpMethod="POST"><Parameter Name="tableName" Type="Edm.String" Mode="In" Nullable="false"/><Parameter Name="cardinality" Type="Edm.Int32" Mode="In" Nullable="false"/></FunctionImport></EntityContainer></Schema><Schema Namespace="pg_catalog"><EntityType Name="matpg_datatype"><Key><PropertyRef Name="oid"/><PropertyRef Name="name"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="typname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="name" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="uid" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="typlen" Type="Edm.Int16" Nullable="true"/></EntityType><EntityType Name="matpg_relatt"><Key><PropertyRef Name="attname"/><PropertyRef Name="relname"/><PropertyRef Name="nspname"/></Key><Property Name="attrelid" Type="Edm.Int32" Nullable="true"/><Property Name="attnum" Type="Edm.Int16" Nullable="true"/><Property Name="attname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="relname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="nspname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="autoinc" Type="Edm.Boolean" Nullable="true"/><Property Name="typoid" Type="Edm.Int32" Nullable="true"/></EntityType><EntityType Name="pg_attribute"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="attrelid" Type="Edm.Int32" Nullable="true"/><Property Name="attname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="atttypid" Type="Edm.Int32" Nullable="true"/><Property Name="attlen" Type="Edm.Int16" Nullable="true"/><Property Name="attnum" Type="Edm.Int16" Nullable="true"/><Property Name="atttypmod" Type="Edm.Int32" Nullable="true"/><Property Name="attnotnull" Type="Edm.Boolean" Nullable="true"/><Property Name="attisdropped" Type="Edm.Boolean" Nullable="true"/><Property Name="atthasdef" Type="Edm.Boolean" Nullable="true"/></EntityType><EntityType Name="pg_class"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="relname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="relnamespace" Type="Edm.Int32" Nullable="true"/><Property Name="relkind" Type="Edm.String" Nullable="true"/><Property Name="relam" Type="Edm.Int32" Nullable="true"/><Property Name="reltuples" Type="Edm.Single" Nullable="true"/><Property Name="relpages" Type="Edm.Int32" Nullable="true"/><Property Name="relhasrules" Type="Edm.Boolean" Nullable="true"/><Property Name="relhasoids" Type="Edm.Boolean" Nullable="true"/></EntityType><EntityType Name="pg_index"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="indexrelid" Type="Edm.Int32" Nullable="true"/><Property Name="indrelid" Type="Edm.Int32" Nullable="true"/><Property Name="indnatts" Type="Edm.Int16" Nullable="true"/><Property Name="indisclustered" Type="Edm.Boolean" Nullable="true"/><Property Name="indisunique" Type="Edm.Boolean" Nullable="true"/><Property Name="indisprimary" Type="Edm.Boolean" Nullable="true"/><Property Name="indexprs" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="indkey" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/></EntityType><EntityType Name="pg_proc"><Key><PropertyRef Name="oid"/></Key><Property Name="oid" Type="Edm.Int32" Nullable="true"/><Property Name="proname" Type="Edm.String" Nullable="true" MaxLength="4000" FixedLength="false" Unicode="true"/><Property Name="proretset" Type="Edm.Boolean" Nullable="true"/><Property Name="prorettype" Type="Edm.Int32" Nullable="true"/><Property Name="pronargs" Type="Edm.Int16" Nullable="true"/><Property Name="proargtypes" Type="Edm.Binary" Nullable="true"/><Property Name="proargnames" Type="Edm.Binary" Nullable="true"/><Property Name="proargmodes" Type="Edm.Binary" Nullable="true"/><Property Name="proallargtypes" Type="Edm.Binary" Nullable="true"/><Property Name="pronamespace" Type="Edm.Int32" Nullable="true"/></EntityType><EntityContainer Name="pg_catalog" m:IsDefaultEntityContainer="false"><EntitySet Name="matpg_datatype" EntityType="pg_catalog.matpg_datatype"/><EntitySet Name="matpg_relatt" EntityType="pg_catalog.matpg_relatt"/><EntitySet Name="pg_attribute" EntityType="pg_catalog.pg_attribute"/><EntitySet Name="pg_class" EntityType="pg_catalog.pg_class"/><EntitySet Name="pg_index" EntityType="pg_catalog.pg_index"/><EntitySet Name="pg_proc" EntityType="pg_catalog.pg_proc"/></EntityContainer></Schema></edmx:DataServices></edmx:Edmx>
> 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/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
More information about the teiid-issues
mailing list