[JBoss JIRA] (TEIID-4298) Support in Odata4 for the Partner NavigationProperty attribute
by Mirco Marchitiello (JIRA)
[ https://issues.jboss.org/browse/TEIID-4298?page=com.atlassian.jira.plugin... ]
Mirco Marchitiello updated TEIID-4298:
--------------------------------------
Description:
in Teiid 9.0 it would be useful to create a bidirectional link between tables, like in odata2
for example:
<EntityType Name="Product">
<Key>
<PropertyRef Name="ProductID"/>
</Key>
<Property Name="ProductID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
<Property Name="ProductName" Type="Edm.String" Nullable="false" MaxLength="40"/>
<Property Name="SupplierID" Type="Edm.Int32"/>
<Property Name="CategoryID" Type="Edm.Int32"/>
<Property Name="QuantityPerUnit" Type="Edm.String" MaxLength="20"/>
<Property Name="UnitPrice" Type="Edm.Decimal" Precision="19" Scale="4"/>
<Property Name="UnitsInStock" Type="Edm.Int16"/>
<Property Name="UnitsOnOrder" Type="Edm.Int16"/><Property Name="ReorderLevel" Type="Edm.Int16"/>
<Property Name="Discontinued" Type="Edm.Boolean" Nullable="false"/>
<NavigationProperty Name="Category" Type="NorthwindModel.Category" Partner="Products">
<ReferentialConstraint Property="CategoryID" ReferencedProperty="CategoryID"/>
</NavigationProperty>
<NavigationProperty Name="Order_Details" Type="Collection(NorthwindModel.Order_Detail)" Partner="Product"/>
<NavigationProperty Name="Supplier" Type="NorthwindModel.Supplier" Partner="Products">
<ReferentialConstraint Property="SupplierID" ReferencedProperty="SupplierID"/>
</NavigationProperty>
</EntityType>
<EntityType Name="Category">
<Key>
<PropertyRef Name="CategoryID"/>
</Key>
<Property Name="CategoryID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
<Property Name="CategoryName" Type="Edm.String" Nullable="false" MaxLength="15"/>
<Property Name="Description" Type="Edm.String" MaxLength="max"/>
<Property Name="Picture" Type="Edm.Binary" MaxLength="max"/>
<NavigationProperty Name="Products" Type="Collection(NorthwindModel.Product)" Partner="Category"/>
</EntityType>
It seems that the two tables are related through NavigationProperty and Partner
In fact I can see all the Categories of a certain Product
http://services.odata.org/V4/Northwind/Northwind.svc/Products(10)/Category
or viceversa the products of a certain Category
http://services.odata.org/V4/Northwind/Northwind.svc/Categories(8)/Products
Forum Reference: https://developer.jboss.org/message/959195?et=watches.email.thread#959195
> Support in Odata4 for the Partner NavigationProperty attribute
> --------------------------------------------------------------
>
> Key: TEIID-4298
> URL: https://issues.jboss.org/browse/TEIID-4298
> Project: Teiid
> Issue Type: Enhancement
> Components: OData
> Affects Versions: 9.0
> Reporter: Mirco Marchitiello
> Assignee: Steven Hawkins
>
> in Teiid 9.0 it would be useful to create a bidirectional link between tables, like in odata2
> for example:
> <EntityType Name="Product">
> <Key>
> <PropertyRef Name="ProductID"/>
> </Key>
> <Property Name="ProductID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
> <Property Name="ProductName" Type="Edm.String" Nullable="false" MaxLength="40"/>
> <Property Name="SupplierID" Type="Edm.Int32"/>
> <Property Name="CategoryID" Type="Edm.Int32"/>
> <Property Name="QuantityPerUnit" Type="Edm.String" MaxLength="20"/>
> <Property Name="UnitPrice" Type="Edm.Decimal" Precision="19" Scale="4"/>
> <Property Name="UnitsInStock" Type="Edm.Int16"/>
> <Property Name="UnitsOnOrder" Type="Edm.Int16"/><Property Name="ReorderLevel" Type="Edm.Int16"/>
> <Property Name="Discontinued" Type="Edm.Boolean" Nullable="false"/>
> <NavigationProperty Name="Category" Type="NorthwindModel.Category" Partner="Products">
> <ReferentialConstraint Property="CategoryID" ReferencedProperty="CategoryID"/>
> </NavigationProperty>
> <NavigationProperty Name="Order_Details" Type="Collection(NorthwindModel.Order_Detail)" Partner="Product"/>
> <NavigationProperty Name="Supplier" Type="NorthwindModel.Supplier" Partner="Products">
> <ReferentialConstraint Property="SupplierID" ReferencedProperty="SupplierID"/>
> </NavigationProperty>
> </EntityType>
> <EntityType Name="Category">
> <Key>
> <PropertyRef Name="CategoryID"/>
> </Key>
> <Property Name="CategoryID" Type="Edm.Int32" Nullable="false" p5:StoreGeneratedPattern="Identity"/>
> <Property Name="CategoryName" Type="Edm.String" Nullable="false" MaxLength="15"/>
> <Property Name="Description" Type="Edm.String" MaxLength="max"/>
> <Property Name="Picture" Type="Edm.Binary" MaxLength="max"/>
> <NavigationProperty Name="Products" Type="Collection(NorthwindModel.Product)" Partner="Category"/>
> </EntityType>
> It seems that the two tables are related through NavigationProperty and Partner
> In fact I can see all the Categories of a certain Product
> http://services.odata.org/V4/Northwind/Northwind.svc/Products(10)/Category
> or viceversa the products of a certain Category
> http://services.odata.org/V4/Northwind/Northwind.svc/Categories(8)/Products
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4129) Wrong results with cross model join on 2 varchar fields
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4129?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4129.
-----------------------------------
Resolution: Done
Updated the docs as well.
> Wrong results with cross model join on 2 varchar fields
> -------------------------------------------------------
>
> Key: TEIID-4129
> URL: https://issues.jboss.org/browse/TEIID-4129
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 6.0.0
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 9.1
>
> Attachments: H2 DBs.zip, MetaDataStores.zip
>
>
> I'm using Teiid 8.11.3 with H2 translator.
> I'm joining 2 h2 tables from 2 different teiid models linked on varchar fields.
> the query result is retuning empty values from the joined table even though the joined values are identical.
> You find attached a zip file containing 2 h2 DBs for a simplified example
> Here is the query used:
> _select "Customer"."City" as "Customer_City","Customer"."CustomerID" as "Customer_CustomerID","City"."City" as "City_City","City"."CityID" as "City_CityID"
> from "db2"."Customer" "Customer"
> LEFT JOIN "db1"."City" "City" ON "Customer"."City" = "City"."City"_
> Note that if the 2 tables are in the same model, the query return correct results.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4293) Some Management CLI should setAllowedValues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4293?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-4293:
---------------------------------------
keystore-type should not be limited.
> Some Management CLI should setAllowedValues
> -------------------------------------------
>
> Key: TEIID-4293
> URL: https://issues.jboss.org/browse/TEIID-4293
> Project: Teiid
> Issue Type: Enhancement
> Components: Server
> Affects Versions: 9.1
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 9.x
>
>
> * /subsystem=teiid:write-attribute(name=authentication-type,value=USERPASSWORD) - the allowed values should be USERPASSWORD,GSS
> * /subsystem=teiid:clear-cache(cache-type=PREPARED_PLAN_CACHE) - the cach-type allowed values should be PREPARED_PLAN_CACHE, QUERY_SERVICE_RESULT_SET_CACHE
> * /subsystem=teiid/transport=jdbc:write-attribute(name=protocol,value=teiid) - the protocol allowed values should be teiid, pg,?
> * /subsystem=teiid/transport=jdbc:write-attribute(name=keystore-type,value=JKS) - the keystore-type allowed values should be JKS, and ?
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4129) Wrong results with cross model join on 2 varchar fields
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4129?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-4129:
----------------------------------
Component/s: Query Engine
Fix Version/s: 9.1
Affects Version/s: 6.0.0
> Wrong results with cross model join on 2 varchar fields
> -------------------------------------------------------
>
> Key: TEIID-4129
> URL: https://issues.jboss.org/browse/TEIID-4129
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 6.0.0
> Reporter: Mark Tawk
> Assignee: Steven Hawkins
> Fix For: 9.1
>
> Attachments: H2 DBs.zip, MetaDataStores.zip
>
>
> I'm using Teiid 8.11.3 with H2 translator.
> I'm joining 2 h2 tables from 2 different teiid models linked on varchar fields.
> the query result is retuning empty values from the joined table even though the joined values are identical.
> You find attached a zip file containing 2 h2 DBs for a simplified example
> Here is the query used:
> _select "Customer"."City" as "Customer_City","Customer"."CustomerID" as "Customer_CustomerID","City"."City" as "City_City","City"."CityID" as "City_CityID"
> from "db2"."Customer" "Customer"
> LEFT JOIN "db1"."City" "City" ON "Customer"."City" = "City"."City"_
> Note that if the 2 tables are in the same model, the query return correct results.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-4200:
------------------------------------
> One major behavior change I see is data source creation and deletion now requires a server restart, that means we do not get notifications of data source removed to change the VDB validity correctly. So, even though the data source is deleted the VDB status will be "valid". May be we should look into redoing the validity of VDB.
Yes, a ds remove need a server restart, but only restart can make ds remove take effect.
* If ds removed, server not restart, vdb can work fine because the ds not really removed before server reload
* If ds removed, reload, a WARN "EIID30481 Failed to find the Connection Factory with JNDI name java:/accounts-ds. Please check the name or deploy the Connection Factory with specified name" will throw
So I think no need change in Teiid
> Provide support for Wildfly 10
> ------------------------------
>
> Key: TEIID-4200
> URL: https://issues.jboss.org/browse/TEIID-4200
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 9.1
>
>
> Upgrade the host runtime environment for Teiid Server to be WildFly 10.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years
[JBoss JIRA] (TEIID-4200) Provide support for Wildfly 10
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-4200?page=com.atlassian.jira.plugin... ]
Kylin Soong edited comment on TEIID-4200 at 6/24/16 6:13 AM:
-------------------------------------------------------------
h2. 1. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
Note that, if re-start server, the above error is gone.
h2. 2. domain install failed
teiid-domain-mode-install.cli execute failed, with error
{code}
'authentication-security-domain,distributed-cache-jgroups-stack' is not a valid parameter name.
{code}
the error caused by CLI
{code}
/profile=ha/subsystem=teiid:add(authentication-security-domain, distributed-cache-jgroups-stack=teiid-cluster, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
{code}
Note that, this error exist both wf 10 and wf 9.0.2 kits, in other words, teiid-9.0.0.Final also have this error.
h2. 3. Rest ExceptionMapper not work
The generated rest war's ExceptionMapper not work, raw exception trace throw in web page. This looks caused by undertow not support resteasy well, in other words, it's a undertow/wildfly issue, I will looks more laster.
was (Author: kylin):
h2. 1. IllegalStateException
While execute teiid-standalone-mode-install.cli, a IllegalStateException throw, this not only in WildFly 10 kits, it exist in all version, including 9.0.0.Final.
{code}
11:26:02,513 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("subsystem" => "teiid")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-odata.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
11:26:02,515 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0013: Operation ("add") failed - address: ([("deployment" => "teiid-olingo-odata4.war")]) - failure description: "WFLYCTL0158: Operation handler failed: java.lang.IllegalStateException: WFLYSRV0206: Multiple deployment unit processors registered with priority 65397 and class class org.teiid.jboss.DynamicVDBRootMountDeployer"
{code}
Note that, if re-start server, the above error is gone.
h2. 2. domain install failed
teiid-domain-mode-install.cli execute failed, with error
{code}
'authentication-security-domain,distributed-cache-jgroups-stack' is not a valid parameter name.
{code}
the error caused by CLI
{code}
/profile=ha/subsystem=teiid:add(authentication-security-domain, distributed-cache-jgroups-stack=teiid-cluster, resultset-cache-infinispan-container=teiid-cache, preparedplan-cache-infinispan-container=teiid-cache, policy-decider-module=org.jboss.teiid)
{code}
Note that, this error exist both wf 10 and wf 9.0.2 kits, in other words, teiid-9.0.0.Final also have this error.
> Provide support for Wildfly 10
> ------------------------------
>
> Key: TEIID-4200
> URL: https://issues.jboss.org/browse/TEIID-4200
> Project: Teiid
> Issue Type: Feature Request
> Components: Server
> Reporter: Ramesh Reddy
> Assignee: Ramesh Reddy
> Priority: Blocker
> Fix For: 9.1
>
>
> Upgrade the host runtime environment for Teiid Server to be WildFly 10.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years