[
https://issues.jboss.org/browse/TEIID-2519?page=com.atlassian.jira.plugin...
]
devin pinkston updated TEIID-2519:
----------------------------------
Attachment: portfolio-vdb.xml
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/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