I created a view containing the fields I wanted to access, but the
Entity Classes from Database feature doesn't include the view in the list of available tables.
I did some research and it looks like NB 6.5
may support views. (I'm using NB 6.1.)
I have a couple of options.
(1) Use data providers for queries involving more than one DB table. Display the results in a table component. Select the row I want to edit with and use simple JPA queries to get the specific row from the related tables. Display that information in editable fields and use JPA to update those tables.
(2) Create an entity class by hand and see if I can get that to work with views.
Option 1 seems easier to me.
I'll keep you posted.
Manuel Mall-2 wrote:
One possibility is to define a View at database level containing all the
fields you want and map that to a JPA entity. But I agree it could be argued
that this is also a form of duplication.
Any ads or links to ads that appear in this post are not endorsed nor recommended by this poster.
