0 Replies Latest reply on Apr 10, 2002 6:34 AM by Thomas Lauerbach

    View Entity Bean?

    Thomas Lauerbach Newbie

      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)