I have a CMP bean and I need to implements finder methods that have more flexibility such as unlimited number of parameters and dynamic queries for this bean.
I would like to know if there's a way to implement this without having to turn it to a BMP bean. What options do I have?
CMP is inherently limited. You might be able to get some of this functionality by using a server's proprietary extensions to EJB-QL, but in the long run you are probably better off coding the SQL yourself.
Depending on your needs, you may not have to resort to BMP. You might be able to use direct JDBC queries that transfer the data to Value Objects (aka Data Transfer Objects).