Hi, 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.