Hi all,
Is there a way to create an Entity Bean that represents a view to the Database.
My problem is:
I have a article with to types of prices. The prices are stored in two separate tables.
Via sql I would create to joins
article - pricetypeA
article - pricetypeB
Both tables have a to-n relation from article.
Is it possible to create a entity bean that collects its data over a join?
and
Can I define two finder methods that find my article and the corresponding price like:
Article findArticleAndPriceA( articleId, customerId)
Article findArticleAndPriceB( articleId, customerId)