0 Replies Latest reply on Jan 13, 2004 8:10 AM by null null

    custom query for findByPrimaryKey for a CMP EJB - is it poss

    null null Newbie

      is it possible to define a custom query in deployment descriptor
      for findByPrimaryKey method for a CMP entity bean?

      I have a entity bean with compound/composite primary key. This PK
      is composed from 6 database columns, but only 3 columns are mandatory,
      other 3 columns are optional.
      Yes, it is bad DB design, but I couldn't change it easily.

      Maybe there is some other possible solution, but I cannot find any.

      I welcome every hint about handling composite PK with optional fields.