7 Replies Latest reply on Feb 27, 2015 10:50 AM by blafond

problem defining primary key on view model entity

gmackinnon Aug 15, 2014 5:45 PM

I have a source relational model where some entities I want to expose via OData REST don't have a primary key. As you know, teiid OData support will not expose a given entity via REST unless the entity has either a primary key or unique constraint defined.

I also have a view model defined where i transform some entity names to make them more REST API resource model "friendly". This view model is also where I want to define some primary keys for entities in the source model that don't have primary keys.

I can define a primary key set on one given entity in my view model, but when I try to define a primary key set on a second entity in the view model the columns that are available for selection are those related to the first given entity I defined a primary key for. It would seem that one should only be able to select columns that are associated with the entity you're working with.

this occurs on teiid desinger 8.6, teiid 8.7, on windows.

It's entirely possible that I am going about defining the keys improperly. Is there a "best practice" as to how to go about defining the primary keys for a view model entity?

Thanks and Best Regards,

Greg

1. Re: problem defining primary key on view model entity

rareddy Aug 15, 2014 6:28 PM (in response to gmackinnon)

Greg,

Are you sure you did select "Primary key" not "Foreign Key"? If yes, that is bug. I quickly gave it a try on my Linux Designer and I did not see the same behavior as you are seeing.

Please log Teiid Designer JIRA for it.

As per the best practice, you right click on the View and "New Child" -> Primary Key. Then give it a name, then in properties box you select the column(s) that make up the primary key. Same for FK or index.

Ramesh..
Actions
2. Re: problem defining primary key on view model entity

gmackinnon Aug 18, 2014 5:23 PM (in response to rareddy)

Hi Ramesh,

Yes, this occurred when trying to define primary keys.

I'll log a Teiid Designer JIRA.

Thanks and Best Regards,
Greg
Actions
3. Re: problem defining primary key on view model entity

endy.brosens Feb 27, 2015 4:46 AM (in response to gmackinnon)

Greg,

Did you manage to work around this one? We are experiencing the same issue and we also like to define more than 1 entity per view model.

Best Regards,

Endy
Actions
4. Re: problem defining primary key on view model entity

rareddy Feb 27, 2015 9:25 AM (in response to endy.brosens)

What version of the Designer? We will double check this? I do not know if Greg ever filed a JIRA on this.
Actions
5. Re: problem defining primary key on view model entity

endy.brosens Feb 27, 2015 9:48 AM (in response to rareddy)

The Teiid version is 8.3.4.Final. There is a workaround, though. You can open the View Model with the standard Eclipse XML Editor and set the columns for the primary key using UUID's. Maybe that is why Greg did not register the JIRA issue.
Actions
6. Re: problem defining primary key on view model entity

rareddy Feb 27, 2015 9:54 AM (in response to endy.brosens)

Endy,

Can you log a JIRA for this please? That seems like bad hack. Glad you made it work

https://issues.jboss.org/browse/TEIIDDES

Ramesh..
Actions
7. Re: problem defining primary key on view model entity

blafond Feb 27, 2015 10:50 AM (in response to gmackinnon)

Greg,

I wasn't able to repeat your scenario using the Diagram/Explorer for selection and the Properties View editor for selecting PK columns.

I was able to repeat something similar if I used the Model Editor's "Table Editor" tab to edit/select the PK Columns.

Which scenario did you use?

Barry
Actions

Go to original post